The week's pick
Reseach Article
The Management of Conformed ETL Architecture
| International Journal of Computer Applications |
| Foundation of Computer Science (FCS), NY, USA |
| Volume 118 - Number 10 |
| Year of Publication: 2015 |
| Authors: Ashima Jain, Sonam Garg, Neha Sharma |
10.5120/20781-3354
|
Ashima Jain, Sonam Garg, Neha Sharma . The Management of Conformed ETL Architecture. International Journal of Computer Applications. 118, 10 ( May 2015), 20-22. DOI=10.5120/20781-3354
Abstract
This paper deals with the core research on the architecture of ETL process which is applied on BI environment along with the advent of metadata at each corresponding layer that can be applicable to all the scenarios of BI. The management of extraction process has been done using several operators which help in reducing its complexity. New operators have been developed to easily understand each and every layer of extraction process. ETL stands for extraction, transformation and loading, and it plays a vital role in the area of business intelligence. Extraction is the process of extracting heterogeneous data from disparate source system for further analysis in a data warehouse environment. Transformation is a process of storing data in a correct, unambiguous and consistent format which is compatible to the format of existing data warehouse. Loading is a process that loads data into the end target which may be simply a data warehouse or a data mart.
References
- H. J. Watson and B. H. Wixom. The current state of business intelligence. Computer, 40(9):96-99
- Nitin Anand, ETL and its impact on Business Intelligence, International Journal of Scientific and Research Publications, Volume 4, Issue 2, February 2014 1 ISSN 2250-3153
- Bo Liu and Yushun Fan, Research on Architecture and Key Technology for Service-Oriented Workflow Performance Analysis, Department of Automation, Tsinghua University, Beijing 100084, China
- Alexander Albrecht Felix Naumann, Managing ETL Processes, Hasso Plattner Institute at the University of Potsdam, German
- Huong Morris*, {Hui Liao, Sriram Padmanabhan, Sriram Srinivasan}, a. {Phay Lau, Jing Shan, Ryan Wisnesky}**, Bringing Business Objects into Extract-Transform-Load (ETL) Technology, IBM T. J. Watson Research, 19 Skyline Drive, Hawthorne, NY 10532.
- Panos Vassiliadis, Alkis Simitsis, Spiros Skiadopoulos , Modeling ETL Activities as Graphs, National Technical University of Athens, Dept. of Electrical and Computer Eng. , Computer Science Division, IroonPolytechniou 9, 157 73, Athens, Greece.
- Pat Minton and Don Steffen,The Conformed ETL architecture.
Index Terms
Keywords