| 基于工作流的数据抽取转换加载 |
| |
| 引用本文： | 谭支鹏,冯丹,吴永英,彭峰.基于工作流的数据抽取转换加载[J].华中科技大学学报(自然科学版),2006,34(2):61-63,69. |
| |
| 作者姓名： | 谭支鹏 冯丹 吴永英 彭峰 |
| |
| 作者单位： | 华中科技大学,计算机科学与技术学院,湖北,武汉,430074 |
| |
| 摘 要： | 将数据的抽取转换加载（ETL）过程和工作流技术结合起来，研究了ETL过程的工作流调度问题，设计了一种简单串行和稳定可靠的循环遍历算法．为了提高ETL效率，将并行机制引入到节点访问算法中，对节点访问算法进行了改进，设计了新的节点访问算法，并讨论了加入并行机制后可能会遇到的数据源并发控制等问题，并给出了解决方法．所提出的方法对提高数据集成效率很有效，在国产数据库系统的应用中可起到积极推动作用．
|
| 关 键 词： | 数据的抽取转换加载 数据仓库 数据迁移 工作流 |
| 文章编号： | 1671-4512（2006）02-0061-03 |
| 收稿时间： | 01 7 2005 12:00AM |
| 修稿时间： | 2005-01-07 |
Workflow-based extraction and transformation-loading of data |
| |
| Tan Zhipeng,Feng Dan,Wu Yongying,Peng Feng.Workflow-based extraction and transformation-loading of data[J].JOURNAL OF HUAZHONG UNIVERSITY OF SCIENCE AND TECHNOLOGY.NATURE SCIENCE,2006,34(2):61-63,69. |
| |
| Authors: | Tan Zhipeng Feng Dan Wu Yongying Peng Feng |
| |
| Abstract: | In data warehouse, lots of operation for data transformation is needed. It is an important issue how to manage extraction-transformation-loading of data. ETL process should be managed and controlled flexibly. The article studies the concept and definition of the process of workflow, And gives a way which modeling the ETL process workflow as a directional graph named workflow graph and designed two scheduling arithmetic. Parallel schedule is one of best ways for ETL, it has impetus for implement of native database system. |
| |
| Keywords: | extraction-transformation-loading data warehouse data transformation workflow |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
