作者投稿和查稿 主编审稿 专家审稿 编委审稿 远程编辑

计算机工程 ›› 2009, Vol. 35 ›› Issue (19): 91-93,9. doi: 10.3969/j.issn.1000-3428.2009.19.030

• 软件技术与数据库 • 上一篇    下一篇

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

姚全珠,白 敏,黄 蔚   

  1. (西安理工大学计算机科学与工程学院,西安 710048)
  • 收稿日期:1900-01-01 修回日期:1900-01-01 出版日期:2009-10-05 发布日期:2009-10-05

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

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

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

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

中图分类号: