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
Institution: Babasaheb Bhimrao Ambedkar University
Language: English
Subfield: Information Systems
Field: Computer Science
Domain: Physical Sciences
Open Access status: bronze
OpenAlex ID: W2330025065
