Extending ETL framework using service oriented architecture
| Autor: | Mohd Syazwan Abdullah, Abdul Bashah Mat Ali, Mohammed M I Awad |
|---|---|
| Rok vydání: | 2011 |
| Předmět: |
Extensibility
computer.internet_protocol Computer science Interoperability Tight-coupling Distribution Loose coupling computer.software_genre Data warehouse Component (UML) SOA Loose-coupling General Environmental Science Database business.industry InformationSystems_DATABASEMANAGEMENT Service-oriented architecture ETL TheoryofComputation_MATHEMATICALLOGICANDFORMALLANGUAGES Transformation (function) General Earth and Planetary Sciences Software engineering business computer |
| Zdroj: | WCIT |
| ISSN: | 1877-0509 |
| DOI: | 10.1016/j.procs.2010.12.019 |
| Popis: | 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. |
| Databáze: | OpenAIRE |
| Externí odkaz: |
|