A Tool for Data Warehouse Multidimensional Schema Design using Ontology
The data warehouse has become a necessary component for an effective analysis of large businesses. It is widely accepted that the data warehouse must be structured according to the multidimensional model to facilitate OLAP analysis. The two driving force for the design of a multidimensional model are data source and business requirements. In recent years in addition to operational databases, web data has become an important source for data warehouse. The web data may be semi-structured or unstructured and exhibit several heterogeneity issues. Hence the design of multidimensional model has become a tedious task. The use of semantic web technologies such as ontology helps to represent such web data into coherent information which can be incorporated in a data Warehouse. Ontology also helps to represent the business requirements in a formal way, which need to be used during the design. In this paper we present an ontology driven tool which helps to automatically derive the conceptual model and logical model for the data warehouse from data source and business requirements. We make use of ontology and its reasoning capabilities at various stages of our tool to facilitate the design task.
Keywords: Data Warehouse Design, Multidimensional Model, Multidimensional Schema Design, Ontology based Data Warehouse Schema Design
Download Full-Text
ABOUT THE AUTHORS
M.Thenmozhi
M.Thenmozhi received her B.Tech in Computer Science and Engineering from Pondicherry University and M.E in Computer Science and Engineering from Anna University. She is currently pursuing her Ph.D in Computer Science and Engineering, from Pondicherry Engineering College affiliated to Pondicherry University. Presently she is working as Assistant Professor in Department of Computer Science and Engineering, Pondicherry Engineering College. She has total teaching experience of about 8 years. Her research interest includes Data warehousing, Data Modeling, Data mining and Ontology.
K.Vivekanandan
Dr.K.Vivekanandan received his B.E from Bharathiyar University, M.Tech from Indian Institute of Technology, Bombay and Ph.D from Pondicherry University. He has been the faculty of Department of Computer Science and Engineering, Pondicherry Engineering College from 1992. Presently he is working as Professor in the Department of Computer Science and Engineering. His research interest includes Software Engineering, Object Oriented Systems, Information Security and Web Services. He is currently serving as coordinator for two AICTE sponsored RPS projects on “Developing Product Line Architecture and Components for e-Governance Applications of Indian Context” and “Development of a framework for designing WDM Optical Network. He has published more than 50 papers in international conferences and journals.
M.Thenmozhi
M.Thenmozhi received her B.Tech in Computer Science and Engineering from Pondicherry University and M.E in Computer Science and Engineering from Anna University. She is currently pursuing her Ph.D in Computer Science and Engineering, from Pondicherry Engineering College affiliated to Pondicherry University. Presently she is working as Assistant Professor in Department of Computer Science and Engineering, Pondicherry Engineering College. She has total teaching experience of about 8 years. Her research interest includes Data warehousing, Data Modeling, Data mining and Ontology.
K.Vivekanandan
Dr.K.Vivekanandan received his B.E from Bharathiyar University, M.Tech from Indian Institute of Technology, Bombay and Ph.D from Pondicherry University. He has been the faculty of Department of Computer Science and Engineering, Pondicherry Engineering College from 1992. Presently he is working as Professor in the Department of Computer Science and Engineering. His research interest includes Software Engineering, Object Oriented Systems, Information Security and Web Services. He is currently serving as coordinator for two AICTE sponsored RPS projects on “Developing Product Line Architecture and Components for e-Governance Applications of Indian Context” and “Development of a framework for designing WDM Optical Network. He has published more than 50 papers in international conferences and journals.
