Comparison of distributed technologies for defining a distributable and interoperable ETL framework
Extraction, Transformation and Loading (ETL) are major functionalities in data warehousing. Lack of component distribution and interoperability are the main problems in the ETL area, because ETL components are tightly-coupled in the traditional ETL framework. This paper explores and discusses five...
| Main Authors: | , , , , |
|---|---|
| Format: | Conference or Workshop Item |
| Language: | English |
| Published: |
2012
|
| Subjects: | |
| Online Access: | https://repo.uum.edu.my/id/eprint/7300/1/667-2474-2-PB.pdf |
| _version_ | 1825802104195776512 |
|---|---|
| author | Abdullah, Mohd Syazwan Awad, Mohammed M I Saleh, Abdul Razak Mat Ali, Abdul Bashah Ahmad, Azizah |
| author_facet | Abdullah, Mohd Syazwan Awad, Mohammed M I Saleh, Abdul Razak Mat Ali, Abdul Bashah Ahmad, Azizah |
| author_sort | Abdullah, Mohd Syazwan |
| collection | UUM |
| description | Extraction, Transformation and Loading (ETL) are major functionalities in data warehousing. Lack of component distribution and interoperability are the main problems in the ETL area, because ETL components are tightly-coupled in the traditional ETL framework. This paper explores and discusses five popular distributed technologies for the purpose of highlighting the best technology that is capable of overcoming the distribution and interoperability gaps of the traditional ETL framework. Based on the comparison of distributed technologies discussed in this paper, several benefits can be obtained when SOA is used in redefining the ETL framework such as: distribution, interoperability, reusability, portability, and compatibility with legacy systems. These advantages and other SOA specifications are discussed in this paper. |
| first_indexed | 2024-07-04T05:33:22Z |
| format | Conference or Workshop Item |
| id | uum-7300 |
| institution | Universiti Utara Malaysia |
| language | English |
| last_indexed | 2024-07-04T05:33:22Z |
| publishDate | 2012 |
| record_format | eprints |
| spelling | uum-73002013-02-25T01:53:11Z https://repo.uum.edu.my/id/eprint/7300/ Comparison of distributed technologies for defining a distributable and interoperable ETL framework Abdullah, Mohd Syazwan Awad, Mohammed M I Saleh, Abdul Razak Mat Ali, Abdul Bashah Ahmad, Azizah TK Electrical engineering. Electronics Nuclear engineering Extraction, Transformation and Loading (ETL) are major functionalities in data warehousing. Lack of component distribution and interoperability are the main problems in the ETL area, because ETL components are tightly-coupled in the traditional ETL framework. This paper explores and discusses five popular distributed technologies for the purpose of highlighting the best technology that is capable of overcoming the distribution and interoperability gaps of the traditional ETL framework. Based on the comparison of distributed technologies discussed in this paper, several benefits can be obtained when SOA is used in redefining the ETL framework such as: distribution, interoperability, reusability, portability, and compatibility with legacy systems. These advantages and other SOA specifications are discussed in this paper. 2012 Conference or Workshop Item PeerReviewed application/pdf en https://repo.uum.edu.my/id/eprint/7300/1/667-2474-2-PB.pdf Abdullah, Mohd Syazwan and Awad, Mohammed M I and Saleh, Abdul Razak and Mat Ali, Abdul Bashah and Ahmad, Azizah (2012) Comparison of distributed technologies for defining a distributable and interoperable ETL framework. In: 2nd World Conference on Innovation and Computer Science (INSODE-2012), 10-14 May 2012, Efes Surmeli Hotel, Kusadasi, Turkey. http://www.world-education-center.org/index.php/P-ITCS/article/view/667 |
| spellingShingle | TK Electrical engineering. Electronics Nuclear engineering Abdullah, Mohd Syazwan Awad, Mohammed M I Saleh, Abdul Razak Mat Ali, Abdul Bashah Ahmad, Azizah Comparison of distributed technologies for defining a distributable and interoperable ETL framework |
| title | Comparison of distributed technologies for defining a distributable and interoperable ETL framework |
| title_full | Comparison of distributed technologies for defining a distributable and interoperable ETL framework |
| title_fullStr | Comparison of distributed technologies for defining a distributable and interoperable ETL framework |
| title_full_unstemmed | Comparison of distributed technologies for defining a distributable and interoperable ETL framework |
| title_short | Comparison of distributed technologies for defining a distributable and interoperable ETL framework |
| title_sort | comparison of distributed technologies for defining a distributable and interoperable etl framework |
| topic | TK Electrical engineering. Electronics Nuclear engineering |
| url | https://repo.uum.edu.my/id/eprint/7300/1/667-2474-2-PB.pdf |
| work_keys_str_mv | AT abdullahmohdsyazwan comparisonofdistributedtechnologiesfordefiningadistributableandinteroperableetlframework AT awadmohammedmi comparisonofdistributedtechnologiesfordefiningadistributableandinteroperableetlframework AT salehabdulrazak comparisonofdistributedtechnologiesfordefiningadistributableandinteroperableetlframework AT mataliabdulbashah comparisonofdistributedtechnologiesfordefiningadistributableandinteroperableetlframework AT ahmadazizah comparisonofdistributedtechnologiesfordefiningadistributableandinteroperableetlframework |