Using lexical ontology for semi-automatic logical data warehouse design

Authors:
Mior Nasir Mior Nazri;Shahrul Azman Noah;Zarinah Hamid
Affiliations:
International Islamic University Malaysia, Kuala Lumpur, Malaysia;Universiti Kebangsaan Malaysia, Bangi, Malaysia;International Islamic University Malaysia, Kuala Lumpur, Malaysia
Venue:
RSKT'10 Proceedings of the 5th international conference on Rough set and knowledge technology
Year:
2010

Citing 10
Cited 0

Data Warehousing Fundamentals

Data Warehousing Fundamentals
A Comparison of Data Warehouse Development Methodologies Case Study of the Process Warehouse

DEXA '02 Proceedings of the 13th International Conference on Database and Expert Systems Applications
A Method for Demand-Driven Information Requirements Analysis in Data Warehousing Projects

HICSS '03 Proceedings of the 36th Annual Hawaii International Conference on System Sciences (HICSS'03) - Track 8 - Volume 8
Intelligent Database Design Diagnosis: Performance Assessment with the Provision of Domain Knowledge

Artificial Intelligence Review
Database Systems: A Practical Approach to Design, Implementation and Management (4th Edition)

Database Systems: A Practical Approach to Design, Implementation and Management (4th Edition)
ConceptNet — A Practical Commonsense Reasoning Tool-Kit

BT Technology Journal
Goal-oriented requirement analysis for data warehouse design

Proceedings of the 8th ACM international workshop on Data warehousing and OLAP
The role of domain ontologies in database design: An ontology management and conceptual modeling environment

ACM Transactions on Database Systems (TODS)
Triple-driven data modeling methodology in data warehousing: a case study

DOLAP '06 Proceedings of the 9th ACM international workshop on Data warehousing and OLAP
Automating multidimensional design from ontologies

Proceedings of the ACM tenth international workshop on Data warehousing and OLAP

Quantified Score

Hi-index	0.00

Visualization

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.