Data Warehouse plays an important part in the process of decision-making for Enterprise, as a key component of the data warehouse architecture, the tool that support data extraction, transformation, loading(ETL, Extract \ Transformation \ Load) is a critical success factor for any data warehouse projects. Traditional methods of ETL development are difficulty to meet the Enterprise decision-making needs. To deal with these problems, we put forward a method of designing the ETL meta-model based on an integrated modeling framework of DW, which takes 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, reduced the development time and cost. Finally, we prove our approach usability and efficiency by practical application of this model.
[1]
Timos K. Sellis,et al.
ARKTOS: towards the modeling, design, control and execution of ETL processes
,
2001,
Inf. Syst..
[2]
Zhou Liang.
Design and Implementation of Standard ETL Tool Based on CWM
,
2006
.
[3]
Panos Vassiliadis,et al.
A generic and customizable framework for the design of ETL scenarios
,
2005,
Inf. Syst..
[4]
Alkis Simitsis,et al.
Mapping conceptual to logical models for ETL processes
,
2005,
DOLAP '05.
[5]
Juan Trujillo,et al.
A UML 2.0 profile to design Association Rule mining models in the multidimensional conceptual modeling of data warehouses
,
2007,
Data Knowl. Eng..