Using lexical ontology for semi-automatic logical data warehouse design

Using lexical ontology for semi-automatic logical data warehouse design

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...

Full description

Bibliographic Details
Main Authors: Mior Nazri, Mior Nasir, Noah, Shahrul Azman, Hamid, Zarinah
Format: Conference or Workshop Item
Language:English
Published: Springer-Verlag 2010
Subjects:
T10.5 Communication of technical information
Online Access:http://irep.iium.edu.my/13621/
http://irep.iium.edu.my/13621/
http://irep.iium.edu.my/13621/
http://irep.iium.edu.my/13621/1/WA_13606_MIOR_NASIR__Using_Lexical_Ontology.pdf
id iium-13621
recordtype eprints
spelling iium-136212012-02-01T06:58:25Z http://irep.iium.edu.my/13621/ Using lexical ontology for semi-automatic logical data warehouse design Mior Nazri, Mior Nasir Noah, Shahrul Azman Hamid, Zarinah T10.5 Communication of technical information 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. Springer-Verlag 2010 Conference or Workshop Item NonPeerReviewed application/pdf en http://irep.iium.edu.my/13621/1/WA_13606_MIOR_NASIR__Using_Lexical_Ontology.pdf Mior Nazri, Mior Nasir and Noah, Shahrul Azman and Hamid, Zarinah (2010) Using lexical ontology for semi-automatic logical data warehouse design. In: UNSPECIFIED. http://www.springerlink.com/content/m0u0q4g847313836/ DOI: 10.1007/978-3-642-16248-0_39
repository_type Digital Repository
institution_category Local University
institution International Islamic University Malaysia
building IIUM Repository
collection Online Access
language English
topic T10.5 Communication of technical information
spellingShingle T10.5 Communication of technical information
Mior Nazri, Mior Nasir
Noah, Shahrul Azman
Hamid, Zarinah
Using lexical ontology for semi-automatic logical data warehouse design
description 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.
format Conference or Workshop Item
author Mior Nazri, Mior Nasir
Noah, Shahrul Azman
Hamid, Zarinah
author_facet Mior Nazri, Mior Nasir
Noah, Shahrul Azman
Hamid, Zarinah
author_sort Mior Nazri, Mior Nasir
title Using lexical ontology for semi-automatic logical data warehouse design
title_short Using lexical ontology for semi-automatic logical data warehouse design
title_full Using lexical ontology for semi-automatic logical data warehouse design
title_fullStr Using lexical ontology for semi-automatic logical data warehouse design
title_full_unstemmed Using lexical ontology for semi-automatic logical data warehouse design
title_sort using lexical ontology for semi-automatic logical data warehouse design
publisher Springer-Verlag
publishDate 2010
url http://irep.iium.edu.my/13621/
http://irep.iium.edu.my/13621/
http://irep.iium.edu.my/13621/
http://irep.iium.edu.my/13621/1/WA_13606_MIOR_NASIR__Using_Lexical_Ontology.pdf
first_indexed 2023-09-18T20:22:45Z
last_indexed 2023-09-18T20:22:45Z
_version_ 1777408216573935616

Similar Items