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.

Full Text
Paper version not known

Talk to us

Join us for a 30 min session where you can share your feedback and ask us any queries you have

Schedule a call

Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.