Using Lexical Ontology for Semi-automatic Logical Data Warehouse Design

  • Mior Nasir Mior Nazri
  • Shahrul Azman Noah
  • Zarinah Hamid
Part of the Lecture Notes in Computer Science book series (LNCS, volume 6401)


Data Warehouse has become a very important tool for data analysis but the conversion from Operational Database to Data Warehouse is very complex. This paper presents a new method to design a data warehouse multidimensional model based on supply driven framework. We propose a semi-automatic tool using lexical ontology as the knowledge domain. The tool is able to identify fact and dimensional tables using the knowledge domain. Once fact table is identified, the following step is to generate Data Warehouse multidimensional model with minimal user interaction. The feasibility of the proposed method is demonstrated by a prototype using WordNet as knowledge domain.


Data Warehouse Multidimensional Model Ontology WordNet 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Husemann, B., Lechtenbörger, J., Vossen, G.: Conceptual Data Warehouses Design. In: DMDW 2000: Proceedings of the third International Workshop on Design and Management of Data Warehouses (2000)Google Scholar
  2. 2.
    Ponniah, P.: Data Warehousing Fundamentals. John Wiley & Sons, Inc., New York (2001)CrossRefGoogle Scholar
  3. 3.
    Phipps, C., Davis, K.C.: Automating Data Warehouse Conceptual Schema Design and Evaluation. In: DMDW 2002: Proceedings of the International Workshop on Design and Management of Data Warehouses, Canada (2002)Google Scholar
  4. 4.
    Romero, O., Abelló, A.: Automating Multidimensional Design from Ontologies. In: DOLAP 2007: Proceedings of the ACM tenth International Workshop on Data Warehousing and OLAP, pp. 1–8. ACM Press, New York (2007)CrossRefGoogle Scholar
  5. 5.
    Moody, D.L., Kortink, M.A.R.: From Enterprise Models to Dim. Models: A Methodology for DW and Data Mart Design. In: DMDW 2000: Proceedings of the International Workshop on Design and Management of Data Warehouses, p. 5.1–5.12 (2000)Google Scholar
  6. 6.
    Miller, G.A., Beckwith, R., Fellbaum, C., Gross, D., Miller, K.: WordNet: An on-line lexical database. International Journal of Lexicography 3 (1990)Google Scholar
  7. 7.
    Singh, P., Liu, H.: ConceptNet - a practical commonsense reasoning tool-kit. BT Technology Journal 22, 211–226 (2004)CrossRefGoogle Scholar
  8. 8.
    List, B., Bruckner, R.M., Machaczek, K., Schiefer, J.: A Comparison of Data Warehouse Development Methodologies Case Study of the Process Warehouse. In: Hameurlain, A., Cicchetti, R., Traunmüller, R. (eds.) DEXA 2002. LNCS, vol. 2453, p. 203. Springer, Heidelberg (2002)CrossRefGoogle Scholar
  9. 9.
    Sitompul, O.S., Noah, S.A.: A Transformation-oriented Methodology to Knowledge-based Conceptual Data Warehouse Design. Journal of Computer Science 2, 460–465 (2006)CrossRefGoogle Scholar
  10. 10.
    Giorgini, P., Rizzi, S., Garzetti, M.: Goal-Oriented Requirement Analysis for Data Warehouse Design. In: DOLAP 2005: Proceedings of the 8th ACM International Workshop on Data Warehousing and OLAP. ACM Press, Bremen (2005)Google Scholar
  11. 11.
    Guo, Y., Tang, S., Tong, Y., Yang, D.: Triple-driven Data Modeling Methodology in Data Warehousing: a case study. In: DOLAP 2006: Proceedings of the 9th ACM International Workshop on Data Warehousing and OLAP, pp. 59–66. ACM Press, Arlington (2006)CrossRefGoogle Scholar
  12. 12.
    Winter, R., Strauch, B.: A Method for Demand-driven Information Requirements Analysis in Data Warehousing Projects. In: HICSS 2003: Proceedings of the 36th Hawaii International Conference on System Sciences (2003)Google Scholar
  13. 13.
    Noah, S.A., Williams, M.D.: Intelligent Database Design Diagnosis: Performance Assessment with the Provision of Domain Knowledge. Artificial Intelligence Review 21, 57–84 (2004)zbMATHCrossRefGoogle Scholar
  14. 14.
    Sugumaran, V., Storey, V.C.: The Role of Domain Ontologies in DB Design: An Ontology Mgmt & Conceptual Modeling Environment. ACM Transactions on Database Systems 31, 1064–1094 (2006)CrossRefGoogle Scholar
  15. 15.
    Lassila, O., McGuinness, D.: The Role of Frame-Based Representation on the Semantic Web. Technical Report KSL-01-02. Knowledge System Laboratory. Stanford University, Stanford, California (2001)Google Scholar
  16. 16.
    Connolly, T., Begg, C.: Database System - A Practical Approach to Design, Implementation and Management. Addison Wesley Longman Publishing Co., Inc., Redwood City (2005)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2010

Authors and Affiliations

  • Mior Nasir Mior Nazri
    • 1
  • Shahrul Azman Noah
    • 2
  • Zarinah Hamid
    • 1
  1. 1.International Islamic University MalaysiaKuala LumpurMalaysia
  2. 2.Universiti Kebangsaan MalaysiaBangiMalaysia

Personalised recommendations