Please use this identifier to cite or link to this item: http://dx.doi.org/10.18419/opus-2467
Authors: Schwarz, Holger
Wagner, Ralf
Mitschang, Bernhard
Title: Improving the processing of decision support queries : strategies for a DSS optimizer
Issue Date: 2001
metadata.ubs.publikation.typ: Arbeitspapier
Series/Report no.: Technischer Bericht / Universität Stuttgart, Fakultät Informatik, Elektrotechnik und Informationstechnik;2001,2
URI: http://nbn-resolving.de/urn:nbn:de:bsz:93-opus-8351
http://elib.uni-stuttgart.de/handle/11682/2484
http://dx.doi.org/10.18419/opus-2467
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 pre-viously 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 query sequences of OLAP applications.
Appears in Collections:05 Fakultät Informatik, Elektrotechnik und Informationstechnik

Files in This Item:
File Description SizeFormat 
TR-2001-02.pdf109,05 kBAdobe PDFView/Open


Items in OPUS are protected by copyright, with all rights reserved, unless otherwise indicated.