Ta'a, Azman and Abdullah, Mohd Syazwan and Md Norwawi, Norita (2009) Requirements analysis method for extracting-transformation-loading (ETL) in data warehouse systems. In: International Conference on Computing and Informatics 2009 (ICOCI09), 24-25 June 2009, Legend Hotel, Kuala Lumpur.

Preview

PDF Download (346kB) | Preview

Abstract

The data warehouse (DW) system 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.The understanding of an early phase of DW development is essential in properly tackling the complexity of ETL processes.The method to analyses the DW requirements from the abstract level (e.g. goal, sub-goal, stakeholder, dependency) toward the specification of ETL processes (e.g. extracting, filtering, conversion) are important in order to manage the complexity of the ETL processes design (e.g. semantic heterogeneity problems). However, current approaches that are based on existing software requirement approach still have limitations on translating the business semantics for DW requirements toward the ETL processes specifications.Moreover, the understanding of goal in the perspective of the organization and decision makers are important to ensure the semantic of DW requirements can be properly determined, organized, and implemented by the ETL processes. Therefore, the proposed method will utilize the ontology with goal-driven approach in analyzing the requirements of ETL processes.

Item Type:	Conference or Workshop Item (Paper)
Additional Information:	ISBN 978-983--44150-2-0 Organized by: UUM College of Arts and Sciences, Universiti Utara Malaysia.
Uncontrolled Keywords:	ETL Processes, Data Warehouse, Requirement Analysis, Ontology, Business Intelligence
Subjects:	Q Science > QA Mathematics > QA76 Computer software
Divisions:	College of Arts and Sciences
Depositing User:	Dr. Azman Ta'a
Date Deposited:	01 Apr 2015 08:41
Last Modified:	01 Apr 2015 08:41
URI:	https://repo.uum.edu.my/id/eprint/13500

Actions (login required)

View Item