Mat Yusof, Sharmila and Sidi, Fatimah and Ibrahim, Hamidah and Affendey, Lilly Suriani (2017) Data Warehouse Conceptual Design-A Literature Survey. Journal of Engineering and Applied Sciences, 12 (16). pp. 4208-4214. ISSN 1816-949X

PDF Restricted to Registered users only Download (249kB) | Request a copy

Abstract

Data Warehouse (DW) can provide an excellent approach in transforming Online Transaction Processing (OLTP) data into useful and reliable information to support organization’s decision making. As such, it can be a basis for data analysis techniques such as multidimensional analysis and data mining. However, DW design process has been known as a complex task that requires systematic and structured approach to guarantee its success. Therefore, there have been various methodologies proposed to carry out the design process which can be classified into requirement-driven, data-driven and hybrid approaches. In this study, a literature survey was made to obtain related works by a set of pertinent key words related to DW conceptual design. The objective of this survey is to provide the state of the art of DW conceptual design methodologies in narrative and summarized forms. The main contribution is to provide understanding of the trend, issues and solutions proposed to date in DW conceptual design and along the way to discover the novel and great contribution works that form an important basis in the DW conceptual design.

Item Type:	Article
Uncontrolled Keywords:	Data warehouse, conceptual design, multimensional model,surve, provide, DW conceptual
Subjects:	Q Science > QA Mathematics > QA75 Electronic computers. Computer science
Divisions:	School of Computing
Depositing User:	Mrs. Norazmilah Yaakub
Date Deposited:	15 Jan 2019 23:51
Last Modified:	15 Jan 2019 23:51
URI:	https://repo.uum.edu.my/id/eprint/25418

Actions (login required)

View Item