Olap Cube Representation For Objectoriented Database

Abstract

In the current scenario, the size of database related to any organization is rapidly increasing and due to evolution of the object-oriented approach, many of the Software Industries are converting the old structured approach based softwares into the object-oriented based softwares. Therefore, for the large amount of database, it is necessary to study the faster retrieval system as On-Line Analytical Processing (OLAP) which was introduced by E.Codd in 1993. The present paper is an attempt in this direction and object-oriented approach with the help of Unified Modeling Language (UML) is used to create OLAP cube which supports three dimensional data. A real case study of Indian Postal Services is considered to store large amount of data in the OLAP cube and can be easily used for the analysis purpose. UML class model, sequence diagram and star schema of object-oriented database are designed along with the OLAP cube. For testing purpose, some sample queries are also performed on the object-oriented database.