Advertisement

CPM: A Cube Presentation Model for OLAP

  • Andreas Maniatis
  • Panos Vassiliadis
  • Spiros Skiadopoulos
  • Yannis Vassiliou
Part of the Lecture Notes in Computer Science book series (LNCS, volume 2737)

Abstract

On-Line Analytical Processing (OLAP) is a trend in database technology, based on the multidimensional view of data. In this paper we introduce the Cube Presentation Model (CPM), a presentational model for OLAP data which, to the best of our knowledge, is the only formal presentational model for OLAP found in the literature until today. First, our proposal extends a previous logical model for cubes, to handle more complex cases. Then, we present a novel presentational model for OLAP screens, intuitively based on the geometrical representation of a cube and its human perception in the space. Moreover, we show how the logical and the presentational models are integrated smoothly. Finally, we describe how typical OLAP operations can be easily mapped to the CPM.

Keywords

Selection Condition Attribute Group Complex Cube Logical Layer Ancestor Function 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. 1.
    Chaudhuri, S., Dayal, U.: An overview of Data Warehousing and OLAP technology. ACM SIGMOD Record 26(1) (March 1997)Google Scholar
  2. 2.
    Vassiliadis, P., Sellis, T.: A Survey of Logical Models for OLAP Databases. SIGMOD Record 28(4) (December 1999)Google Scholar
  3. 3.
    Keim, D.A.: Visual Data Mining. In: Tutorials of the 23rd International Conference on Very Large Data Bases, Athens, Greece (1997)Google Scholar
  4. 4.
    Inselberg, A.: Visualization and Knowledge Discovery for High Dimensional Data. In: 2nd Workshop Proceedings UIDIS. IEEE, Los Alamitos (2001)Google Scholar
  5. 5.
    Gebhardt, M., Jarke, M., Jacobs, S.: A Toolkit for Negotiation Support Interfaces to Multi-Dimensional Data. In: ACM SIGMOD 1997, 348–356 (1997)Google Scholar
  6. 6.
    Microsoft Corp. OLEDB for OLAP (February 1998), Available at http://www.microsoft.com/data/oledb/olap/
  7. 7.
    Maniatis, A., Vassiliadis, P., Skiadopoulos, S., Vassiliou, Y.: CPM: A Cube Presentation Model, http://www.dblab.ece.ntua.gr/~andreas/publications/CPM_dawak03.pdf (Long Version)
  8. 8.
    Vassiliadis, P., Skiadopoulos, S.: Modeling and Optimization Issues for Multidimensional Databases. In: Wangler, B., Bergman, L.D. (eds.) CAiSE 2000. LNCS, vol. 1789, p. 482. Springer, Heidelberg (2000)Google Scholar
  9. 9.
    Gray, J., et al.: Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab and Sub-Totals. In: Proc. of the ICDE 1996 (1996)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2003

Authors and Affiliations

  • Andreas Maniatis
    • 1
  • Panos Vassiliadis
    • 2
  • Spiros Skiadopoulos
    • 1
  • Yannis Vassiliou
    • 1
  1. 1.Dept. of Elec. and Computer Eng.National Technical Univ. of AthensAthensHellas
  2. 2.Dept. of Computer ScienceUniversity of IoanninaIoanninaHellas

Personalised recommendations