Automatic data warehouse conceptual design

Nazri, M.N.M.; Noah, S.A.M.; 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 .

Full text not available from this repository. (Request a copy)

Abstract

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.

Item Type: Conference or Workshop Item (Paper)
Creators:
  1. Nazri, M.N.M.(University of Malaya)
  2. Noah, S.A.M.
  3. Hamid, Z.(University of Malaya)
Uncontrolled Keywords: Computer Science, Artificial Intelligence; Computer Science, Information Systems; Computer Science, Interdisciplinary Applications; Telecommunications
Subjects: Q Science > QA Mathematics > QA75 Electronic computers. Computer science
Divisions: UNSPECIFIED
Depositing User: Mr. Faizal Hamzah
Date Deposited: 20 Dec 2011 11:29
Last Modified: 20 Dec 2011 11:29
URI: http://eprints.um.edu.my/id/eprint/2372

Actions (For repository staff only: Login required)

View Item