Title :
Novel approach in ETL
Author :
Prema, A. ; Pethalakshmi, A.
Author_Institution :
Dept. of R&D, Bharathiar Univ., Coimbatore, India
Abstract :
The term ETL which stands for Extraction, Transformation, and Loading is a batch or scheduled data integration process that includes extracting data from their operational or external data sources, transforming the data into an appropriate format, and loading the data into a data warehouse repository. Through the study of Extract, Transform, and Load (ETL) hypothesis, a new ETL is designed, which is titled as Hyper-ETL for increasing an efficiency of ETL process. Hyper-ETL allows the integration of XML document file and Oracle data warehouse to reduce an execution time and to remove the mismanagement of metadata in an existing ETL process.
Keywords :
XML; data integration; data warehouses; document handling; meta data; ETL design; Hyper-ETL; Oracle data warehouse; XML document file; batch data integration process; data extraction; data loading; data source; data transformation; data warehouse repository; extensible markup language; extraction-transformation-loading; metadata management; scheduled data integration process; Business; Data mining; Data warehouses; Databases; Loading; Transforms; XML; Data Warehouse; ETL; Key Words; Oracle; XML; metadata;
Conference_Titel :
Pattern Recognition, Informatics and Mobile Engineering (PRIME), 2013 International Conference on
Conference_Location :
Salem
Print_ISBN :
978-1-4673-5843-9
DOI :
10.1109/ICPRIME.2013.6496515
