Assumption University
Bangkok, Thailand
October 2000
GENERATING
DVR DATA MODEL FOR DATA WAREHOUSE
by
Paisarn Trakulsuk
A doctoral dissertation submitted in partial
fulfillment of the requirements for the degree of Doctor of Philosophy
in Computer Information Systems.
- Examination Committee :
- Prof. Dr. Srisakdi Charmonman
- Assoc.Prof. Somchai Tayarnyong
- Assist Rrof. Dr. Vichit Avatchanakorn
- Air Marshal Dr.Chulit Meesajjee
- Dr.Chamnong Jungthirapanich
- Asst. Prof. Dr.Ouen Pin-ngen
- Assist. Prof. Dr. Suphamit Chittayasothorn
- Dr. Boonyarit Phokrud
- Name :
- Paisarn Trakulsuk
- Nationality :
- Thai
- Previous Degree :
- Master of Sciences in CIS
- Assumption University, Thailand
- Bachelor of Business Administration (Business Computer)
- Assumption University, Thailand
Approval Page
RESEARCH TITLE : Generating DVR Data Model for Data Warehouse
CANDIDATE NAME : Somsong Chiraphadkanakul
ADVISOR NAME : Asst. Prof. Dr.Vichai Avatchanakorn
ACADEMIC YEAR : 2000
The Graduate School of Assumption University had
approved this dissertation as a partial fulfillment of the requirement
for the degree of Doctor of Philosophy in Computer Information Systems
- Abstract
- The valuable information from multiple data
sources in warehouse database is summarized in form of multidimensional
data model, generally implemented in relational database. This research
presents a procedure to generate the Dimension, Variable, and Relative
Dimension of multidimensional data model used in the Multidimensional
On-Line Analytical Prosessing (MOLAP) concept.
- The proposed model is presented in two concepts:
(1) Building DVR model of warehouse database, the proposed procedure
consists of classification, partitioning, and clustering models. (2)
The DVR data model design using graph model, the proposed design shows
how to provide data support intelligence through multidimensional
data analysis when there are huge amount of online data. This design
also reprosents a fact scheme that intergates relative information
and external sources, as well as extends the algorithms to build DVR
patterns of multidimensional data model.
- Acknowledgements
- Several People have made contribution to this
research. The writer would like to acknowledge their efforts and thank
them for their contributions.
- He would like to gratefully acknowledge to
parent who motivated him for studying Ph.D. Program in Assumption
University. In Particular he would like to thank Asst.Prof.Dr. Vichit
Avatchanakorn, his project advisor, who gave the idea and advice given
in to preparation of this research.
- He would like to thank to Prof.Dr. Srisakdi
Chamonman, Chaiman of Ph.D. Program, and the committees, Air Marshal
Dr. Chulit Meesajjee, Assoc.Prof.Somchai Thayarmyong, Asst.Prof.Dr.
Ouen Pin-ngen, Assoc.Prof.Dr. Suphamit Chittayasothorn, Dr. Chamnong
Jungthirapanich, and Dr. Boonyarit Phokrud for their valuable suggestions
and shared the ideas of significant mentions to develop his research.
- He extend his sincere thank to Mr. Jaime Cabrara
who helped him to check and prove the contents and grammar of his
research. Lastly he would like to thank you the reader, and hope you
find the content of its useful and easy to read.
- Table of Contents
- Abstract
- Acknowledgements
- Nomenclature
- List of Figures
- list of Tables
- Chapter 1 : Introduction
-
- 1.1 Introduction
- 1.2 Overview of Data Warehousing
- 1.3 Overview of Multidimensional Databases
- 1.4 Literature Reviews
- 1.5 Data Structure Design Problems
- 1.6 Scope and Objectives of the Research
- 1.7 Organization of the Research
- Chapter 2 : Data Structure Modeling
-
- 2.1 Introduction
- 2.2 Approaches to Data Architecture
- 2.3 The DVR Model
- 2.4 OLAP Methodology
- 2.5 Conclusion
- Chapter 3 : DVR Data Model Generation
-
- 3.1 Introduction
- 3.2 Generating the DVR Data Structure
- 3.3 Conclusion
- Chapter 4 : DVR Data Model Design via Graph
Model
-
- 4.1 Introduction
- 4.2 Designing Data Model via Graph Model
- 4.3 Conclusion
- Chapter 5 : Application to Engine Cost System
-
- 5.1 Introduction
- 5.2 Data Sources
- 5.3 Definitions of Data Codes
- 5.4 A DVR Model Example
- 5.5 Conclusion
- Chapter 6 : Conclusion and Recommendations
- Appendix A : Data Transformation and Data Loading
- Bibliography
|
