Detecting Patterns and OLAP Operations in the GOLD Model.

@inproceedings{DBLP:conf/dolap/TrujilloPG99,
  author    = {Juan Trujillo and
               Manuel Palomar and
               Jaime G{\'o}mez},
  title     = {Detecting Patterns and OLAP Operations in the GOLD Model},
  booktitle = {DOLAP '99, ACM Second International Workshop on Data Warehousing
               and OLAP, November 6, 1999, Kansas City, Missouri, USA, Proceedings},
  publisher = {ACM},
  year      = {1999},
  pages     = {48-53},
  ee        = {db/conf/dolap/TrujilloPG99.html, http://doi.acm.org/10.1145/319757.319788},
  crossref  = {DBLP:conf/dolap/99},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}

Abstract

The aim of our GOLD model ([7],[9]) is to provide an Object Oriented (00) 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.

Copyright © 1999 by the ACM, Inc., used by permission. Permission to make digital or hard copies is granted provided that copies are not made or distributed for profit or direct commercial advantage, and that copies show this notice on the first page or initial screen of a display along with the full citation.

ACM SIGMOD Anthology

• Windows: Click the letter of your CD drive
  A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
• Mac: Click here
• UNIX/LINUX: mount the CD and click on the path of your mount point:
  /Anthology/An2-4 or /cdrom

• Windows: Click the letter of your CD drive
  A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
• Mac: Click here
• UNIX/LINUX: mount the DVD and click on the path of your mount point:
  /Anthology/aDVD1 or /dvd

Printed Edition

Online Edition

References

[1]

...

[2]

Chang Li, Xiaoyang Sean Wang: A Data Model for Supporting On-Line Analytical Processing. CIKM 1996: 81-88

[3]

...

[4]

Carsten Sapia, Markus Blaschka, Gabriele Höfling, Barbara Dinter: Extending the E/R Model for the Multidimensional Paradigm. ER Workshops 1998: 105-116

[5]

Jaime Gómez, Oscar Pastor, Emilio Insfrán, Vicente Pelechano: From Object-Oriented Conceptual Modeling to Component-Based Development. DEXA 1999: 332-341

[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 Min. Knowl. Discov. 1(1): 29-53(1997)

[7]

Juan Trujillo, Manuel Palomar: An Object-Oriented Approach to Multidimensional Database Conceptual Modeling. DOLAP 1998: 16-21

[8]

...

[9]

Juan Trujillo: The GOLD Model: An OO Multidimensional Data Model for Multidimensional Databases. ECOOP Workshop for PhD Students in OO Systems 1999: 24-30

[10]

Luca Cabibbo, Riccardo Torlone: A Logical Approach to Multidimensional Databases. EDBT 1998: 183-197

[11]

Matteo Golfarelli, Stefano Rizzi: Methodological Framework for Data Warehouse Design. DOLAP 1998: 3-9

[12]

Marc Gyssens, Laks V. S. Lakshmanan: A Foundation for Multi-dimensional Databases. VLDB 1997: 106-115

[13]

Oscar Pastor, Vicente Pelechano, Emilio Insfrán, Jaime Gómez: From Object Oriented Conceptual Modeling to Automated Programming in Java. ER 1998: 183-196

[14]

...

[15]

Oscar Pastor, Fiona Hayes, Stephen Bear: OASIS: An Object-Oriented Specification Language. CAiSE 1992: 348-363

[16]

Panos Vassiliadis: Modeling Multidimensional Databases, Cubes and Cube Operations. SSDBM 1998: 53-62

[17]

Rakesh Agrawal, Ashish Gupta, Sunita Sarawagi: Modeling Multidimensional Databases. ICDE 1997: 232-243

[18]

Ralph Kimball: The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses. John Wiley 1996, ISBN 0-471-15337-0

[19]

Surajit Chaudhuri, Umeshwar Dayal: An Overview of Data Warehousing and OLAP Technology. SIGMOD Record 26(1): 65-74(1997)

[20]

Wolfgang Lehner: Modelling Large Scale OLAP Scenarios. EDBT 1998: 153-167