One CWM-Based Data Transformation Method in ETL Process

Author

Pei, Ying ; Xu, Jungang ; Wang, Qiang

Author_Institution

Sch. of Inf. Sci. & Eng., Grad. Univ. of Chinese Acad. of Sci., Beijing, China

fYear

2010

fDate

27-28 Nov. 2010

Firstpage

1

Lastpage

4

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.

Keywords

data analysis; data mining; data warehouses; meta data; storage management; CWM based data transformation method; ETL process; ETL tool; command center; common warehouse meta model; data analysis; data mining; data storage management; data warehousing; metadata; open industry metadata standard; public metamodel; Business; Data mining; Data models; Data warehouses; Loading; Unified modeling language; Warehousing;

fLanguage

English

Publisher

ieee

Conference_Titel

Database Technology and Applications (DBTA), 2010 2nd International Workshop on

Conference_Location

Wuhan

Print_ISBN

978-1-4244-6975-8

Electronic_ISBN

978-1-4244-6977-2

Type

conf

DOI

10.1109/DBTA.2010.5658928

Filename

5658928