We apologize for a recent technical issue with our email system, which temporarily affected account activations. Accounts have now been activated. Authors may proceed with paper submissions. PhDFocusTM
CFP last date
20 November 2024
Call for Paper
December Edition
IJCA solicits high quality original research papers for the upcoming December edition of the journal. The last date of research paper submission is 20 November 2024

Submit your paper
Know more
Reseach Article

The Management of Conformed ETL Architecture

by Ashima Jain, Sonam Garg, Neha Sharma
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

@article{ 10.5120/20781-3354,
author = { Ashima Jain, Sonam Garg, Neha Sharma },
title = { The Management of Conformed ETL Architecture },
journal = { International Journal of Computer Applications },
issue_date = { May 2015 },
volume = { 118 },
number = { 10 },
month = { May },
year = { 2015 },
issn = { 0975-8887 },
pages = { 20-22 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume118/number10/20781-3354/ },
doi = { 10.5120/20781-3354 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T23:01:19.217607+05:30
%A Ashima Jain
%A Sonam Garg
%A Neha Sharma
%T The Management of Conformed ETL Architecture
%J International Journal of Computer Applications
%@ 0975-8887
%V 118
%N 10
%P 20-22
%D 2015
%I Foundation of Computer Science (FCS), NY, USA
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
  1. H. J. Watson and B. H. Wixom. The current state of business intelligence. Computer, 40(9):96-99
  2. 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
  3. 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
  4. Alexander Albrecht Felix Naumann, Managing ETL Processes, Hasso Plattner Institute at the University of Potsdam, German
  5. 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.
  6. 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.
  7. Pat Minton and Don Steffen,The Conformed ETL architecture.
Index Terms

Computer Science
Information Sciences

Keywords

Extraction Transformation Loading Business Intelligence