Visual Specification of Multidimensional Queries Based on a Semantic Data Model

In this paper, we presented a new approach of a visual multidimensional querying tool. Instead of introducing a new multidimensional query language or algebra, we focused on the support of the end users to transform easily their requirements into the syntax of a multidimensional query. To disburden the end user from memorization of the knowledge about the underlying multidimensional data structures, our tool bases on a graphical representation of the multidimensional schema in a Semantic Data Warehouse Model (SDWM). Starting from this graphical representation, the tool assists the user in specifYing multidimensional queries easily considering the corresponding integrity constraints. This lead to an improved interpretability of the query specification process

[1]  Laks V. S. Lakshmanan,et al.  nD-SQL: A Multi-Dimensional Language for Interoperability and OLAP , 1998, VLDB.

[2]  Elmar J. Sinz,et al.  Architekturkonzept eines verteilten Data-Warehouse-Systems für das Hochschulwesen , 2001, Wirtschaftsinformatik.

[3]  Jörg Becker,et al.  Fachkonzeptuelle Spezifikation von Führungsinformationssystemen , 1998, Wirtschaftsinf..

[4]  Michael Böhnlein.  Konstruktion semantischer Data-Warehouse-Schemata , 2001 .

[5]  Matteo Golfarelli,et al.  Conceptual design of data warehouses from E/R schemes , 1998, Proceedings of the Thirty-First Hawaii International Conference on System Sciences.

[6]  Limsoon Wong,et al.  A query language for multidimensional arrays: design, implementation, and optimization techniques , 1996, SIGMOD '96.

[7]  Roland Holten,et al.  The MetaMIS approach for the specification of management views on business processes , 2001 .

[8]  Matthias Jarke,et al.  Fundamentals of Data Warehouses , 2000, Springer Berlin Heidelberg.

[9]  Matteo Golfarelli,et al.  WAND: A CASE Tool for Data Warehouse Design , 2001, ICDE Demo Sessions.

[10]  Achim Ulbrich-vom Ende,et al.  Business Process Oriented Development of Data Warehouse Structures , 2000 .

[11]  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).

[12]  Larry P. English.  Improving Data Warehouse and Business Information Quality: Methods for Reducing Costs and Increasing Profits , 1999 .

[13]  Carsten Sapia,et al.  GraMMi: using a standard repository management system to build a generic graphical modeling tool , 2000, Proceedings of the 33rd Annual Hawaii International Conference on System Sciences.

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