【作者】 张晓明； 林小竹；

【机构】 北京石油化工学院信息工程学院；

【摘要】 <正>1引言当前,数据仓库的构建与应用研究日趋广泛,从数据的质量获取方面,最为关注的是ETL(Extraction,Cleaning,Transformation,and Loading)技术。ETL技术包括数据抽取、数据清洗、数据转换和数据装载四个子过程,这些子过程可能单独存在,更多还原

【Abstract】 An ETL(data extraction,cleaning,transformation and loading)development framework is constructed to meet the need of data quality in distributed system.The framework is composed of three parts of process model,development methodology and component description.A kind of network mapping diagram is designed for the methodology model with development method,technique,template and component XML-based method is described for the data extraction sub-process model with XML Schema structure.For the XML-based ETL component description, five facets of Header,Deployment,Form,Function and Implementation are designed with a detailed statement of case study on data cleaning component description.The methodology and XML-based component description will be helpful for the development and management of ETL process.更多还原