Skip to main content
SpringerLink
Log in

Graphical Querying of Multidimensional Databases

  • Conference paper
Advances in Databases and Information Systems (ADBIS 2007)

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 4690))

Abstract

This paper provides an answer-oriented multidimensional analysis environment. The approach is based on a conceptual point of view. We define a conceptual model that represents data through a constellation of facts and dimensions and we present a query algebra handling multidimensional data as well as multidimensional tables. Based on these two propositions, in order to ease the specification of multidimensional analysis queries, we define a formal graphical language implemented within a prototype: GraphicOLAPSQL.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Abelló, A., Samos, J., Saltor, F.: YAM2: a multidimensional conceptual model extending UML. Information Systems (IS) 31(6), 541–567 (2006)

    Article  Google Scholar 

  2. Agrawal, R., Gupta, A., Sarawagi, S.: Modeling Multidimensional Databases. In: 13th Int. Conf. Data Engineering (ICDE), pp. 232–243. IEEE Computer Society, Los Alamitos (1997)

    Chapter  Google Scholar 

  3. Böhnlein, M., Plaha, M., Ulbrich-vom Ende, A.: Visual Specification of Multidimensional Queries based on a Semantic Data Model. In: Vom Data Warehouse zum Corporate Knowledge Center (DW), pp. 379–397. Physica-Verlag, Heidelberg (2002)

    Google Scholar 

  4. Cabibbo, L., Torlone, R.: Querying Multidimensional Databases. In: Cluet, S., Hull, R. (eds.) Database Programming Languages. LNCS, vol. 1369, pp. 319–335. Springer, Heidelberg (1998)

    Google Scholar 

  5. Cabibbo, L., Torlone, R.: From a Procedural to a Visual Query Language for OLAP. In: SSDBM. 10th Int. Conf. on Scientific and Statistical Database Management, pp. 74–83. IEEE Computer Society, Los Alamitos (1998)

    Google Scholar 

  6. Codd, E.F.: Providing OLAP (On Line Analytical Processing) to user analysts: an IT mandate, Technical report, E.F. Codd and Associates (1993)

    Google Scholar 

  7. Datta, A., Thomas, H.: The cube data model: a conceptual model and algebra for on-line analytical processing in data warehouses. Decision Support Systems (DSS) 27(3), 289–301 (1999)

    Article  Google Scholar 

  8. Franconni, E., Kamble, A.: The GMD Data Model and Algebra for Multidimensional Information. In: Persson, A., Stirna, J. (eds.) CAiSE 2004. LNCS, vol. 3084, pp. 446–462. Springer, Heidelberg (2004)

    Google Scholar 

  9. Golfarelli, M., Maio, D., Rizzi, S.: The Dimensional Fact Model: A Conceptual Model for Data Warehouses. International Journal of Cooperative Information Systems (IJCIS) 7(2-3), 215–247 (1998)

    Article  Google Scholar 

  10. Golfarelli, M., Rizzi, S., Saltarelli, E.: WAND: A Case Tool for Workload-Based Design of a Data Mart. In: 10th National Convention on Systems Evolution for Data Bases, pp. 422–426 (2002)

    Google Scholar 

  11. Gray, J., Bosworth, A., Layman, A., Pirahesh, H.: Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Total. In: ICDE. 12th Int. Conf. on Data Engineering, pp. 152–159. IEEE Computer Society, Los Alamitos (1996)

    Google Scholar 

  12. Gyssen, M., Lakshmanan, L.V.S.: A Foundation for Multi-Dimensional Databases. In: VLDB. 23rd Int. Conf. on Very Large Data Bases, pp. 106–115. Morgan Kaufmann, San Francisco (1997)

    Google Scholar 

  13. Kimball, R.: The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses, 2nd edn. John Wiley & Sons Inc., Chichester (2003)

    Google Scholar 

  14. Lehner, W.: Modeling Large Scale OLAP Scenarios. In: Schek, H.-J., Saltor, F., Ramos, I., Alonso, G. (eds.) EDBT 1998. LNCS, vol. 1377, pp. 153–167. Springer, Heidelberg (1998)

    Chapter  Google Scholar 

  15. Li, C., Wang, X.S.: A Data Model for Supporting On-Line Analytical Processing. In: CIKM. 5th Int. Conf. on Information and Knowledge Management, pp. 81–88. ACM, New York (1996)

    Google Scholar 

  16. Malinowski, E., Zimányi, E.: Hierarchies in a multidimensional model: From conceptual modeling to logical representation. J. of Data & Knowledge Engineering (DataK) 59(2), 348–377 (2006)

    Article  Google Scholar 

  17. Niemi, T., Hirvonen, L., Jarvelin, K.: Multidimensional Data Model and Query Language for Informetrics. Wiley Periodicals 54(10), 939–951 (2003)

    Google Scholar 

  18. Pedersen, T., Jensen, C., Dyreson, C.: A foundation for capturing and querying complex multidimensional data. Information Systems (IS)  26(5), 383–423 (2001)

    Article  MATH  Google Scholar 

  19. Rafanelli, M.: Operators for Multidimensional Aggregate Data. In: Multidimensional Databases: Problems and Solutions. ch. 5, pp. 116–165. Idea Group Inc. (2003)

    Google Scholar 

  20. Rizzi, S., Abelló, A., Lechtenbörger, J., Trujillo, J.: Research in data warehouse modeling and design: dead or alive? In: DOLAP. 9th Int. Workshop on Data Warehousing and OLAP, pp. 3–10. ACM, New York (2006)

    Google Scholar 

  21. Sapia, C., Blaschka, M., Höfling, G.: Dinter: Extending the E/R Model for the Multidimensional Paradigm. In: Kambayashi, Y., Lee, D.-L., Lim, E.-p., Mohania, M.K., Masunaga, Y. (eds.) Advances in Database Technologies. LNCS, vol. 1552, pp. 105–116. Springer, Heidelberg (1999)

    Google Scholar 

  22. Sifer, M.: A Visual Interface Technique for Exploring OLAP Data with Coordinated Dimension Hierarchies. In: CIKM. Int. Conf. on Information and Knowledge Management, pp. 532–535. ACM, New York (2003)

    Google Scholar 

  23. Stolte, C., Tang, D., Hanrahan, P.: Polaris: A System for Query, Analysis, and Visualization of Multidimensional Relational Databases. IEEE Trans. Vis. Comput. Graphics (TVCG) 8(1), 52–65 (2002)

    Article  Google Scholar 

  24. Torlone, R.: Conceptual Multidimensional Models. In: Rafanelli, M. (ed.) Multidimensional Databases: Problems and Solutions. ch. 3, pp. 69–90. Idea Group Inc. (2003)

    Google Scholar 

  25. Tournier, R.: OLAP model, algebra and graphic language for multidimensional databases. Scientific Report n° IRIT/RR—2007-6–FR, IRIT, Université Paul Sabatier (Toulouse 3), France

    Google Scholar 

  26. Trujillo, J.C., Luján-Mora, S., Song, I.: Applying UML for designing multidimensional databases and OLAP applications. In: Siau, K. (ed.) Advanced Topics in Database Research, vol. 2, pp. 13–36. Idea Group Publishing (2003)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. IRIT, Institut de Recherche en Informatique de Toulouse, Université Toulouse 3 (Paul Sabatier), 118 route de Narbonne, F-31062 Toulouse CEDEX9, France

    Franck Ravat, Olivier Teste, Ronan Tournier & Gilles Zurfluh

Authors
  1. Franck Ravat
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Olivier Teste
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Ronan Tournier
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Gilles Zurfluh
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Yannis Ioannidis Boris Novikov Boris Rachev

Rights and permissions

Reprints and permissions

Copyright information

© 2007 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Ravat, F., Teste, O., Tournier, R., Zurfluh, G. (2007). Graphical Querying of Multidimensional Databases. In: Ioannidis, Y., Novikov, B., Rachev, B. (eds) Advances in Databases and Information Systems. ADBIS 2007. Lecture Notes in Computer Science, vol 4690. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-75185-4_22

Download citation

  • DOI: https://doi.org/10.1007/978-3-540-75185-4_22

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-75184-7

  • Online ISBN: 978-3-540-75185-4

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation