Work

Olap Cube Representation For Objectoriented Database

Year: 2012
Type: article
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.
Author: Vipin Saxena
Language: English
Open Access status: bronze
OpenAlex ID: W2330025065
FWCI: 0.436
Cites: 17
Cited by: 4
Related to: 10