Article in Proceedings INPROC-2001-32

BibliographySchwarz, Holger; Wagner, Ralf; Mitschang, Bernhard: Improving the Processing of Decision Support Queries: The Case for a DSS Optimizer.
In: Adiba, Michel (ed.); Collet, Christine (ed.); Desai, Bipin C. (ed.): Proc. of the 2001 International Database Engineering & Applications Symposium (IDEAS), July 16-18, 2001.
University of Stuttgart, Faculty of Computer Science.
pp. 177-186, english.
Los Alamitos, Washington, Brussels, Tokyo: IEEE Computer Society, July 2001.
ISBN: 0-7695-1140-6.
Article in Proceedings (Conference Paper).
CR-SchemaH.4.2 (Information Systems Applications Types of Systems)
KeywordsDecision Support; OLAP; Data Warehouse
Abstract

Many decision support applications are built upon data mining and OLAP tools and allow users to answer information requests based on a data warehouse that is managed by a powerful DBMS. In this paper, we focus on tools that generate sequences of SQL statements in order to produce the requested information. Our thorough analysis revealed that many sequences of queries that are generated by commercial tools are not very efficient. An optimized system architecture is suggested for these applications. The main component is a DSS optimizer that accepts previously generated sequences of queries and remodels them according to a set of optimization strategies, before they are executed by the underlying database system. The advantages of this extended architecture are discussed and a couple of appropriate optimization strategies are identified. Experimental results are given, showing that these strategies are appropriate to optimize typical query sequences of an OLAP application.

Full text and
other links
PDF (126057 Bytes)
Contactholger.schwarz@informatik.uni-stuttgart.de
Department(s)University of Stuttgart, Institute of Parallel and Distributed High-Performance Systems, Applications of Parallel and Distributed Systems
Project(s)ORBIT
Entry dateAugust 8, 2001
   Publ. Department   Publ. Institute   Publ. Computer Science