Automatic data warehouse conceptual design
This paper presents a methodology to develop a dimensional data warehouse by integrating all three development approaches such as supply-driven, goal-driven and demand-driven. By having the combination of all three approaches, the final design will ensure that user requirements, company interest and...
Saved in:
Main Authors: | , , |
---|---|
Format: | Conference or Workshop Item |
Published: |
2008
|
Subjects: | |
Online Access: | http://eprints.um.edu.my/2372/ http://apps.webofknowledge.com/full_record.do?product=UA&search_mode=Refine&qid=2&SID=2EldCMhof8dp74ieikM&page=24&doc=231&cacheurlFromRightClick=no |
Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
id |
my.um.eprints.2372 |
---|---|
record_format |
eprints |
spelling |
my.um.eprints.23722011-12-20T03:29:46Z http://eprints.um.edu.my/2372/ Automatic data warehouse conceptual design Nazri, M.N.M. Noah, S.A.M. Hamid, Z. QA75 Electronic computers. Computer science This paper presents a methodology to develop a dimensional data warehouse by integrating all three development approaches such as supply-driven, goal-driven 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. Starling 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. 2008 Conference or Workshop Item PeerReviewed Nazri, M.N.M. and Noah, S.A.M. and Hamid, Z. (2008) Automatic data warehouse conceptual design. In: International Symposium on Information Technology, AUG 26-29, 2008 , Univ Kebangsaan, Fac Informat Sci & Technol, Kuala Lumpur, MALAYSIA . http://apps.webofknowledge.com/full_record.do?product=UA&search_mode=Refine&qid=2&SID=2EldCMhof8dp74ieikM&page=24&doc=231&cacheurlFromRightClick=no |
institution |
Universiti Malaya |
building |
UM Library |
collection |
Institutional Repository |
continent |
Asia |
country |
Malaysia |
content_provider |
Universiti Malaya |
content_source |
UM Research Repository |
url_provider |
http://eprints.um.edu.my/ |
topic |
QA75 Electronic computers. Computer science |
spellingShingle |
QA75 Electronic computers. Computer science Nazri, M.N.M. Noah, S.A.M. Hamid, Z. Automatic data warehouse conceptual design |
description |
This paper presents a methodology to develop a dimensional data warehouse by integrating all three development approaches such as supply-driven, goal-driven 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. Starling 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. |
format |
Conference or Workshop Item |
author |
Nazri, M.N.M. Noah, S.A.M. Hamid, Z. |
author_facet |
Nazri, M.N.M. Noah, S.A.M. Hamid, Z. |
author_sort |
Nazri, M.N.M. |
title |
Automatic data warehouse conceptual design |
title_short |
Automatic data warehouse conceptual design |
title_full |
Automatic data warehouse conceptual design |
title_fullStr |
Automatic data warehouse conceptual design |
title_full_unstemmed |
Automatic data warehouse conceptual design |
title_sort |
automatic data warehouse conceptual design |
publishDate |
2008 |
url |
http://eprints.um.edu.my/2372/ http://apps.webofknowledge.com/full_record.do?product=UA&search_mode=Refine&qid=2&SID=2EldCMhof8dp74ieikM&page=24&doc=231&cacheurlFromRightClick=no |
_version_ |
1643686910450728960 |
score |
13.18916 |