ABSTRACT
This paper describes the Query Rewrite facility of the Starburst extensible database system, a novel phase of query optimization. We present a suite of rewrite rules used in Starburst to transform queries into equivalent queries for faster execution, and also describe the production rule engine which is used by Starburst to choose and execute these rules. Examples are provided demonstrating that these Query Rewrite transformations lead to query execution time improvements of orders of magnitude, suggesting that Query Rewrite in general—and these rewrite rules in particular—are an essential step in query optimization for modern database systems.
- ABC+76.M. Astrahan, M. Blasgen, D. Chamberlin, K. Eswaran, J. Gray, P. Griffiths, W. King, R. Lorie, P. McJones, J. Mehl, G. Putzolu, I. Traiger, B. Wade, and V. Watson. System R: Relational Approach to Database Management. ACM Transactions on Database Systems, 1(2):97-137, June 1976. Google ScholarDigital Library
- Anf89.Ole Jirgen Anfindsen.A Study of Access Path Selection in DB2. Technical report, Norwegian Telecommunications Administration and University of Oslo, Norway, October 1989.Google Scholar
- BFKM85.L. Brownston, R. Farrell, E. Kant, and N. Martin. Programming Expert Systems in OPS5. Addison-Wesley Publishing Co., 1985. Google ScholarDigital Library
- BTA90.Jose Blakeley, Craig Thompson, and Abdallah Alashqur. Strawman reference model for object query language. In First OODB Standardization Workshop, X3/SPARC/DBSSG/OODBTG, Atlantic City, New Jersey, May 1990.Google Scholar
- Day87.Umeshwar Dayal. Of Nests and Trees: A Unified Approach to Processing Queries that Contain Nested Subqueries, Aggregates, and Quantifiers. In Proc. 13th International Conference on Very Large Data Bases, pages 197-208, Brighton, September 1987. Google ScholarDigital Library
- GW87.Richard A. Ganski and Harry K. T. Wong. Optimization of Nested SQL Queries Revisited. In Proc. ACM- SIGMOD International Conference on Management of Data, pages 23-33, San Francisco, May 1987. Google ScholarDigital Library
- HCL+90.L.M. Haas, W. Chang, G.M. Lohman, J. McPherson, P.F. Wilms, G. Lapis, B. Lindsay, H. Pirahesh, M. Carey, and E. Shekita. Starburst Mid-Flight: As the Dust Clears. 1EEE Transactions on Knowledge and Data Engineering, pages 143-160, March 1990. Google ScholarDigital Library
- HH91.Joseph M. Hellerstein and Meichun Hsu. Determinism in Partially Ordered Production Systems. Research Report RJ 8089, IBM Almaden Research Center, March 1991.Google Scholar
- HP88.Waqar Hasan and Hamid Pirahesh. Query Rewrite Optimization in Starburst. Research Report RJ 6367, IBM Almaden Research Center, August 1988.Google Scholar
- HSS88.T. Haerder, H. Schoning, and A. Sikeler. Parallelism in Processing Queries on Complex Object. In Proc. International Symposium on Databases in Parallel and Distributed Systems, Austin, December 1988. Google ScholarDigital Library
- ISO91.ISO_ANSI. Database Language SQL ISOBEC 9075:1992, 1991.Google Scholar
- Kim82.W. Kim. On Optimizing an SQL-like Nested Query. ACM Transactions on Database Systems, 7(3), September 1982. Google ScholarDigital Library
- LLOW91.Chares Lamb, Gordon Landis, JackOrenstein, and Dan Weinreb. The Objectstore Database System. Communications of the ACM. October 1991. Google ScholarDigital Library
- LLPS91.Guy Lohman, Bruce Lindsay, Hamid Pirahesh, and Bemhard Schiefer. Extensions to Starburst: Objects, Types, Functions, and Rules. Communications of the ACM, October 1991. Google ScholarDigital Library
- Loo86.Chris Loosley. Measuring IBM Database 2 Release 2 - The Benchmark Game. InfoDB, 1(2), 1986.Google Scholar
- MF78.J. McDermott and C. Forgy. Production System Conflict Resolution Strategies. In D.A. Waterman and Fredrick Hayes-Roth, editors, Pattern Directed Inference Systems, pages 177-199. Academic Press, 1978.Google ScholarCross Ref
- MFPR90a.Inderpal Singh Mumick, SheldonJ. Finkelstein, Hamid Pirahesh, and Raghu Ramakrishnan. Magic is Relevant. In Proc. SIGMOD 90 {Pro90}, pages 247-258. Google ScholarDigital Library
- MFPR90b.Inderpal Singh Mumick, Sheldon J. Finkelstein, Hamid Pirahesh, and Raghu Ramakrishnan. Magic Conditions. In Proc. 9th ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems, pages 314-330, Nashville, March 1990. Google ScholarDigital Library
- MPR90.Inderpal Singh Mumick, Hamid Pirahesh, and Raghu Ramakrishnan. The Magic of Duplicates and Aggregates. In Proc. 16th International Conference on Very Large Data Bases, Brisbane, August 1990. Google ScholarDigital Library
- O'N89.P. O'Neil. Revisiting DBMS Benchmarks. Datamation, pages 47-54, September 15, 1989.Google Scholar
- Pir89.Hamid Pirahesh. Early Experience with Rule-Based Query Rewrite Optimization. In G. Graefe, editor, Workshop on Database Query Optimization, CSE Technical Report 89-005. Oregon Graduate Center, May 1989.Google Scholar
- Pro90.Proc. ACM-SIGMOD International Conference on Management of Data, Atlantic City, May 1990.Google Scholar
- Ras90.Louiqa Raschid. Maintaining Consistency in a Stratified Production System Program. In Proc. AAAI National Conference on Artificial Intelligence, 1990.Google Scholar
- RGL90.Arnon Rosenthal and Cesar Galindo-Legaria. Query graphs, implementing trees, and freely-reorderable outerjoins. In Proc. SIGMOD 90 {Pro90}. Google ScholarDigital Library
- SAC+79.Patricia G. Selinger, M. Astrahan, D. Chamberlin, Raymond Lorie, and T. Price. Access Path Selection in a Relational Database Management System. In Proc. ACM-SIGMOD International Conference on Management of Data, Boston, June 1979. Google ScholarDigital Library
- SJGP90.M. Stonebraker, A. Jhingran, Jeffrey Goh, and Spyros Potamianos. On rules, procedures, caching and views in data base systems, in Proc. SIGMOD 90 {Pro90}. Google ScholarDigital Library
- SWK76.M.R. Stonebraker, E. Wong, and P. Kreps. The design and implementation of ingres. ACM Transactions on Database Systems, 1 (3):189-222, September 1976. Google ScholarDigital Library
- TOB89.C. Turbyfill, C. Orji, and Dina Bitton. AS3AP - A Comparative Relational Database Benchmark. In Proc. IEEE Compcon Spring '89, February 1989.Google Scholar
- ZH90.Yuli Zhou and Meichun Hsu. A Theory for Rule Triggering Systems. In Francois Bancilhon, Costantino Thanos, and Dennis Tsichritzis, editors, Proc. International Conference on Extending Data Base Technology, Advances in Database Technology - EDBT '90. Lecture Notes in Computer Science, Volume 416, Venice, March 1990. Springer-Verlag. Google ScholarDigital Library
Index Terms
- Extensible/rule based query rewrite optimization in Starburst
Recommendations
Extensible/rule based query rewrite optimization in Starburst
This paper describes the Query Rewrite facility of the Starburst extensible database system, a novel phase of query optimization. We present a suite of rewrite rules used in Starburst to transform queries into equivalent queries for faster execution, ...
Extensible query processing in starburst
Today's DBMSs are unable to support the increasing demands of the various applications that would like to use a DBMS. Each kind of application poses new requirements for the DBMS. The Starburst project at IBM's Almaden Research Center aims to extend ...
Extensible query processing in starburst
SIGMOD '89: Proceedings of the 1989 ACM SIGMOD international conference on Management of dataToday's DBMSs are unable to support the increasing demands of the various applications that would like to use a DBMS. Each kind of application poses new requirements for the DBMS. The Starburst project at IBM's Almaden Research Center aims to extend ...
Comments