Design ETL Meta-model In Data Warehouses
Liguo Yang
Abstract
Liguo Yang
Abstract
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.
A significance statement is not available in the OpenAlex record.
A contribution statement is not available in the OpenAlex record.
Method details are not available in the OpenAlex metadata.
Findings are not separately available in the OpenAlex metadata.
Limitations are not available in the OpenAlex metadata.
Application details are not available in the OpenAlex metadata.
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.
Key concepts: Data warehouse, Computer science, Database, Metamodeling, Usability, Dimensional modeling, Conceptual model, Online analytical processing