| 数据仓库系统中Excel文档数据的ETL方法研究与实现 |
| |
| 引用本文： | 周大海,安云哲,夏秀峰,于戈.数据仓库系统中Excel文档数据的ETL方法研究与实现[J].小型微型计算机系统,2007,28(10):1813-1816. |
| |
| 作者姓名： | 周大海 安云哲 夏秀峰 于戈 |
| |
| 作者单位： | 1. 沈阳航空工业学院,计算机学院,辽宁,沈阳,110034
2. 东北大学,信息科学与工程学院,辽宁,沈阳,110004 |
| |
| 基金项目： | 国家科技型中小企业技术创新基金 |
| |
| 摘 要： | 数据仓库的数据来源于组织内部的OLTP系统和其它格式的内部、外部数据,它们之中的许多是按照Microsoft Excel格式予以组织的,如何通过ETL程序将该格式的数据转换成数据仓库中有用的信息是目前亟待解决的问题.首先叙述了Excel文件的结构和Java Excel API的使用方法,给出了Java读取Excel文档的操作步骤,结合实例说明了从Excel文件向数据仓库实现抽取及存储的过程和方法.
|
| 关 键 词： | 数据仓库 外部数据 Excel文档 |
| 文章编号： | 1000-1220（2007）10-1813-04 |
| 修稿时间： | 2006-07-03 |
Study and Implementation on ETL Strategies of Excel Documents in Data Warehouse System |
| |
| ZHOU Da-hai,AN Yun-zhe,XIA Xiu-feng,YU Ge.Study and Implementation on ETL Strategies of Excel Documents in Data Warehouse System[J].Mini-micro Systems,2007,28(10):1813-1816. |
| |
| Authors: | ZHOU Da-hai AN Yun-zhe XIA Xiu-feng YU Ge |
| |
| Affiliation: | 1.School of Compute, Shenyang Institute of Aeronautical Engineering, Shenyang 110034, China;2.School of Information Science and Engineering, Northeastern University, Shenyang 110004, China |
| |
| Abstract: | The data in data warehouse are obtained from organization's internal OLTP system and other format's internal or external data,in which many of them are organized in Microsoft Excel format.It must be solved urgently at present that how to transform the Excel format's data to the useful information of data warehouse.After analyzing the Excel document structure and Java Excel API application method,the operation approach of reading Excel document by Java program is discussed,and the process and strategies implementing and storing the Excel data to data warehouse are illustrated combined with an instance. |
| |
| Keywords: | ETL |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
