2010Unpublished venueRequires access

One CWM-Based Data Transformation Method in ETL Process

Ying Pei, Jungang Xu, Qiang Wang

Open publisher page 3 citations

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.

About this research paper

What this paper is about

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.

Why it matters

OpenAlex reports 3 citations for this work. Citation counts describe recorded attention and do not establish research quality.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available 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.

Key concepts: Metadata, Computer science, Data warehouse, Cwm, Process (computing), Metadata management, Data transformation, Database

Related papers

Back to paper searchBrowse research topicsOriginal source
One CWM-Based Data Transformation Method in ETL Process — Research Paper | ScholarLens