One CWM-Based Data Transformation Method in ETL Process
Ying Pei, Jungang Xu, Qiang Wang
Abstract
Ying Pei, Jungang Xu, Qiang Wang
Abstract
Metadata is the command center in the process of data warehousing,and which is very helpful to data ETL (Extraction, Transformation and Loading), data storage management,data analysis and data mining.CWM (Common Warehouse Meta-model) is an open industry metadata standard,and which is widely used currently,public meta-models and its rules defined in CWM can properly support data transformation and cleansing.One metadata-driven development approach is proposed to support the design and development of data ETL process.One data transformation module is realized, and which is used to specify how to use metadata in ETL process. Finally, the development process and steps of using CWM to build ETL tool are given.
OpenAlex reports 3 citations for this work. Citation counts describe recorded attention and do not establish research quality.
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.
Metadata is the command center in the process of data warehousing,and which is very helpful to data ETL (Extraction, Transformation and Loading), data storage management,data analysis and data mining.CWM (Common Warehouse Meta-model) is an open industry metadata standard,and which is widely used currently,public meta-models and its rules defined in CWM can properly support data transformation and cleansing.One metadata-driven development approach is proposed to support the design and development of data ETL process.One data transformation module is realized, and which is used to specify how to use metadata in ETL process. Finally, the development process and steps of using CWM to build ETL tool are given.
Key concepts: Metadata, Computer science, Data warehouse, Cwm, Process (computing), Metadata management, Data transformation, Database