Ta'a, Azman and Abdullah, Mohd Syazwan and Md Norwawi, Norita (2011) ETL processes specifications generation through goal-ontology approach. In: 3rd International Conference on Computing and Informatics (ICOCI 2011), 8-9 June 2011, Bandung, Indonesia.

Preview

PDF Download (677kB) | Preview

Abstract

The common design-related problems for extract, transform, load (ETL) processes are far away from being resolved due to the variation and ambiguity of user requirements and the complexity of ETL operations.These were the fundamental issues of data conflicts in heterogeneous information sharing environments.Current approaches are based on existing software requirement methods that have limitations on reconciliation of the user semantics toward the modeling of the DW. This will prolong the process to generate the ETL processes specifications accordingly.The solution in this paper is focused on the requirement analysis method for designing the ETL processes. The method - RAMEPs (Requirement Analysis Method for ETL Processes) was developed to support the design of ETL processes by analyzing and producing the DW requirements in perspectives of organization, decision-makers, and developers.The ETL processes are modeled and designed by capturing DW schemas and data sources integration and transformation. The validation of RAMEPs emphasizes on the correctness of the goal-oriented and ontology requirement model, and was validated by using compliant tools that support both these approaches.The correctness of RAMEPs was evaluated in three real case studies of Student Affairs System, Gas Utility System, and Graduate Entrepreneur System.These case studies were used to illustrate how the RAMEPs method was implemented in generating the ETL processes specifications.

Item Type:	Conference or Workshop Item (Paper)
Additional Information:	ISBN 978-983-2078-49-4 Organized by: UUM College of Arts and Sciences, Universiti Utara Malaysia.
Uncontrolled Keywords:	requirement analysis, ontology requirement model
Subjects:	Q Science > QA Mathematics > QA76 Computer software
Divisions:	College of Arts and Sciences
Depositing User:	Dr. Azman Ta'a
Date Deposited:	07 Apr 2015 04:54
Last Modified:	07 Apr 2015 04:54
URI:	https://repo.uum.edu.my/id/eprint/13611

Actions (login required)

View Item