Ta'a, Azman and Abdullah, Mohd Syazwan and Md. Norwawi, Norita (2009) RAMEPs: A requirement analysis method for extracting-transformation-loading (ETL) processes in data warehouse systems. In: Proceedings of the 3rd International Conference on Communications and Information Technology (CIT'09), Vouliagmeni, Athens, Greece, December 29-31, 2009. Recent advances in computer engineering . World Scientific and Engineering Academy and Society (WSEAS) , Wisconsin, USA, pp. 15-20. ISBN 978-960-474-146-5

PDF Restricted to Repository staff only Download (579kB)

Abstract

The data warehouse (DW) systems design involves several tasks such as defining the DW schemas and the ETL processes specifications, and these have been extensively studied and practiced for many years. The problems in heterogeneous data integration are still far from being resolved due to the complexity of ETL processes and the fundamental problems of data conflicts in information sharing environments. Current approaches that are based on existing software requirement methods still have limitations on translating the business semantics for DW requirements toward the ETL processes specifications. This paper proposes the Requirement Analysis Method for ETL processes (RAMEPs) that utilize ontology with the goal-driven approach in analyzing the requirements of ETL processes. A case study of student affairs domain is used to illustrate how the method can be implemented.

Item Type:	Book Section
Uncontrolled Keywords:	Requirement Analysis, ETL Processes, Data Warehouse, Ontology, Business Intelligence
Subjects:	Q Science > QA Mathematics > QA75 Electronic computers. Computer science
Divisions:	College of Arts and Sciences
Depositing User:	Mrs. Norazmilah Yaakub
Date Deposited:	12 Dec 2010 09:10
Last Modified:	13 Dec 2010 07:31
URI:	https://repo.uum.edu.my/id/eprint/1824

Actions (login required)

View Item