Abstract
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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
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)
Ponniah, P.: Data Warehousing Fundamentals. John Wiley & Sons, Inc., New York (2001)
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)
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)
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)
Miller, G.A., Beckwith, R., Fellbaum, C., Gross, D., Miller, K.: WordNet: An on-line lexical database. International Journal of Lexicography 3 (1990)
Singh, P., Liu, H.: ConceptNet - a practical commonsense reasoning tool-kit. BT Technology Journal 22, 211–226 (2004)
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)
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)
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)
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)
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)
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)
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)
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)
Connolly, T., Begg, C.: Database System - A Practical Approach to Design, Implementation and Management. Addison Wesley Longman Publishing Co., Inc., Redwood City (2005)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2010 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Nazri, M.N.M., Noah, S.A., Hamid, Z. (2010). Using Lexical Ontology for Semi-automatic Logical Data Warehouse Design. In: Yu, J., Greco, S., Lingras, P., Wang, G., Skowron, A. (eds) Rough Set and Knowledge Technology. RSKT 2010. Lecture Notes in Computer Science(), vol 6401. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-16248-0_39
Download citation
DOI: https://doi.org/10.1007/978-3-642-16248-0_39
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-16247-3
Online ISBN: 978-3-642-16248-0
eBook Packages: Computer ScienceComputer Science (R0)