期刊名称：International Journal of Software Engineering & Applications (IJSEA)
印刷版ISSN：0976-2221
电子版ISSN：0975-9018
出版年度：2012
卷号：3
期号：2
页码：109
出版社：Academy & Industry Research Collaboration Center (AIRCC)
摘要：In the current scenario, the size of database related to any organization is rapidly increasing and due toevolution of the object-oriented approach, many of the Software Industries are converting the oldstructured approach based softwares into the object-oriented based softwares. Therefore, for the largeamount 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 andobject-oriented approach with the help of Unified Modeling Language (UML) is used to create OLAP cubewhich supports three dimensional data. A real case study of Indian Postal Services is considered to storelarge 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.
关键词：OLAP; Cube; UML; Class Diagram; Sequence Diagram and Star Schema.
