Using lexical ontology for semi-automatic logical data warehouse design

Mior Nasir Mior Nazri, Shahrul Azman Mohd Noah, Zarinah Hamid

Research output: Chapter in Book/Report/Conference proceedingConference contribution

3 Citations (Scopus)

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.

Original languageEnglish
Title of host publicationLecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
Pages257-264
Number of pages8
Volume6401 LNAI
DOIs
Publication statusPublished - 2010
Event5th International Conference on Rough Set and Knowledge Technology, RSKT 2010 - Beijing
Duration: 15 Oct 201017 Oct 2010

Publication series

NameLecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
Volume6401 LNAI
ISSN (Print)03029743
ISSN (Electronic)16113349

Other

Other5th International Conference on Rough Set and Knowledge Technology, RSKT 2010
CityBeijing
Period15/10/1017/10/10

Fingerprint

Data warehouses
Data Warehouse
Ontology
Domain Knowledge
Multidimensional Model
WordNet
User Interaction
Tables
Data analysis
Table
Prototype
Model-based
Design

Keywords

  • Data Warehouse
  • Multidimensional Model
  • Ontology
  • WordNet

ASJC Scopus subject areas

  • Computer Science(all)
  • Theoretical Computer Science

Cite this

Nazri, M. N. M., Mohd Noah, S. A., & Hamid, Z. (2010). Using lexical ontology for semi-automatic logical data warehouse design. In Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics) (Vol. 6401 LNAI, pp. 257-264). (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); Vol. 6401 LNAI). https://doi.org/10.1007/978-3-642-16248-0_39

Using lexical ontology for semi-automatic logical data warehouse design. / Nazri, Mior Nasir Mior; Mohd Noah, Shahrul Azman; Hamid, Zarinah.

Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics). Vol. 6401 LNAI 2010. p. 257-264 (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); Vol. 6401 LNAI).

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Nazri, MNM, Mohd Noah, SA & Hamid, Z 2010, Using lexical ontology for semi-automatic logical data warehouse design. in Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics). vol. 6401 LNAI, Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics), vol. 6401 LNAI, pp. 257-264, 5th International Conference on Rough Set and Knowledge Technology, RSKT 2010, Beijing, 15/10/10. https://doi.org/10.1007/978-3-642-16248-0_39
Nazri MNM, Mohd Noah SA, Hamid Z. Using lexical ontology for semi-automatic logical data warehouse design. In Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics). Vol. 6401 LNAI. 2010. p. 257-264. (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)). https://doi.org/10.1007/978-3-642-16248-0_39
Nazri, Mior Nasir Mior ; Mohd Noah, Shahrul Azman ; Hamid, Zarinah. / Using lexical ontology for semi-automatic logical data warehouse design. Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics). Vol. 6401 LNAI 2010. pp. 257-264 (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)).
@inproceedings{7e7377a94ebd4ec2972fc1bde5e43218,
title = "Using lexical ontology for semi-automatic logical data warehouse design",
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.",
keywords = "Data Warehouse, Multidimensional Model, Ontology, WordNet",
author = "Nazri, {Mior Nasir Mior} and {Mohd Noah}, {Shahrul Azman} and Zarinah Hamid",
year = "2010",
doi = "10.1007/978-3-642-16248-0_39",
language = "English",
isbn = "3642162479",
volume = "6401 LNAI",
series = "Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)",
pages = "257--264",
booktitle = "Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)",

}

TY - GEN

T1 - Using lexical ontology for semi-automatic logical data warehouse design

AU - Nazri, Mior Nasir Mior

AU - Mohd Noah, Shahrul Azman

AU - Hamid, Zarinah

PY - 2010

Y1 - 2010

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

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

KW - Data Warehouse

KW - Multidimensional Model

KW - Ontology

KW - WordNet

UR - http://www.scopus.com/inward/record.url?scp=78349280298&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=78349280298&partnerID=8YFLogxK

U2 - 10.1007/978-3-642-16248-0_39

DO - 10.1007/978-3-642-16248-0_39

M3 - Conference contribution

SN - 3642162479

SN - 9783642162473

VL - 6401 LNAI

T3 - Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)

SP - 257

EP - 264

BT - Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)

ER -