Ontology Development for ETL Process Design

Ontology Development for ETL Process Design

Author: 
Ta’a, Azman
Place: 
Hershey, PA
Publisher: 
IGI Global
Date published: 
2012
Editor: 
Ahmad, Mohammad Nazir
Source: 
Ontology-Based Applications for Enterprise Systems and Knowledge Management
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.

Series: 
Advances in Knowledge Acquisition, Transfer, and Management

CITATION: Ta’a, Azman. Ontology Development for ETL Process Design edited by Ahmad, Mohammad Nazir . Hershey, PA : IGI Global , 2012. Ontology-Based Applications for Enterprise Systems and Knowledge Management - Available at: https://library.au.int/ontology-development-etl-process-design