Awad, Mohammed M I and Abdullah, Mohd Syazwan and Mat Ali, Abdul Bashah (2010) Extending ETL framework using service oriented architecture. Procedia Computer Science, 3. pp. 110-114. ISSN 1877-0509

PDF Restricted to Repository staff only Download (392kB)

Abstract

Extraction, Transformation and Loading (ETL) represent a big portion of a data warehouse project. Complexity of components extensibility is a main problem in the ETL area, because ETL components are tightly-coupled to each others in the current ETL framework.The missing extensibility feature causes impediments to add new components to the current ETL framework; to meet special business needs.This paper shows how to restructure the current ETL framework based on Service Oriented Architecture (SOA) to be easier to extend.This restructuring solution distributes the ETL into interoperable components. The distribution of Extraction, Transformation and Loading components while keeping interoperability amongst them; can be achieved by SOA.A Classified-Fragmentation component to enhance the report generation speed is added to the new framework; as a proof of the extensibility concept.The result of this work is an extensible ETL framework including Classified-Fragmentation component as an extension.

Item Type:	Article
Uncontrolled Keywords:	Data Warehouse; ETL; SOA; Extensibility; Distribution; Interoperability; Tight-Coupling; Loose-Coupling.
Subjects:	Q Science > QA Mathematics > QA76 Computer software
Divisions:	College of Arts and Sciences
Depositing User:	Mrs. Norazmilah Yaakub
Date Deposited:	15 Feb 2012 02:14
Last Modified:	15 Feb 2012 02:14
URI:	https://repo.uum.edu.my/id/eprint/4318

Actions (login required)

View Item