Novel approach in ETL

Author

Prema, A. ; Pethalakshmi, A.

Author_Institution

Dept. of R&D, Bharathiar Univ., Coimbatore, India

fYear

2013

fDate

21-22 Feb. 2013

Firstpage

429

Lastpage

434

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;

fLanguage

English

Publisher

ieee

Conference_Titel

Pattern Recognition, Informatics and Mobile Engineering (PRIME), 2013 International Conference on

Conference_Location

Salem

Print_ISBN

978-1-4673-5843-9

Type

conf

DOI

10.1109/ICPRIME.2013.6496515

Filename

6496515