摘要
近年来,随着计算机技术和数据库技术的不断进步,固井行业大量数据异构、分布存储的现象日趋明显。如何利用有效的方法整合数据从而指导决策成为了决策者所关心的问题。ETL系统为数据整合提供了令人满意的解决方案。它集数据抽取、清洗、转换、装载等任务与一身,不但满足用户对异构数据源进行整合的需求,也实现了数据的后期更新。本文固井数据仓库ETL系统的设计提出了一种基于元数据的ETL体系结构,并重点设计了元数据管理模块和异构数据转换模块。
In recent years,with computer technology and advances in database technology,cementing the industry large amounts of data distributed and heterogeneous storage is gaining momentum.Effective way to integrate the use of data to guide decision-making has become a concern to policy makers..ETL system for data integration provides a satisfying solution.It can complete many tasks,such as data extraction,cleaning,transforming and loading etc,meet the needs of heterogeneous data source integration and also realize to update data.The article designs ETL system for drilling data warehouse which is based on a metadata ETL architecture,and focus on metadata management module and heterogeneous data conversion module.
出处
《内蒙古石油化工》
CAS
2011年第15期39-41,共3页
Inner Mongolia Petrochemical Industry
