Ta'a, Azman and Abdullah, Mohd Syazwan and Md Norwawi, Norita (2011) Goal-ontology ETL processes specification. Journal of Information and Communication Technology, 10. pp. 15-43. ISSN 2180-3862

PDF Restricted to Registered users only Download (1MB)

Abstract

The design-related problems for extract, transform, load (ETL) processes are far away from being resolved due to the ambiguity of user requirements and the complexity of operations.Current approaches are based on existing software requirement methods that have limitations on reconciliation of the requirement semantics toward generating the ETL processes specification.The solution is to apply the RAMEPs (Requirement Analysis Method for ETL Processes) that was developed to facilitate the design of the ETL processes in the perspectives of organization, decision-maker, and developer.The results are the ETL processes specification, which was validated on the correctness of the goal-ontology model and evaluated in the case study of Gas Malaysia Data Warehouse (DW) system.The case study illustrated how the goal-ontology approach was successfully implemented in designing and generating the ETL processes specification.

Item Type:	Article
Uncontrolled Keywords:	ETL Processes, Data warehouse, Ontology, Business intelligence, Requirement analysis
Subjects:	Q Science > QA Mathematics > QA76 Computer software
Divisions:	College of Arts and Sciences
Depositing User:	Dr. Azman Ta'a
Date Deposited:	29 Aug 2012 08:27
Last Modified:	29 Aug 2012 08:27
URI:	https://repo.uum.edu.my/id/eprint/5903

Actions (login required)

View Item