Ontology development for ETL process design
The Extract, Transform, Load (ETL) process design is difficult to perform because of the ambiguity of user requirements and the complexity of data integration and transformation.Current studies have explored the ontology-based approach to overcome these limitations by reconciling the semantics of us...
| Main Authors: | , |
|---|---|
| Other Authors: | |
| Format: | Book Section |
| Published: |
IGI Global
2013
|
| Subjects: |
| _version_ | 1803627942380568576 |
|---|---|
| author | Ta'a, Azman Abdullah, Mohd Syazwan |
| author2 | Ahmad, Mohammad Nazir |
| author_facet | Ahmad, Mohammad Nazir Ta'a, Azman Abdullah, Mohd Syazwan |
| author_sort | Ta'a, Azman |
| collection | UUM |
| description | The Extract, Transform, Load (ETL) process design is difficult to perform because of the ambiguity of user requirements and the complexity of data integration and transformation.Current studies have explored the ontology-based approach to overcome these limitations by reconciling the semantics of user requirements within the ETL process design for easy generation of the ETL process specification. The ontology for ETL process activities has been developed by using the Requirement Analysis Method for ETL Processes (RAMEPs) that is gathered from the perspectives of organization, decision-maker, and developer. Therefore, the ontology is used to generate the ETL process specification for a student affairs’ Data Warehouse (DW) system.The correctness of the ontology model was validated by using an appropriate reasoner.Moreover, the process of ontology development for the case study is presented and shows how the ontology-based approach was successful in implementing the design and generating the ETL process specification. |
| first_indexed | 2024-07-04T06:14:04Z |
| format | Book Section |
| id | uum-20651 |
| institution | Universiti Utara Malaysia |
| last_indexed | 2024-07-04T06:14:04Z |
| publishDate | 2013 |
| publisher | IGI Global |
| record_format | dspace |
| spelling | uum-206512020-11-03T07:34:43Z https://repo.uum.edu.my/id/eprint/20651/ Ontology development for ETL process design Ta'a, Azman Abdullah, Mohd Syazwan QA75 Electronic computers. Computer science The Extract, Transform, Load (ETL) process design is difficult to perform because of the ambiguity of user requirements and the complexity of data integration and transformation.Current studies have explored the ontology-based approach to overcome these limitations by reconciling the semantics of user requirements within the ETL process design for easy generation of the ETL process specification. The ontology for ETL process activities has been developed by using the Requirement Analysis Method for ETL Processes (RAMEPs) that is gathered from the perspectives of organization, decision-maker, and developer. Therefore, the ontology is used to generate the ETL process specification for a student affairs’ Data Warehouse (DW) system.The correctness of the ontology model was validated by using an appropriate reasoner.Moreover, the process of ontology development for the case study is presented and shows how the ontology-based approach was successful in implementing the design and generating the ETL process specification. IGI Global Ahmad, Mohammad Nazir Colomb, Robert M. Abdullah, Mohd Syazwan 2013 Book Section PeerReviewed Ta'a, Azman and Abdullah, Mohd Syazwan (2013) Ontology development for ETL process design. In: Ontology-Based Applications for Enterprise Systems and Knowledge Management. IGI Global, pp. 261-275. ISBN ISBN13: 9781466619937 http://doi.org/10.4018/978-1-4666-1993-7.ch015 doi:10.4018/978-1-4666-1993-7.ch015 doi:10.4018/978-1-4666-1993-7.ch015 |
| spellingShingle | QA75 Electronic computers. Computer science Ta'a, Azman Abdullah, Mohd Syazwan Ontology development for ETL process design |
| title | Ontology development for ETL process design |
| title_full | Ontology development for ETL process design |
| title_fullStr | Ontology development for ETL process design |
| title_full_unstemmed | Ontology development for ETL process design |
| title_short | Ontology development for ETL process design |
| title_sort | ontology development for etl process design |
| topic | QA75 Electronic computers. Computer science |
| work_keys_str_mv | AT taaazman ontologydevelopmentforetlprocessdesign AT abdullahmohdsyazwan ontologydevelopmentforetlprocessdesign |