Journal of Accounting and Management Information Systems (JAMIS)


The OLAP concepts and object-relational databases

Supp/2007 ,   p 711..716

Author(s):  
Mihaela MUNTEAN


Keywords:   Multidimensional models, fact, dimension, hierarchies, ORDBMS, UML

Abstract:  

A key to survival in the business world is being able to analyze, plan and react to changing business conditions as fast as possible. With multidimensional models the managers can explore information at different levels of granularity and the decision makers at all levels can quickly respond to changes in the business climate–the ultimate goal of business intelligence. Multidimensional modeling and the multidimensional models use concepts such as: facts, dimensions, hierarchies, measures. This paper focuses on the implementation of the multidimensional concepts into object-relational databases. The multidimensional model can be transformed into a UML class diagram. Next I translate a UML class diagram into an object-relational database schema using an ORDBMS. Because the Star schema is widely accepted as the most viable data representation for multidimensional analysis in especially in relational databases, I present also a comparison between UML class diagram and star schema regarding the multidimensional modeling concepts.



Download:  

Back