Title :
A web-based ETL tool for data integration process
Author :
Vijayendra, Nithin ; Meiliu Lu
Author_Institution :
California State Univ., Sacramento, CA, USA
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;
Conference_Titel :
Human System Interaction (HSI), 2013 The 6th International Conference on
Conference_Location :
Sopot
Print_ISBN :
978-1-4673-5635-0
DOI :
10.1109/HSI.2013.6577861