Cover Image

A Goal and Ontology Based Approach for Generating ETL Process Specifications

Data warehouse (DW) systems development involves several tasks such as defining requirements, designing DW schemas, and specifying data transformation operations. Indeed, the success of DW systems is very much dependent on the proper design of the extracting, transforming, and loading (ETL) processe...

Full description

Saved in:
Bibliographic Details
Main Author: Azman, Ta'a
Format: Thesis
Language:English
English
Published: 2012
Subjects:
QA71-90 Instruments and machines
Online Access:https://etd.uum.edu.my/3351/1/AZMAN_TA%27A.pdf
https://etd.uum.edu.my/3351/2/AZMAN_TA%27A.pdf
https://etd.uum.edu.my/3351/
http://sierra.uum.edu.my/record=b1242564~S1
Tags: Add Tag
No Tags, Be the first to tag this record!
id my.uum.etd.3351
record_format eprints
spelling my.uum.etd.33512022-04-10T06:36:34Z https://etd.uum.edu.my/3351/ A Goal and Ontology Based Approach for Generating ETL Process Specifications Azman, Ta'a QA71-90 Instruments and machines Data warehouse (DW) systems development involves several tasks such as defining requirements, designing DW schemas, and specifying data transformation operations. Indeed, the success of DW systems is very much dependent on the proper design of the extracting, transforming, and loading (ETL) processes. However, the common design-related problems in the ETL processes such as defining user requirements and data transformation specifications are far from being resolved. These problems are due to data heterogeneity in data sources, ambiguity of user requirements, and the complexity of data transformation activities. Current approaches have limitations on the reconciliation of DW requirement semantics towards designing the ETL processes. As a result, this has prolonged the process of the ETL processes specifications generation. The semantic framework of DW systems established from this study is used to develop the requirement analysis method for designing the ETL processes (RAMEPs) from the different perspectives of organization, decision-maker, and developer by using goal and ontology approaches. The correctness of RAMEPs approach was validated by using modified and newly developed compliant tools. The RAMEPs was evaluated in three real case studies, i.e., Student Affairs System, Gas Utility System, and Graduate Entrepreneur System. These case studies were used to illustrate how the RAMEPs approach can be implemented for designing and generating the ETL processes specifications. Moreover, the RAMEPs approach was reviewed by the DW experts for assessing the strengths and weaknesses of this method, and the new approach is accepted. The RAMEPs method proves that the ETL processes specifications can be derived from the early phases of DW systems development by using the goal-ontology approach. 2012 Thesis NonPeerReviewed text en https://etd.uum.edu.my/3351/1/AZMAN_TA%27A.pdf text en https://etd.uum.edu.my/3351/2/AZMAN_TA%27A.pdf Azman, Ta'a (2012) A Goal and Ontology Based Approach for Generating ETL Process Specifications. PhD. thesis, Universiti Utara Malaysia. http://sierra.uum.edu.my/record=b1242564~S1
institution Universiti Utara Malaysia
building UUM Library
collection Institutional Repository
continent Asia
country Malaysia
content_provider Universiti Utara Malaysia
content_source UUM Electronic Theses
url_provider http://etd.uum.edu.my/
language English
English
topic QA71-90 Instruments and machines
spellingShingle QA71-90 Instruments and machines
Azman, Ta'a
A Goal and Ontology Based Approach for Generating ETL Process Specifications
description Data warehouse (DW) systems development involves several tasks such as defining requirements, designing DW schemas, and specifying data transformation operations. Indeed, the success of DW systems is very much dependent on the proper design of the extracting, transforming, and loading (ETL) processes. However, the common design-related problems in the ETL processes such as defining user requirements and data transformation specifications are far from being resolved. These problems are due to data heterogeneity in data sources, ambiguity of user requirements, and the complexity of data transformation activities. Current approaches have limitations on the reconciliation of DW requirement semantics towards designing the ETL processes. As a result, this has prolonged the process of the ETL processes specifications generation. The semantic framework of DW systems established from this study is used to develop the requirement analysis method for designing the ETL processes (RAMEPs) from the different perspectives of organization, decision-maker, and developer by using goal and ontology approaches. The correctness of RAMEPs approach was validated by using modified and newly developed compliant tools. The RAMEPs was evaluated in three real case studies, i.e., Student Affairs System, Gas Utility System, and Graduate Entrepreneur System. These case studies were used to illustrate how the RAMEPs approach can be implemented for designing and generating the ETL processes specifications. Moreover, the RAMEPs approach was reviewed by the DW experts for assessing the strengths and weaknesses of this method, and the new approach is accepted. The RAMEPs method proves that the ETL processes specifications can be derived from the early phases of DW systems development by using the goal-ontology approach.
format Thesis
author Azman, Ta'a
author_facet Azman, Ta'a
author_sort Azman, Ta'a
title A Goal and Ontology Based Approach for Generating ETL Process Specifications
title_short A Goal and Ontology Based Approach for Generating ETL Process Specifications
title_full A Goal and Ontology Based Approach for Generating ETL Process Specifications
title_fullStr A Goal and Ontology Based Approach for Generating ETL Process Specifications
title_full_unstemmed A Goal and Ontology Based Approach for Generating ETL Process Specifications
title_sort goal and ontology based approach for generating etl process specifications
publishDate 2012
url https://etd.uum.edu.my/3351/1/AZMAN_TA%27A.pdf
https://etd.uum.edu.my/3351/2/AZMAN_TA%27A.pdf
https://etd.uum.edu.my/3351/
http://sierra.uum.edu.my/record=b1242564~S1
_version_ 1731228135887732736
score 13.211869

Similar Items