Title :
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
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;
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
DOI :
10.1109/DBTA.2010.5658928
