Technischer Bericht TR-2001-02

Schwarz, Holger; Wagner, Ralf; Mitschang, Bernhard: Improving the Processing of Decision Support Queries: Strategies for a DSS Optimizer.
Universität Stuttgart, Fakultät Informatik, Fakultätsbericht Nr. 2001/02.
20 Seiten, englisch.
CR-Klassif.H.2.4 (Database Management Systems)
H.2.7 (Database Administration)
H.2.8 (Database Applications)
KeywordsDecision Support, OLAP, Data Warehouse

Many decision support applications are built upon data mining and OLAP tools and allow us-ers 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 que-ries that are generated by commercial tools are not very efficient. An optimized system architec-ture 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 iden-tified. Experimental results are given, showing that these strategies are appropriate to optimize query sequences of OLAP applications.

Volltext und
andere Links
PostScript (1090725 Bytes)
Abteilung(en)Universität Stuttgart, Institut für Parallele und Verteilte Höchstleistungsrechner, Anwendersoftware
Eingabedatum5. Juni 2001
   Publ. Abteilung   Publ. Institut   Publ. Informatik