Title :
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
fDate :
Nov. 30 2009-Dec. 1 2009
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;
Conference_Titel :
Knowledge Acquisition and Modeling, 2009. KAM '09. Second International Symposium on
Conference_Location :
Wuhan
Print_ISBN :
978-0-7695-3888-4
DOI :
10.1109/KAM.2009.105
