Graphical Querying of Multidimensional Databases

  • Franck Ravat
  • Olivier Teste
  • Ronan Tournier
  • Gilles Zurfluh
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, 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.

Keywords

Multidimensional Data Graphical Query Graphic Language Graphic Operation Very Large Data Base 
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.
This is a preview of subscription content, log in to check access.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. 1.
    Abelló, A., Samos, J., Saltor, F.: YAM2: a multidimensional conceptual model extending UML. Information Systems (IS) 31(6), 541–567 (2006)CrossRefGoogle Scholar
  2. 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)CrossRefGoogle Scholar
  3. 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. 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. 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. 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. 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)CrossRefGoogle Scholar
  8. 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. 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)CrossRefGoogle Scholar
  10. 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. 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. 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. 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. 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)CrossRefGoogle Scholar
  15. 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. 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)CrossRefGoogle Scholar
  17. 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. 18.
    Pedersen, T., Jensen, C., Dyreson, C.: A foundation for capturing and querying complex multidimensional data. Information Systems (IS)  26(5), 383–423 (2001)MATHCrossRefGoogle Scholar
  19. 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. 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. 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. 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. 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)CrossRefGoogle Scholar
  24. 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. 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. 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

Copyright information

© Springer-Verlag Berlin Heidelberg 2007

Authors and Affiliations

  • Franck Ravat
    • 1
  • Olivier Teste
    • 1
  • Ronan Tournier
    • 1
  • Gilles Zurfluh
    • 1
  1. 1.IRIT, Institut de Recherche en Informatique de Toulouse, Université Toulouse 3 (Paul Sabatier), 118 route de Narbonne, F-31062 Toulouse CEDEX9France

Personalised recommendations