为了使ETL系统能够高效的实现任意异构数据库之间的数据转换,需要通用的元模型支撑任意数据库之间数据转换元数据的定制。通过对数据转换中数据映射应用技术分析,重点对数据映射进行了抽象研究,定义数据映射的详细分类、基于数据映射关系的数据转换元数据描述形式,并构建支撑数据转换元数据定制的元模型,技术在中国石油数据中心大型数据迁移中应用,取得良好效果。
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.