Author Login Editor-in-Chief Peer Review Editor Work Office Work

Computer Engineering ›› 2009, Vol. 35 ›› Issue (19): 91-93,9. doi: 10.3969/j.issn.1000-3428.2009.19.030

• Software Technology and Database • Previous Articles     Next Articles

ETL Models Mapping Approach Based on Model Driven

YAO Quan-zhu, BAI Min, HUANG Wei   

  1. (School of Computer Science & Engineering, Xi’an University of Technology, Xi’an 710048)
  • Received:1900-01-01 Revised:1900-01-01 Online:2009-10-05 Published:2009-10-05

基于模型驱动的ETL模型映射方法

姚全珠,白 敏,黄 蔚   

  1. (西安理工大学计算机科学与工程学院,西安 710048)

Abstract: Aiming at the characteristics of AP model, based on the formal definition of objects in meta-models, this paper proposes an improved design model and an optimized algorithm for mapping conceptual models to logical models. The algorithm can map the simple source or the multi- source models in the foundation of data Extract-Transformation-Load(ETL) workflow, and raises the efficiency of concurrent execution of state node. Experimental result proves that this method provides good foundation for the design of ETL based on model driven and rapid realization of ETL in data integration.

Key words: data Extract-Transformation-Load(ETL) technology, logical model, conceptual model, data integration

摘要: 针对AP模型的特点,给出元模型中对象的形式化定义,优化模型映射算法,提出一种基于模型驱动、从概念模型到逻辑模型的映射方法。改进后的算法能够映射基于数据抽取-加载-转换(ETL)工作流的单源数据或多源数据,并发执行各状态节点,提高了执行的效率。实验结果表明,该方法为模型驱动式ETL设计及数据集成中快速实现ETL奠定了良好基础。

关键词: 数据抽取-加载-转换技术, 逻辑模型, 概念模型, 数据集成

CLC Number: