DocumentCode :
629761
Title :
A web-based ETL tool for data integration process
Author :
Vijayendra, Nithin ; Meiliu Lu
Author_Institution :
California State Univ., Sacramento, CA, USA
fYear :
2013
fDate :
6-8 June 2013
Firstpage :
434
Lastpage :
438
Abstract :
Extract, Transform and Load (ETL) is a fundamental process used to populate a data warehouse and an important step towards data integration which is a key step for data preprocessing for many data mining projects. The objective of this project is to create a simple web based ETL tool which can be accessed by anyone with internet access. This ETL tool is also supported by a brief on-line tutorial on ETL process. The combination of tool and tutorial makes an ideal self-paced interactive learning tool for a beginning ETL learner. Guests will have limited access to this tool and registered users can have complete access. Using this tool, data can be extracted from text files or MySQL tables, integrated and loaded into target MySQL tables. Before loading the data into target MySQL tables, various transformations can also be applied to them.
Keywords :
Internet; SQL; computer aided instruction; computer science education; data integration; data mining; data warehouses; interactive systems; text analysis; ETL learner; Internet access; MySQL tables; Web-based ETL tool; data integration process; data loading; data mining projects; data preprocessing; data warehouse; extract-transform-and-load tool; ideal self-paced interactive learning tool; online tutorial; text files; Business; Connectors; Data mining; Data warehouses; Databases; Educational institutions; Servers; data integration; data warehousing; self-paced learning, ETL tools;
fLanguage :
English
Publisher :
ieee
Conference_Titel :
Human System Interaction (HSI), 2013 The 6th International Conference on
Conference_Location :
Sopot
ISSN :
2158-2246
Print_ISBN :
978-1-4673-5635-0
Type :
conf
DOI :
10.1109/HSI.2013.6577861
Filename :
6577861
Link To Document :
بازگشت