Mahidol University Logo
Faculty of ICT, Mahidol University
 

Admissions

Printable Version

 

MULTIDIMENSIONAL OBJECT SCHEMA: AN OBJECT-ORIENTED APPROACH IN A MULTIDIMENSIONAL DATABASE DESIGN

 

TITLE MULTIDIMENSIONAL OBJECT SCHEMA: AN OBJECT-ORIENTED APPROACH IN A MULTIDIMENSIONAL DATABASE DESIGN.
AUTHOR SUPHONG CHIRAWATTANAKIJ
DEGREE MASTER OF SCIENCE PROGRAMME IN COMPUTER SCIENCE
FACULTY FACULTY OF SCIENCE
ADVISOR JARERNSRI L. MITRPANONT
CO-ADVISOR SUPACHAI TANGWONGSAN
 
ABSTRACT
This thesis presents the new conceptual mapping schema, called Multidimensional Object Schema (MOS) to convert a multidimensional database to a relational database by applying an object-oriented paradigm. The research has been motivated by the popularity of RDBMS and the object-oriented concept together with the need of OLAP functions. In fact, MOS adopts major features of the object-oriented system such as encapsulation, reusability and inheritance to enhance the ability of a mapping schema. The MOS mapping process consists of two major steps. First, mapping a multidimensional database to an object-oriented system. In this step, dimension and fact are mapped to five object classes – Table, Attribute, Assignment, Fact and Dimension. Characteristics of each class are also defined. Second, mapping an object-oriented system to a relational database. This step includes mapping object classes and relationships between classes to be relational tables, defining object behaviors including multidimensional behaviors in terms of relational operations and mathematical predicates and defining language module in three categories - Data Definition Language (DDL), Data Manipulation Language (DML) and Query Language (QL). A prototype system was then developed to verify the idea of MOS mapping schema and validate the correctness of MOS multidimensional functionalities. In the experiment, a grocery system imitated real-world business has been used. In addition. Star TrackerTM software is used as a benchmark to validate the correctness of MOS functionality. The result is satisfactory and the thesis concludes that the MOS approach is feasible and beneficial to implement. Moreover, there are some areas that can be improved in the future. The thesis recommends them in the last chapter.
KEYWORD MULTIDIMENSIONAL DATABASE, OBJECT-ORIENTED SYSTEM, STAR SCHEMA, RDBMS, OLAP

 

Go to Top

 

ICT Building, Mahidol University, 999 Phuttamonthon 4 Road, Salaya, Nakhonpathom 73170 Tel. +66 02 441-0909 Fax. +66 02 849-6099
Mahidol University Computing Center, The Faculty of ICT, Mahidol University , Rama 6 Road, Rajathevi, Bangkok 10400 Tel. +66 02 354-4333 Fax. +66 02 354-7333