Application of knowledge-based system in automated data warehouse design

Data warehouse has become more and more popular for an enterprise as a data repository system.Yet tools to appropriately design its conceptual model are rarely available, even though this model is known as a key for the successful of the overall design. In this paper we propose an approach and a too...

Full description

Saved in:
Bibliographic Details
Main Authors: Sitompul, Opim Salim, Mohd Noah, Shahrul Azman
Format: Conference or Workshop Item
Language:English
Published: 2004
Subjects:
Online Access:http://repo.uum.edu.my/13833/1/KM92.pdf
http://repo.uum.edu.my/13833/
http://www.kmice.cms.net.my
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary:Data warehouse has become more and more popular for an enterprise as a data repository system.Yet tools to appropriately design its conceptual model are rarely available, even though this model is known as a key for the successful of the overall design. In this paper we propose an approach and a tool to guide the decision makers in designing data warehouse conceptual model based on the Entity Relationship (ER) model of the existing operational database systems. Using this approach, the ER model is automatically transformed into the multidimensional model.