| 数据仓库中数据抽取、转换及加载工具研究 |
| |
| 引用本文： | 周志逵,徐先传. 数据仓库中数据抽取、转换及加载工具研究[J]. 北京理工大学学报, 2003, 23(6): 720-723 |
| |
| 作者姓名： | 周志逵 徐先传 |
| |
| 作者单位： | 北京理工大学,信息科学技术学院计算机科学工程系,北京,100081 |
| |
| 摘 要： | 分析数据仓库体系结构，描述数据加载过程中的不同实现方法．在实现过程中引入工作流的思想，提出了一种以工作流为模式的基于元数据的ETL模型，将数据加载分解成可配制的具有不同语义的过程，并给出了相关元素的定义，提供了一个可配置的具有良好伸缩性的ETL解决方案。
|
| 关 键 词： | 数据仓库 工作流 数据加载 |
| 文章编号： | 1001-0645(2003)06-0720-04 |
| 收稿时间： | 2002-10-28 |
| 修稿时间： | 2002-10-28 |
Data Extraction, Transformation and Loading Tools in a Data Warehouse |
| |
| ZHOU Zhi-kui and XU Xian-chuan. Data Extraction, Transformation and Loading Tools in a Data Warehouse[J]. Journal of Beijing Institute of Technology(Natural Science Edition), 2003, 23(6): 720-723 |
| |
| Authors: | ZHOU Zhi-kui and XU Xian-chuan |
| |
| Affiliation: | Department of Computer Science and Engineering, School of Information Science and Technology, Beijing Institute of Technology, Beijing100081, China;Department of Computer Science and Engineering, School of Information Science and Technology, Beijing Institute of Technology, Beijing100081, China |
| |
| Abstract: | Studies the data warehouse architecture and illustrates different methods of data loading. In the process of implementation, the idea of workflow is introduced. A series of tools are proposed and discussed for data extraction, cleansing, transformation and loading, that are based on the management of metadata and workflow. Some concepts which describe the elements of ETL process are defined. A solution is proposed as a scalable, configurable and effective way out for data migration. |
| |
| Keywords: | data warehouse workflow data loading |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
| 点击此处可从《北京理工大学学报》浏览原始摘要信息 |
|
点击此处可从《北京理工大学学报》下载全文 |
