Detecting patterns and OLAP operations in the GOLD model

ABSTRACT

The aim of our GOLD model ([7], [9]) is to provide an Object Oriented (OO) Multidimensional data model supported by an OO formal specification language that allows us to automatically generate prototypes from the specification at the conceptual level, and therefore, to animate and check system properties. Within the context of OO modeling and automatic prototyping, the basis of the mapping from modeling to programming is focused on the identification of (cardinality and behavioral) patterns in the design phase and their relationships with the data model, process model and interface design. The aim of this paper, therefore, is the identification of these patterns based on the relationships between the dimension attributes included in cube classes. These patterns will associate data together with OLAP operations and will allow us to have a concise execution model that maps every pattern of modeling into its corresponding implementation making users able to accomplish OLAP operations on cube classes. Furthermore, we extend the set of classical OLAP operations with two more operations (combine, divide) to allow us to navigate along attributes that are not part of any classification hierarchy.

REFERENCES

• 1: A. Datta and H. Thomas, "A conceptual Model and an algebra for On-Line Analytical Processing in Data Warehouse". In proc. of the workshop on Information Technologies and Systems (WITS'97), Atlanta, 1997
• 2: Chang Li , X. Sean Wang, A data model for supporting on-line analytical processing, Proceedings of the fifth international conference on Information and knowledge management, p.81-88, November 12-16, 1996, Rockville, Maryland, United States [doi>10.1145/238355.238444]
• 3: C. Sapia, M. Blaschka, G. Hofling, and B. Dinter, "An Overview of Multidimensional Data Models for OLAP". Technical Report, httpNwww.forwiss.tu-muenchen.de/
• 4: Carsten Sapia , Markus Blaschka , Gabriele Höfling , Barbara Dinter, Extending the E/R Model for the Multidimensional Paradigm, Proceedings of the Workshops on Data Warehousing and Data Mining: Advances in Database Technologies, p.105-116, November 19-20, 1998
• 5: Jaime Gómez , Oscar Pastor , Emilio Insfrán , Vicente Pelechano, From Object-Oriented Conceptual Modeling to Component-Based Development, Proceedings of the 10th International Conference on Database and Expert Systems Applications, p.332-341, August 30-September 03, 1999
• 6: Jim Gray , Surajit Chaudhuri , Adam Bosworth , Andrew Layman , Don Reichart , Murali Venkatrao , Frank Pellow , Hamid Pirahesh, Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Totals, Data Mining and Knowledge Discovery, v.1 n.1, p.29-53, 1997 [doi>10.1023/A:1009726021843 ]
• 7: J. Trujillo , M. Palomar, An object oriented approach to multidimensional database conceptual modeling (OOMD), Proceedings of the 1st ACM international workshop on Data warehousing and OLAP, p.16-21, November 02-07, 1998, Washington, D.C., United States [doi>10.1145/294260.294266]
• 8: J. Trujillo and M. Palomar, "An Object Oriented Approach to Multidimensional Databases & OLAP operations". Journat of Computer Science and Information Management, 1999. (To appear)
• 9: Juan Trujillo, The GOLD Model: An OO Multidimensional Data Model for Multidimensional Databases, Proceedings of the Workshop on Object-Oriented Technology, p.24-30, June 14-18, 1999
• 10: Luca Cabibbo , Riccardo Torlone, A Logical Approach to Multidimensional Databases, Proceedings of the 6th International Conference on Extending Database Technology: Advances in Database Technology, p.183-197, March 23-27, 1998
• 11: Matteo Golfarelli , Stefano Rizzi, A methodological framework for data warehouse design, Proceedings of the 1st ACM international workshop on Data warehousing and OLAP, p.3-9, November 02-07, 1998, Washington, D.C., United States [doi>10.1145/294260.294261]
• 12: Marc Gyssens , Laks V. S. Lakshmanan, A Foundation for Multi-dimensional Databases, Proceedings of the 23rd International Conference on Very Large Data Bases, p.106-115, August 25-29, 1997
• 13: Oscar Pastor , Vicente Pelechano , Emilio Insfrán , Jaime Gómez, From Object Oriented Conceptual Modeling to Automated Programming in Java, Proceedings of the 17th International Conference on Conceptual Modeling, p.183-196, November 16-19, 1998
• 14: O. Pastor and 1. Ramos. "OASIS 2.1.1: A Class- Definition Language to Model Information Systems Using and Object-Oriented Approach". Ed. Servicio de Publicaciones Univ. Politecnica de Valencia, 3rd ed, 1995
• 15: O. Pastor, F. Hayes, and S. Bear. OASIS: An Object Oriented Specification Language". In proc. of the 4 Ih Intl. Conf. on Advanced Information Systems Engineering (CAiSE'92). Manchester, UK, May, 1992. Lecture Notes in Computer Science, Springer-Verlag. Vol. 593, pp. 348- 363
• 16: Panos Vassiliadis, Modeling Multidimensional Databases, Cubes and Cube Operations, Proceedings of the 10th International Conference on Scientific and Statistical Database Management, p.53-62, July 01-03, 1998
• 17: Rakesh Agrawal , Ashish Gupta , Sunita Sarawagi, Modeling Multidimensional Databases, Proceedings of the Thirteenth International Conference on Data Engineering, p.232-243, April 07-11, 1997
• 18: R. Kimball, "The data warehousing toolkit". John Wiley, 1996
• 19: Surajit Chaudhuri , Umeshwar Dayal, An overview of data warehousing and OLAP technology, ACM SIGMOD Record, v.26 n.1, p.65-74, March 1997 [doi>10.1145/248603.248616]
• 20: Wolfgang Lehner, Modelling Large Scale OLAP Scenarios, Proceedings of the 6th International Conference on Extending Database Technology: Advances in Database Technology, p.153-167, March 23-27, 1998

INDEX TERMS

Primary Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT

Additional Classification:
  D. Software
  D.2 SOFTWARE ENGINEERING

General Terms:
Design, Management