Automatic data warehouse conceptual design

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

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

1 Citation (Scopus)

Abstract

This paper presents a methodology to develop a dimensional data warehouse by integrating all three development approaches such as supply-driven, goaldriven and demand-driven. By having the combination of all three approaches, the final design will ensure that user requirements, company interest and existing source of data are included in the model. We proposed an automatic system using ontology as the knowledge domain. Starting from operational ER-D (Entity Relationship-Diagram), the selection of facts table, verification of terms and consistency checking will utilize domain ontology. The model will also be verified against user and company requirements. Any discrepancy in the final design requires designer and user intervention. The proposed methodology is supported by a prototype using a business data warehouse example.

Original languageEnglish
Title of host publicationProceedings - International Symposium on Information Technology 2008, ITSim
Volume2
DOIs
Publication statusPublished - 2008
EventInternational Symposium on Information Technology 2008, ITSim - Kuala Lumpur
Duration: 26 Aug 200829 Aug 2008

Other

OtherInternational Symposium on Information Technology 2008, ITSim
CityKuala Lumpur
Period26/8/0829/8/08

Fingerprint

Data warehouses
Conceptual design
Ontology
Industry

ASJC Scopus subject areas

  • Artificial Intelligence
  • Information Systems
  • Control and Systems Engineering
  • Electrical and Electronic Engineering

Cite this

Nazri, M. N. M., Mohd Noah, S. A., & Hamid, Z. (2008). Automatic data warehouse conceptual design. In Proceedings - International Symposium on Information Technology 2008, ITSim (Vol. 2). [4631741] https://doi.org/10.1109/ITSIM.2008.4631741

Automatic data warehouse conceptual design. / Nazri, Mior Nasir Mior; Mohd Noah, Shahrul Azman; Hamid, Zarinah.

Proceedings - International Symposium on Information Technology 2008, ITSim. Vol. 2 2008. 4631741.

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

Nazri, MNM, Mohd Noah, SA & Hamid, Z 2008, Automatic data warehouse conceptual design. in Proceedings - International Symposium on Information Technology 2008, ITSim. vol. 2, 4631741, International Symposium on Information Technology 2008, ITSim, Kuala Lumpur, 26/8/08. https://doi.org/10.1109/ITSIM.2008.4631741
Nazri MNM, Mohd Noah SA, Hamid Z. Automatic data warehouse conceptual design. In Proceedings - International Symposium on Information Technology 2008, ITSim. Vol. 2. 2008. 4631741 https://doi.org/10.1109/ITSIM.2008.4631741
Nazri, Mior Nasir Mior ; Mohd Noah, Shahrul Azman ; Hamid, Zarinah. / Automatic data warehouse conceptual design. Proceedings - International Symposium on Information Technology 2008, ITSim. Vol. 2 2008.
@inproceedings{b96b3f56bd0e41f59e1b699ccd3ef6b1,
title = "Automatic data warehouse conceptual design",
abstract = "This paper presents a methodology to develop a dimensional data warehouse by integrating all three development approaches such as supply-driven, goaldriven and demand-driven. By having the combination of all three approaches, the final design will ensure that user requirements, company interest and existing source of data are included in the model. We proposed an automatic system using ontology as the knowledge domain. Starting from operational ER-D (Entity Relationship-Diagram), the selection of facts table, verification of terms and consistency checking will utilize domain ontology. The model will also be verified against user and company requirements. Any discrepancy in the final design requires designer and user intervention. The proposed methodology is supported by a prototype using a business data warehouse example.",
author = "Nazri, {Mior Nasir Mior} and {Mohd Noah}, {Shahrul Azman} and Zarinah Hamid",
year = "2008",
doi = "10.1109/ITSIM.2008.4631741",
language = "English",
isbn = "9781424423286",
volume = "2",
booktitle = "Proceedings - International Symposium on Information Technology 2008, ITSim",

}

TY - GEN

T1 - Automatic data warehouse conceptual design

AU - Nazri, Mior Nasir Mior

AU - Mohd Noah, Shahrul Azman

AU - Hamid, Zarinah

PY - 2008

Y1 - 2008

N2 - This paper presents a methodology to develop a dimensional data warehouse by integrating all three development approaches such as supply-driven, goaldriven and demand-driven. By having the combination of all three approaches, the final design will ensure that user requirements, company interest and existing source of data are included in the model. We proposed an automatic system using ontology as the knowledge domain. Starting from operational ER-D (Entity Relationship-Diagram), the selection of facts table, verification of terms and consistency checking will utilize domain ontology. The model will also be verified against user and company requirements. Any discrepancy in the final design requires designer and user intervention. The proposed methodology is supported by a prototype using a business data warehouse example.

AB - This paper presents a methodology to develop a dimensional data warehouse by integrating all three development approaches such as supply-driven, goaldriven and demand-driven. By having the combination of all three approaches, the final design will ensure that user requirements, company interest and existing source of data are included in the model. We proposed an automatic system using ontology as the knowledge domain. Starting from operational ER-D (Entity Relationship-Diagram), the selection of facts table, verification of terms and consistency checking will utilize domain ontology. The model will also be verified against user and company requirements. Any discrepancy in the final design requires designer and user intervention. The proposed methodology is supported by a prototype using a business data warehouse example.

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

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

U2 - 10.1109/ITSIM.2008.4631741

DO - 10.1109/ITSIM.2008.4631741

M3 - Conference contribution

AN - SCOPUS:57449113452

SN - 9781424423286

VL - 2

BT - Proceedings - International Symposium on Information Technology 2008, ITSim

ER -