Efficient mid-query re-optimization of sub-optimal query execution plans

SIGMOD Record

Volumn 27, Issue 2, 1998, Pages 106-117

  Kabra, Navin ^a   DeWitt, David J ^a  

^a University of Wisconsin ^*  (United States)

Author keywords

[No Author keywords available]

Indexed keywords

ALGORITHMS; DECISION SUPPORT SYSTEMS; OPTIMIZATION; RELATIONAL DATABASE SYSTEMS; RESOURCE ALLOCATION; RESPONSE TIME (COMPUTER SYSTEMS); STATISTICS; STRATEGIC PLANNING;

PARADISE DATABASE SYSTEMS; QUERY OPTIMIZERS; SUB-OPTIMAL QUERY EXECUTION PLANS;

QUERY LANGUAGES;

EID: 0032093823     PISSN: 01635808     EISSN: None     Source Type: Journal    
DOI: 10.1145/276305.276315     Document Type: Article

References (27)

1. AMSALEG, L., FRANKLIN, M. J., TOMASIC, A., AND URHAN, T. "Scrambling Query Plans to Cope with Unexpected Delays". In The 4th International Conference on Parallel and Distributed Information Systems (PDIS) (Miami Beach, Florida, Dec. 1996).
2. ANTOSHENKOV, G. "Dynamic Query Optimization in Rdb/VMS". In In Proceedings of the IEEE Conference on Data Engineering (1993), pp. 538-547.
3. ANTOSHENKOV, G. "Dynamic Optimization of Index Scan Restricted by Booleans". In In Proceedings of the IEEE Conference on Data Engineering (1996), pp. 430-440.
4. CHEN, M. S., ET AL. "Using Segmented Right-Deep Trees for Execution of Pipelined Hash Joins". In Proc. of the 18th VLDB Conf. (1992).
5. DERR, M. A., MORISHITA, S., AND PHIPPS, G. "Adaptive Query Optimization in a Deductive Database System". In In Proceedings of the Proceedings of the Second International Conference on Information and Knowledge Management (Washington D. C., USA, 1993).
6. FLAJOLET, P., AND MARTIN, G. N. "Probabilistic Counting Algorithms for Database Applications". In Journal of Computer and System Sciences (1985), vol. 31(2), pp. 182-209.
7. GRAEFE, G., AND COLE, R. "Optimization of Dynamic Query Evaluation Plans". In Proceedings of the 1994 ACM-SIGMOD Conference (1994).
8. GRAEFE, G., AND WARD, K. "Dynamic Query Evaluation Plans. In SIGMOD Proceedings (June 1989), ACM, pp. 377-388.
9. IOANNIDIS, Y., AND CHRISTODOULAKIS, S. "On the Propogation of Errors in the Size of Join Results". In Proceedings of the 1991 ACM-SIGMOD Conference (Denver, Colorado, May 1991).
10. IOANNIDIS, Y., NG, R. T., SHIM, K., AND SELLIS, T. "Parametric Query Optimization". In Proc. of the 18th VLDB Conf. (1992).
11. IOANNIDIS, Y., AND POOSALA, V. "Balancing Histogram Optimality and Practicality for Query Result Size Estimation". In Proceedings of the 1995 ACM-SIGMOD Conference (San Jose, California, May 1995).
12. KABRA, N. "Query Optimization for Relational and Object-Relational Database Systems". PhD thesis, University of Wisconsin, Madison, 1998.
13. KABRA, N., AND DEWITT, D. J. "Opt++: An Object Oriented Implementation for Extensible Database Query Optimization". In to appear in The VLDB Journal (1998).
14. MEHTA, M., AND DEWITT, D. J. "Dynamic Memory Allocation for Multiple Query Workloads". In Proc. of the 19th VLDB Conf. (Dublin, Ireland, 1993).
15. NAG, B., AND DEWITT, D. J. "Memory Allocation Strategies for Complex Decision Support Queries". Submitted for publication.
16. ONO, K., AND LOHMANN, G. "Extensible Enumeration of Feasible Joins for Relational Query Optimization". In Proc. of the. 16th VLDB Conf. (Aug. 1990).
17. PATEL, J. M., ET AL. "Building a Scalable Geo-Spatial DMBS: Technology, Implementation, and Evaluation". In Proceedings of the 1997 ACM-SIGMOD Conference (Tuscon, Arizona, May 1997).
18. POOSALA, V. "Zipf's Law". Tech. rep., University of Wisconsin, Madison, 1995.
19. POOSALA, V., AND IOANNIDIS, Y. "Histogram-Based Solutions to Diverse Database Estimation Problems". In Data Engineering Bulletin (1995), vol. 18(3), pp. 10-18.
20. POOSALA, V., IOANNIDIS, Y., HAAS, P. J., AND SHEKITA, E. "Improved Histograms for Selectivity Estimation of Range Predicates". In Proceedings of the 1996 ACM-SIGMOD Conference (Montreal, Canada, June 1996).
21. RAAB, F. "TPC Benchmark D - Standard Specification, Revision 1.0". Transaction Processing Performance Council, May 1995.
22. SELINGER, P., ASTRAHAN, M., CHAMBERLIN, D., LORIE, R., AND PRICE, T. "Access Path Selection in a Relational Database Management System". In Proceedings of the ACM SIGMOD Conference on Management of Data (May 1979).
23. STONEBRAKER, M., ANTON, J., AND HIROHAMA, M. "Extendability in POSTGRES". In Data Engineering Bulletin (1987), vol. 10(2), pp. 16-23.
24. VITTER, J. S. "Random Sampling with a Reservoir". In ACM Transactions on Mathematical Software (1985), vol. 11, pp. 37-57.
25. WONG, E., AND YOUSSEFI, K. "Decomposition - A Strategy for Query Processing". In ACM Transactions on Database Systems (Sept. 1976).
26. YU, P. S., AND CORNELL, D. W. "Buffer Management Based on Return on Consumption in a Multi-Query Environment". In VLDB Journal (Jan. 1993), vol. 2(1).
27. ZIPF, G. K. "Human Behavior and the Principle of Least Resistance". Addison-Wesley, Reading, MA, 1949.