IIUM Repository (IREP)

Using lexical ontology for semi-automatic logical data warehouse design

Mior Nazri, Mior Nasir and Noah, Shahrul Azman and Hamid, Zarinah (2010) Using lexical ontology for semi-automatic logical data warehouse design. In: UNSPECIFIED.

[img] PDF (Using Lexical Ontology for Semi-automatic) - Published Version
Restricted to Registered users only

Download (218kB) | Request a copy

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.

Item Type: Conference or Workshop Item (UNSPECIFIED)
Additional Information: 4578/13621
Uncontrolled Keywords: Data Warehouse - Multidimensional Model - Ontology - WordNet
Subjects: T Technology > T Technology (General) > T10.5 Communication of technical information
Kulliyyahs/Centres/Divisions/Institutes: Kulliyyah of Information and Communication Technology
Kulliyyah of Information and Communication Technology
Depositing User: Br. Mior Nasir Mior Nazri
Date Deposited: 26 Jan 2012 09:27
Last Modified: 01 Feb 2012 14:58
URI: http://irep.iium.edu.my/id/eprint/13621

Actions (login required)

View Item View Item

Downloads

Downloads per month over past year