Buffer pool aware query optimization

2nd Biennial Conference on Innovative Data Systems Research, CIDR 2005

Volumn , Issue , 2005, Pages 250-261

  Ramamurthy, Ravishankar ^a   DeWitt, David J ^a  

^a University of Wisconsin Madison   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

BUFFER POOL CONFIGURATION; DATA-BASE SERVERS; GENERIC ARCHITECTURE; MAIN MEMORY; OPTIMIZERS; QUERY OPTIMIZATION;

OPTIMIZATION;

LAKES;

EID: 79952018792     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: None     Document Type: Conference Paper

References (27)

1. S.Acharya et al. Join Synopses for Approximate Query Answering. Proceedings of SIGMOD 1999.
2. G.Antoshenkov Dynamic Query Optimization in Rdb/VMS. Proceedings of ICDE 1993.
3. R.Avnur, J.Hellerstein. Eddies:Continuous Query Optimization. Proceedings of SIGMOD 2000.
4. P.Boncz, M.Kersten. Monet: An Impressionist Sketch of an Advanced Database System. Proceedings of Basque International Workshop on Information Technology 1995.
5. M.Carey et al. Shoring up Persistent Applications. Proceedings of SIGMOD 1994.
6. rd edition 1977
7. G.Copeland, S.Khosefian A Decomposition Storage Model. Proceedings of SIGMOD 1985.
8. H.Garcia-Molina, K.Salem Main Memory Database Systems: An Overview. TKDE 4(6):1992
9. G.Graefe Query Evaluation Techniques for Large Databases. ACM Computing Surveys 25 (2): 1993
10. J.Gray, P. Shenoy Rules of Thumb in Data Engineering. Proceedings of ICDE 2000.
11. J.Gray, G.Graefe The 5-minute rule revisited and other storage rule of thumb ACM Sigmod Record 26(4):1997
12. L.Hass et al. Extensible Query Processing in Starbust. Proceedings of SIGMOD 1989.
13. Y.Ioannidis, S.Christodoulakis On the propagation of errors in the size of join results. Proceedings of SIGMOD 1991.
14. Z.Ives et al. An adaptive query execution system for data integration. Proceedings of SIGMOD 1999.
15. N.Kabra, D.DeWitt Efficient Mid-Query Re- Optimization of sub-optimal query execution plans. Proceedings of SIGMOD 1998.
16. N.Kabra, D.DeWitt Opt++: An Object Oriented Implementation for Extensible Query Optimization. VLDB Journal 8(1):1999
17. D.E.Knuth The Art of Computer Programming (vol II). Addison Wesley Inc. 1969
18. L.Mackert, G.Lohman R* Optimizer validation and performance evaluation for local queries. Proceedings of SIGMOD 1986.
19. F.Olken Random Sampling from databases (PhD Thesis) 1993
20. V.Poosala et al. Improved Histograms for Selectivity Estimation of Range Predicates. Proceedings of SIGMOD 1996.
21. P.Selinger et al. Access path selection in a relational database system. Proceedings of SIGMOD 1979.
22. M.Stillger et al. LEO- DB2's Learning optimizer. Proceedings of VLDB 2001.
23. P.Valduriez Join Indexes. ACM TODS 12(2):1987
24. E.Wong, K.Youssefi Decomposition- A Strategy for query proceesing. ACM TODS 1(3): 1976
25. S.B.Yao Approximating block accesses in database organizations. CACM 20(4): 1977
26. Times Ten White Paper. www.timesten.com
27. TPC-H benchmark specification. www.tpc.org