Goal-Ontology ETL Processes Specification

Authors

  • Azman Ta’a College of Arts and Sciences, Universiti Utara Malaysia, Malaysia
  • Mohd. Syazwan Abdullah College of Arts and Sciences Universiti Utara Malaysia, Malaysia
  • Norita Md. Norwawi College of Arts and Sciences Universiti Utara Malaysia, Malaysia

DOI:

https://doi.org/10.32890/jict2011.10.2

Keywords:

ETL Processes, Data warehouse, Ontology, Business intelligence, Requirement analysis

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.

 

References

Abdullah, R., Selamat, M. H., Ibrahim, H., Chulan, U. A. U., & Nasharuddin, N. A. (2009). Semantics representation in a sentence with concept relational model (CRM). Journal of Information and Communication Technology, 8, 55–65.

Alexiev, V., Breu, M., Bruijn, J. d., Fensel, D., Lara, R., & Lausen, H. (2005). Information integration with ontologies: Experiences from an industrial showcase: John Wiley & Sons.

Allemang, D., & Hendler, J. (2008). Semantic web for the working ontologist: Elsevier Science.

Bresciani, P., Perini, A., Giorgini, P., Giunchiglia, F., & Mylopoulos, J. (2004). Tropos: An agent-oriented software development methodology. Autonomous Agents and Multi-Agent Systems, 8(3), 203–236.

Cysneiros, L. M., Werneck, V., & Yu, E. (2004). Evaluating methodologies: A requirements engineering approach through the use of an exemplar. 7th Workshop on Autonomous Agents.

Giorgini, P., Rizzi, S., & Garzetti, M. (2008). Grand: A Goal-oriented approach to requirement analysis in data warehouses. Decision Support Systems, 45, 4–21.

Hutter, D., Stephan, W., Baader, F., Horrocks, I., & Sattler, U. (2005). Description logics as ontology languages for the semantic web. Journal of ICT, 10, pp: 15– Mechanizing Mathematical Reasoning, 2605, 228–248: Springer Berlin / Heidelberg.

Inmon, W. H. (2002). Building the data warehouse – (3rd ed.). John Wiley & Sons.

Kimball, R., & Caserta, J. (2004). The data warehouse ETL toolkit. Practical technique for extracting, cleaning, conforming and delivering data: Indianapolis.: John Wiley Publishing.

Kimball, R., & Ross, M. (2002). The data warehouse toolkit - The complete guide to dimensional modeling (2nd ed.). John Wiley & Sons.

Lamsweerde, A. V. (2010). Requirements engineering - From system goals to UML model to software specifications: John Wiley & Sons.

Lujan-Mora, S. (2005). Data warehouse design with UML (Unpublished doctoral dissertation). University of Alicante.

Ogawa, H., Kumeno, F., & Honiden, S. (2008). Model checking process with goal oriented requirements analysis. 15th Asia-Pacific Software Engineering Conference.

Rizzi, S. (2007). Conceptual modeling solutions for the data warehouse. Idea Group Inc, 1–26.

Shen, G., Huang, Z., Zhu, X., & Zhao, X. (2006). Research on the rules of mapping from relational model to OWL. OWLED’06, Athens, Georgia (USA).

Sirin, E., Parsia, B., Grau, B. C., Kalyanpur, A., & Katz, Y. (2007). Pellet: A practical OWL-DL reasoner. Web Semantic, 5(2), 51–53.

Skoutas, D., & Simitsis, A. (2007). Ontology-based conceptual design of ETL processes for both structured and semi-structured data. Semantic Web & Information Systems, 3(4), 1–24.

Ta’a, A., Abdullah, M. S., & Norwawi, N. M. (2010). RAMEPs: A goal-ontology approach to analyze the requirements for data warehouse systems. WSEAS Transactions on Information Science and Applications, 7(2), 295–309.

Yu, E. (1995). Modeling strategic relationships for process reengineering (Unpublished doctoral dissertation). University of Toronto.

Downloads

Published

18-04-2011

Issue

Vol. 10 (2011): Journal of Information and Communication Technology (JICT) Vol. 10, 2011

Section

Articles

How to Cite

Ta’a, A., Abdullah, M. S., & Md. Norwawi, N. (2011). Goal-Ontology ETL Processes Specification. Journal of Information and Communication Technology, 10, 15-43. https://doi.org/10.32890/jict2011.10.2

Research impact

Harvested 2026-09-06
0 citations recorded so far

Counts differ between services because each indexes a different body of literature. None of them is the whole picture.

Identifiers DOI 10.32890/jict2011.10.2 OpenAlex W7047535505

Most read articles by the same author(s)