Zusammenfassung
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
The flexible architecture of the tool enables further extensions, for example to integrate a component for Microsofts OLE DB for OLAP and the specification of MDX (Multidimensional Extensions) queries
The implemented prototypical tool is a further component of the Java Data Warehousing Toolsuite (Bohnlein, Plaha, Ulbrich-vom Ende 2001). This suite of prototypical tools has been developed to test research assumptions for the improvement of information quality in data warehouse systems. Currently the toolsuite comprises a modeling tool, an extraction and source analysis tool, a tool for the automatic historization during warehouse loading and a query specification tool
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Literatur
Becker, J.; Holten, R.: Fachkonzeptuelle Spezifikation von Führungsinformationssystemen. In: Wirtschaftsinformatik 40 (1998) 6, pp. 483–493
Böhnlein, M.: Konstruktion semantischer Data-Warehouse-Schemata. Wiesbaden 2001
Böhnlein, M.; Holten, R.; Knackstedt, R.; Ulbrich-vom Ende, A.: Identifikation und Anwendung semantischer Modellbausteine für Managementsichten. In: Jablonski, S.; Kirn, S.; Plaha, M.; Sinz, E.J.; Ulbrich-vom Ende, A.; Weiß, G. (Hrsg): Proceedings of Verteilte Informationssysteme auf der Grundlage von Objekten, Komponenten und Agenten (VertIS 2002, Bamberg, 4–5 October).Bamberg 2001, pp. 75–96
Böhnlein, M.; Plaha, M.; Ulbrich-vom Ende, A.: JDW-Toolsuite (Javabasierte Data-Warehouse-Toolsuite). In: Postersession Wirtschaftsinformatik 2001 (WI-IF 2001, Augsburg, 19–21 September).Augsburg 2001
Böhnlein, M.; Ulbrich-vom Ende, A.: Business Process Oriented Development of Data Warehouse Structures. In: Proceedings of Data Warehousing 2000 — Methoden, Anwendungen, Strategien (DW2000, Friedrichshafen, 14–15 November).Heidelberg 2000, pp. 3–22
Böhnlein, M.; Ulbrich-vom Ende, A.: Semantisches Data Warehouse-Modell (SDWM) — ein konzeptuelles Modell für die Erstellung multidimensionaler Datenstrukturen. In: Informationssystem-Architekturen, Rundbrief des GI-Fachausschusses 5.10, No. 1, 2001
Cabibbo, L.; Torlone, R.: From a Procedural to a Visual Query Language for OLAP. In: Tenth IEEE International Conference on Scientific and Statistical Database Management (SSDBM-98) 1998, pp. 74–83
Codd, E.F.; Codd, S.B.; Salley, C.T.: Beyond Decision Support. In: Computerworld 30 (1993) 27, 1993, pp. 87–89
Cognos: Cognos PowerPlay for Windows — PowerPlay User Guide. Cognos, Inc. 2001.http://www.cognos.com
English, L.P.: Improving Data Warehouse and Business Information Quality — Methods for Reducing Costs and Increasing Profits. New York 1999
Gingras, F.; Lakshmanan, L.V.S.: nD-SQL: A Multi-dimensional Language for Interoperability and OLAP. In: Proceedings of 24th International Conference on Very Large Data Bases (VLDB’98, New York, 24–27 August). New York 1998, pp. 134–145
Golfarelli, M.; Maio, D.; Rizzi, S Conceptual Design of Data Warehouses from E/R Schemes. In: Proceedings of the 31st Hawaii International Conference on System Sciences. Kona 1998
Golfarelli, M.; Rizzi, S.: WAND: A CASE Tool for Data Warehouse Design. In: Demo Proceedings of 17th International Conference on Data Engineering (ICDE 2001). Heidelberg 2001, pp. 7–9
Hacid, M.S.; Marcel, P.; Rigotti, C.: A Rule-Based Language for Ordered Multidimensional Databases. In: Proceedings of 5th International Workshop on Deductive Databases and Logic Programming (DDLP’97). 1997, pp. 69–81
Harren, A.; Herden, O.: MML und mUML — Sprache und Werkzeug zur Unterstützung des konzeptionellen Data Warehouse Designs. In: Proceedings of Second GI-Workshop “Data Mining und Data Warehousing als Grundlage moderner entscheidungsunterstützender Systeme”. Magdeburg 1999, pp. 57–68
Holten, R.: The MetaMIS Approach for the Specification of Management Views on Business Processes. In: Technical Report of the Institut for Information Systems Münster, No. 84. Münster 2001
Jarke, M.; Lenzerini, M.; Vassiliou, Y.; Vassiliadis, P.: Fundamentals of Data Warehouses. Berlin 2000
Libkin, L.; Machlin, R.; Wong, L.: A Query Language for Multidimensional Arrays: Design, Implementation, and Optimization Techniques. In: Proceedings of the 1996 ACM SIGMOD International Conference on Management of Data. Montreal, Quebec 1996, pp. 228–239
Microstrategy: MicroStrategy Web and Desktop Products Report Designer Guide Version 7.1. MicroStrategy, Inc. 2001.http://www.microstrategy.com
Plaha, M.: Konzeption eines webbasierten OLAP-Anfragewerkzeugs für Data Warehouse-Systeme (Diploma Thesis, Bamberg, 2000). Bamberg 2000
Raden, N.: Modeling the Data Warehouse. White Paper, Archer Decision Sciences 1996.http://members.aol.com/nraden/iw0196_1.htm
Sapia, C.; Blaschka, M.; Höfling, G.; Dinter, B.: Extending the E/R Model for the Multidimensional Paradigm. In: Proceedings of the International Workshop on Data Warehouse and Data Mining (DWDM-98, 19–20 November, 1998), Singapore. Singapore 1998
Sapia, C.; Blaschka, M.; Höfling, G.: GraMMi: Using a Standard Repository Management System to Build a Generic Graphical Modeling Tool. In: Proceedings of 33rd Annual Hawaii International Conference on System Sciences (HICSS-33, 4–7 January, 2000). Maui 2000
Sinz, E.J.; Böhnlein, M.; Ulbrich-vom Ende, A.; Plaha, M.: Architekturkonzept eines verteilten Data Warehouse-Systems für das Hochschulwesen. In: Proceedings of Wirtschaftsinformatik 2001 (WI-IF 2001, Augsburg, 19–21 September). Augsburg 2001
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2002 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Böhnlein, M., Ulbrich-vom Ende, A., Plaha, M. (2002). Visual Specification of Multidimensional Queries Based on a Semantic Data Model. In: von Maur, E., Winter, R. (eds) Vom Data Warehouse zum Corporate Knowledge Center. Physica, Heidelberg. https://doi.org/10.1007/978-3-642-57491-7_22
Download citation
DOI: https://doi.org/10.1007/978-3-642-57491-7_22
Publisher Name: Physica, Heidelberg
Print ISBN: 978-3-642-63276-1
Online ISBN: 978-3-642-57491-7
eBook Packages: Springer Book Archive