针对传统的ETL(Extract/Transform/Load)开发方法难以满足企业的决策需求,复杂性和高效性是ETL开发面临的两大主要问题。为此,在数据仓库系统统一集成建模框架下,为提高管理质量和快速性,提出一种数据仓库ETL元模型设计方法,取代了以往在特定的数据仓库中对ETL建模的方法,使得ETL过程较早地进入数据仓库设计阶段,实现了ETL与数据仓库在概念层上的无缝融合,减少了开发时间和成本代价。最后通过模型实际应用,验证了方法的可行性和高效性。
Traditional methods of ETL development are difficult to meet the Enterprise decision-making needs. Complexity and highly efficiency are the primary problems concerning ETL tools. To deal with theses problems,we put forward a method of designing the ETL meta-model in the Data warehouse,which takes the place of ETL modeling in the special data warehouse,and the design of ETL can be specified in the early stages of a DW project. It achieved the seamless integration between ETL and data warehouse designed on conceptual level,and reduced the development time and cost. Finally,we prove our approach usability and efficiency by practical application of this model.