Design and Implementation of ETL Management Tool

Author

Ying-lan, Fang ; Bing, Han

Author_Institution

Coll. of Inf. Eng., North China Univ. of Technol., Beijing, China

Volume

1

fYear

2009

fDate

Nov. 30 2009-Dec. 1 2009

Firstpage

446

Lastpage

449

Abstract

ETL is an important foundation of building data warehouse. Users extract the required data from the data source. and after clean the data, in accordance with pre-defined model of good data warehouse, data will be loaded into the data warehouse .The article has designed and implemented a common management tool for ETL according to the principle of ETL and the project actual needs. It can not only support DB2, Oracle, SQL Server and MYSQL and so on databases conversions but also itself custom extraction, conversion rules, and may have deploy scheduling tasks at any time. ETL management tool provides a good application platform for data analysis in decision-making.

Keywords

SQL; data handling; data warehouses; DB2; ETL management tool; MYSQL; Oracle; SQL Server; data analysis; data extraction; data warehouse; databases conversions; decision making; Data analysis; Data mining; Data warehouses; Databases; Decision making; Decision support systems; Knowledge acquisition; Monitoring; System analysis and design; Technology management; ETL; conversion rule; data; database; extract rule;

fLanguage

English

Publisher

ieee

Conference_Titel

Knowledge Acquisition and Modeling, 2009. KAM '09. Second International Symposium on

Conference_Location

Wuhan

Print_ISBN

978-0-7695-3888-4

Type

conf

DOI

10.1109/KAM.2009.105

Filename

5362117