Graphical Querying of Multidimensional Databases

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.

[1]  Luca Cabibbo,et al.  From a procedural to a visual query language for OLAP , 1998, Proceedings. Tenth International Conference on Scientific and Statistical Database Management (Cat. No.98TB100243).

[2]  Chang Li,et al.  A data model for supporting on-line analytical processing , 1996, CIKM '96.

[3]  Esteban Zimányi,et al.  Hierarchies in a multidimensional model: From conceptual modeling to logical representation , 2006, Data Knowl. Eng..

[4]  Gabriel M. Kuper,et al.  A Distributed Algorithm for Robust Data Sharing and Updates in P2P Database Networks , 2004, EDBT Workshops.

[5]  Barbara Dinter,et al.  Extending the E/R Model for the Multidimensional Paradigm , 1998, ER Workshops.

[6]  Luca Cabibbo,et al.  Querying Multidimensional Databases , 1997, DBPL.

[7]  Mark Sifer.  A visual interface technique for exploring OLAP data with coordinated dimension hierarchies , 2003, CIKM '03.

[8]  Hamid Pirahesh,et al.  Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Totals , 1996, Data Mining and Knowledge Discovery.

[9]  Il-Yeol Song,et al.  Applying UML For Designing Multidimensional Databases And OLAP Applications , 2003, Advanced Topics in Database Research, Vol. 2.

[10]  Keng Siau,et al.  Advanced Topics In Database Research , 2005 .

[11]  Matteo Golfarelli,et al.  The Dimensional Fact Model: A Conceptual Model for Data Warehouses , 1998, Int. J. Cooperative Inf. Syst..

[12]  Maurizio Rafanelli,et al.  Operators for Multidimensional Aggregate Data , 2003, Multidimensional Databases.

[13]  Mukesh K. Mohania,et al.  Advances in Database Technologies , 1999, Lecture Notes in Computer Science.

[14]  Sebastian Maneth,et al.  Efficient Memory Representation of XML Documents , 2005, DBPL.

[15]  Pat Hanrahan,et al.  Polaris: a system for query, analysis and visualization of multi-dimensional relational databases , 2000, IEEE Symposium on Information Visualization 2000. INFOVIS 2000. Proceedings.

[16]  Laks V. S. Lakshmanan,et al.  A Foundation for Multi-dimensional Databases , 1997, VLDB.

[17]  Sunita Sarawagi,et al.  Modeling multidimensional databases , 1997, Proceedings 13th International Conference on Data Engineering.

[18]  Ralph Kimball,et al.  The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses , 1996 .

[19]  Isidro Ramos,et al.  Advances in Database Technology — EDBT'98 , 1998, Lecture Notes in Computer Science.

[20]  Alberto Abelló,et al.  Research in data warehouse modeling and design: dead or alive? , 2006, DOLAP '06.

[21]  Michael Böhnlein,et al.  Visual Specification of Multidimensional Queries Based on a Semantic Data Model , 2002 .

[22]  Wolfgang Lehner,et al.  Modelling Large Scale OLAP Scenarios , 1998, EDBT.

[23]  Matteo Golfarelli,et al.  WAND: A CASE Tool for Workload-Based Design of a Data Mart , 2002, SEBD.

[24]  Riccardo Torlone.  Conceptual Multidimensional Models , 2003, Multidimensional Databases.

[25]  Enrico Franconi,et al.  The GMD Data Model and Algebra for Multidimensional Information , 2004, CAiSE.

[26]  Maurizio Rafanelli.  Multidimensional Databases: Problems and Solutions , 2003 .

[27]  Timo Niemi,et al.  Multidimensional Data Model and Query Language for Informetrics , 2003, J. Assoc. Inf. Sci. Technol..

[28]  José Samos,et al.  YAM2: a multidimensional conceptual model extending UML , 2006, Inf. Syst..

[29]  Christian S. Jensen,et al.  A foundation for capturing and querying complex multidimensional data , 2001, Inf. Syst..

[30]  Anindya Datta,et al.  The cube data model: a conceptual model and algebra for on-line analytical processing in data warehouses , 1999, Decis. Support Syst..