本文已被：浏览 2137次 下载 3470次
Received:November 04, 2011 Revised:December 30, 2011
Received:November 04, 2011 Revised:December 30, 2011
中文摘要: 为了使ETL系统能够高效的实现任意异构数据库之间的数据转换,需要通用的元模型支撑任意数据库之间数据转换元数据的定制。通过对数据转换中数据映射应用技术分析,重点对数据映射进行了抽象研究,定义数据映射的详细分类、基于数据映射关系的数据转换元数据描述形式,并构建支撑数据转换元数据定制的元模型,技术在中国石油数据中心大型数据迁移中应用,取得良好效果。
Abstract:In order to enable the ETL system to effective achieve any data conversion between heterogeneous databases, we need a common meta-model for support the data conversion metadata customization. Through the analysis of the application of data mapping technical in the data conversion, research has been focused on the abstract study of data mapping, and defined the detailed classification of data mapping, and the form of data conversion metadata based on data mapping, build the meta-model which support to the custom data transformation metadata. The technology has been applied well in large-scale data migration of China's oil data centers.
keywords: data mapping data conversion ETL meta-model data migration
文章编号： 中图分类号： 文献标志码：
基金项目:国家自然科学基金(61170132);黑龙江省自然基金(11541008)
引用文本：
梁吉胜,李天阳,王惠霞,杨锐,张旭东.数据映射技术在ETL过程中的应用.计算机系统应用,2012,21(7):155-159
LIANG Ji-Sheng,LI Tian-Yang,WANG Hui-Xia,YANG Rui,ZHANG Xu-Dong.Application of Data Mapping Technology to the ETL Process.COMPUTER SYSTEMS APPLICATIONS,2012,21(7):155-159
梁吉胜,李天阳,王惠霞,杨锐,张旭东.数据映射技术在ETL过程中的应用.计算机系统应用,2012,21(7):155-159
LIANG Ji-Sheng,LI Tian-Yang,WANG Hui-Xia,YANG Rui,ZHANG Xu-Dong.Application of Data Mapping Technology to the ETL Process.COMPUTER SYSTEMS APPLICATIONS,2012,21(7):155-159
