Experimental study of a self-tuning algorithm for DBMS buffer pools

Journal of Database Management

Volumn 16, Issue 2, 2005, Pages 1-20

  Martin, Patrick ^a   Powley, Wendy ^a   Zheng, Min ^a   Romanufa, Keri ^b  

^a QUEEN S UNIVERSITY   (Canada)

^b IBM TORONTO LAB   (Canada)

Author keywords

Buffer management; Database systems performance; Resource management; Self tuning database management systems

Indexed keywords

ALGORITHMS; COMPUTATIONAL COMPLEXITY; ESTIMATION; KNOWLEDGE ENGINEERING; MULTIMEDIA SYSTEMS; OPTIMIZATION; PROBLEM SOLVING;

BUFFER MANAGEMENT; DATABASE SYSTEMS PERFORMANCE; RESOURCE MANAGEMENT; SELF-TUNING DATABASE MANAGEMENT SYSTEMS;

DATABASE SYSTEMS;

EID: 15744405741     PISSN: 10638016     EISSN: None     Source Type: Journal    
DOI: 10.4018/jdm.2005040101     Document Type: Article

References (22)

1. Agrawal, S., Chaudhuri, S., & Narasayya, V. (2000, Sept). Automated selection of materialized views and indexes. Proceedings of the 26th International Conference on Very Large Databases, Cairo, Egypt (pp. 496-505).
2. Arcangeli, J.-P., Hameurlain, A., Migeon, F., & Morvan, F. (2004). Mobile agent based self-adaptive join for wide-area distributed query processing. 15(4), 25-45.
3. Belady, L. (1966). A study of replacement algorithms for a virtual-storage computer. IBM Systems Journal, 5(2), 78-101.
4. Brown, K., Carey, M., & Livny, M. (1993, Aug). Managing memory to meet multiclass workload response time goals. Proceedings of the 19th International Conference on Very Large Databases, Dublin, Ireland (pp. 328-341).
5. Brown, K., Carey, M., & Livny, M. (1996, June). Goal-oriented buffer management revisited. Proceedings of the 1996 ACM SIGMOD International Conference on Management of Data, Montreal, Canada (pp. 353-364).
6. Chaudhuri, S., & Weikum, G. (2000, Sept). Rethinking database system architecture: Towards a self-tuning RISC-style database architecture. Proceedings of the 26th International Conference on Very Large Databases, Cairo, Egypt (pp. 1-10).
7. Chaudhuri, S., Christensen, E., Graefe, G., Narasayya, V., & Zwilling, M. (1999). Self-tuning technology in Microsoft SQL Server. IEEE Data Engineering Bulletin, 22(2), 20-26.
8. Chou, H., & DeWitt, D. (1985, Aug). An evaluation of buffer management strategies for relational database systems. Proceedings of the 11th International Conference on Very Large Databases, Stockholm, Sweden (pp. 127-141).
9. Chung, J.-Y., Ferguson, D., Wang, G., Nikolaou, C., & Teng, J. (1995, Nov). Goal-oriented dynamic buffer pool management for database systems. Proceedings of the International Conference on Engineering of Complex Systems (ICECCS'95) (pp. 191-198).
10. Effelsberg, W., & Härder, T. (1984). Principles of database buffer management. ACM Transactions on Database Systems, 9(4), 560-595.
11. Faloutsos, C., Ng, R., & Sellis, T. (1991). Predictive load control for flexible buffer allocation. Proceedings of the 17th International Conference on Very Large Databases, Barcelona, Catalonia, Spain (pp. 265-274).
12. IBM. (2004). DB2 Universal Database. Retrieved December 23, 2004: http://www.software.ibm.com/data/db2/udb
13. Isaacson, E., & Keller, H. (1966). Analysis of numerical methods. New York: John Wiley & Sons.
14. Khan, L., McLeod, D., & Shahabi, C. (2001). An adaptive probe-based technique to optimize join queries in distributed Internet databases. Journal of Database Management, 12(4), 3-14.
15. Leutenegger, S.T., & Dias, D. (1993). A modeling study of the TPC-C benchmark. Proceedings of the 1993 ACM SIGMOD International Conference on Management of Data, Washington, DC (pp. 22-31).
16. Nikolaou, C., Ferguson, D., & Constantopoulos, P. (1992, April). To wards goal-oriented resource management (IBM Research Report No. RC17919).
17. O'Neil, E.J., O'Neil, P.E., & Weikum, G. (1993). The LRU-K page replacement algorithm for database disk buffering. Proceedings of the 1993 ACM SIGMOD International Conference on Management of Data, Washington, DC (pp. 297-306).
18. Schiefer, B., & Valentin, G. (1999, June). DB2 universal database performance tuning. IEEE Data Engineering Bulletin, 22(2), 12-19.
19. Sinnwell, M., & König, A.C. (1999, March). Managing distributed memory to meet multiclass workload response time goals. Proceedings of the 15th International Conference on Data En gineering, Sydney, Australia (pp. 87-94).
20. Transaction Processing Performance Council. (2004). Benchmark specifications. Retrieved December, 23, 2004: http://www.tpc.org
21. Weikum, G., Christian, A., Kraiss, A., & Sinnwell, M. (1999, June). Towards selftuning memory management for data servers. IEEE Data Engineering Bulletin, 22(2), 3-11.
22. Weikum, G., Möenkeberg, A., Hasse, C., & Zabback, P. (2002, Aug). Self-tuning database technology and information services: From wishful thinking to viable engineering. Proceedings of the 28th International Conference on Very Large Databases, Hong Kong, China (pp. 20-31).