ACM SIGMOD Anthology VLDB dblp.uni-trier.de

The Query Optimizer in Tandem's new ServerWare SQL Product.

Pedro Celis: The Query Optimizer in Tandem's new ServerWare SQL Product. VLDB 1996: 592
@inproceedings{DBLP:conf/vldb/Celis96,
  author    = {Pedro Celis},
  editor    = {T. M. Vijayaraman and
               Alejandro P. Buchmann and
               C. Mohan and
               Nandlal L. Sarda},
  title     = {The Query Optimizer in Tandem's new ServerWare SQL Product},
  booktitle = {VLDB'96, Proceedings of 22th International Conference on Very
               Large Data Bases, September 3-6, 1996, Mumbai (Bombay), India},
  publisher = {Morgan Kaufmann},
  year      = {1996},
  isbn      = {1-55860-382-4},
  pages     = {592},
  ee        = {db/conf/vldb/Celis96.html},
  crossref  = {DBLP:conf/vldb/96},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}
BibTeX

Abstract

Tandem has re-written its SQL compiler and its query execution engine into a new product that will be available in multiple operating systems. The new product uses a very different query optimization engine and the talk will highlight the unique aspects of the new query optimizer focusing primarily on the search engine.

A brief overview of NonStop SQL product will be followed by a description of what is different in ServerWare SQL. The current NonStop SQL optimizer uses a traditional bottom-up dynamic programming optimizer. This is the same type of optimization algorithm used in System R and many commercial products. The optimizer in the new product is a top-down branch and bound rule-driven cost based optimizer similar to work done on the Volcano optimizer.

The time and space complexity of several common SQL optimization search spaces will be presented. We will then contrast the space performance of the top down optimizer search engine with the more traditional bottom up search engine used in NonStop SQL and other commercial products showing where dynamic programming is more efficient.

The problems in controlling the time complexity of the top down search engine will then be discussed. The time complexity of rule driven optimizers is very sensitive to the set of rules used to describe the search space. Different rule-sets that describe the same space can

The top down optimization engine does provide very significant benefits in the extensibility and ease of adding new query transformations that should be done on the basis of cost. Dynamic programming optimizers like Starburst have dealt with this problem only by modifing the query graph and re-starting the optimization process. The talk will conclude with a brief comparison of results.

Copyright © 1996 by the VLDB Endowment. Permission to copy without fee all or part of this material is granted provided that the copies are not made or distributed for direct commercial advantage, the VLDB copyright notice and the title of the publication and its date appear, and notice is given that copying is by the permission of the Very Large Data Base Endowment. To copy otherwise, or to republish, requires a fee and/or special permission from the Endowment.


Online Paper

ACM SIGMOD Anthology

CDROM Version: Load the CDROM "Volume 1 Issue 5, VLDB '89-'97" and ... DVD Version: Load ACM SIGMOD Anthology DVD 1" and ... BibTeX

Printed Edition

T. M. Vijayaraman, Alejandro P. Buchmann, C. Mohan, Nandlal L. Sarda (Eds.): VLDB'96, Proceedings of 22th International Conference on Very Large Data Bases, September 3-6, 1996, Mumbai (Bombay), India. Morgan Kaufmann 1996, ISBN 1-55860-382-4
Contents BibTeX

Electronic Edtion

Referenced by

  1. Clara Nippl, Bernhard Mitschang: TOPAZ: a Cost-Based, Rule-Driven, Multi-Phase Parallelizer. VLDB 1998: 251-262
BibTeX
ACM SIGMOD Anthology - DBLP: [Home | Search: Author, Title | Conferences | Journals]
VLDB Proceedings: Copyright © by VLDB Endowment,
ACM SIGMOD Anthology: Copyright © by ACM (info@acm.org), Corrections: anthology@acm.org
DBLP: Copyright © by Michael Ley (ley@uni-trier.de), last change: Sat May 16 23:46:13 2009