Welcome to the InfoSci Platform
Reference Hub1
Ontology Development for ETL Process Design

Ontology Development for ETL Process Design

Azman Ta’a, Mohd Syazwan Abdullah
Copyright: © 2013 |Pages: 15
ISBN13: 9781466619937|ISBN10: 1466619937|EISBN13: 9781466619944
DOI: 10.4018/978-1-4666-1993-7.ch015
Cite Chapter Cite Chapter

MLA

Ta’a, Azman, and Mohd Syazwan Abdullah. "Ontology Development for ETL Process Design." Ontology-Based Applications for Enterprise Systems and Knowledge Management, edited by Mohammad Nazir Ahmad, et al., IGI Global, 2013, pp. 261-275. https://doi.org/10.4018/978-1-4666-1993-7.ch015

APA

Ta’a, A. & Abdullah, M. S. (2013). Ontology Development for ETL Process Design. In M. Nazir Ahmad, R. Colomb, & M. Abdullah (Eds.), Ontology-Based Applications for Enterprise Systems and Knowledge Management (pp. 261-275). IGI Global. https://doi.org/10.4018/978-1-4666-1993-7.ch015

Chicago

Ta’a, Azman, and Mohd Syazwan Abdullah. "Ontology Development for ETL Process Design." In Ontology-Based Applications for Enterprise Systems and Knowledge Management, edited by Mohammad Nazir Ahmad, Robert M. Colomb, and Mohd Syazwan Abdullah, 261-275. Hershey, PA: IGI Global, 2013. https://doi.org/10.4018/978-1-4666-1993-7.ch015

Export Reference

Mendeley
Favorite

Abstract

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.

Request Access

You do not own this content. Please login to recommend this title to your institution's librarian or purchase it from the IGI Global bookstore.