Login | Register

Design issues in data warehousing : a case study


Design issues in data warehousing : a case study

Yao, Kan (2003) Design issues in data warehousing : a case study. Masters thesis, Concordia University.

[thumbnail of MQ78001.pdf]
Text (application/pdf)


Data warehousing is the foundation of DSS (decision support system), of which the goal is to enable decision makers to make better business decisions based on analysis of historic data related to the business operation. Data warehousing has become a major business trend, both for product and service sectors and for application to daily business in all industries. In this thesis, we compare and discuss the two data models and two methods of OLAP (MOLAP and ROLAP). The two data models and two OLAPs are not mutually exclusive in any project. An example of the hybrid design is presented in a case study. In this project, we are able to apply two data models at different stages of the data warehouse. By combining ER model, Star Schema and aggregate table in one architecture, we are able to maximize on both storage capacity and query performance. In addition to the selection of data models, the choice between MOLAP and ROLAP is discussed. When the objectives of the client are clearly defined, the functional requirements of the data warehouse are determined, and the amount of data is relatively small, MOLAP would likely be a better choice because of its superior performance and intuitive querying mechanism. ROLAP becomes a more suitable candidate for OLAP when the amount of data is exceedingly large, and the client does not want to leave out anything. Again, it is possible, even desirable, for both OLAP methods to be applied in one project to compliment each other.

Divisions:Concordia University > Gina Cody School of Engineering and Computer Science > Computer Science and Software Engineering
Item Type:Thesis (Masters)
Authors:Yao, Kan
Pagination:vii, 84 leaves : ill. ; 29 cm.
Institution:Concordia University
Degree Name:M. Comp. Sc.
Program:Computer Science and Software Engineering
Thesis Supervisor(s):Desai, Bipin C.
Identification Number:QA 76.9 D37Y36 2003
ID Code:2017
Deposited By: Concordia University Library
Deposited On:27 Aug 2009 17:24
Last Modified:13 Jul 2020 19:51
Related URLs:
All items in Spectrum are protected by copyright, with all rights reserved. The use of items is governed by Spectrum's terms of access.

Repository Staff Only: item control page

Downloads per month over past year

Research related to the current document (at the CORE website)
- Research related to the current document (at the CORE website)
Back to top Back to top