Automated configuration of multiple buffer pools

Computer Journal

Volumn 49, Issue 4, 2006, Pages 487-499

  Martin, Patrick ^a   Powley, Wendy ^a   Xu, Xiaoyi ^a   Tian, Wenhu ^a  

^a QUEEN S UNIVERSITY   (Canada)

Author keywords

Automatic configuration; Buffer pool; Database; Performance tuning

Indexed keywords

ALGORITHMS; DATA FLOW ANALYSIS; DATABASE SYSTEMS; LOGIC PROGRAMMING; OPTIMAL SYSTEMS;

AUTOMATIC CONFIGURATION; GREEDY ALGORITHM; MULTIPLE BUFFER POOLS;

MULTIPROCESSING PROGRAMS;

EID: 33745698729     PISSN: 00104620     EISSN: 14602067     Source Type: Journal    
DOI: 10.1093/comjnl/bxl028     Document Type: Article

References (33)

1. Weikum, G., Moenkeberg, A., Hasse, C. and Zabback, P. (2002) Self-tuning database technology and information services: From wishful thinking to viable engineering. In Proc. 28th Int. Conf. Very Large Databases, Hong Kong, China, August 20-23, pp. 20-31. Morgan Kauffman Publishers Inc., San Francisco, CA, USA.
2. Chaudhuri, S., Christensen, E., Graefe, G., Narasayya, V. and Zwilling, M. (1999) Self-tuning technology in Microsoft SQL Server. IEEE Data Eng. Bull., 22(2), 20-26.
3. Valentin, G., Zuliani, M., Zilio, D., Lohman, G. and Skelly, A. (2000) DB2 Advisor: An optimizer smart enough to recommend its own indexes. In Proc. 16th Int. Conf. Data Engineering, San Diego, CA, USA, February 28-March 3, pp. 101-110. IEEE Computer Society, Los Alamitos, CA.
4. Agrawal, S., Chaudhuri, S. and Narasayya, V. (2000) Automated selection of materialized views and indexes. In Proc. 26th Int. Conf. Very Large Databases, Cairo, Egypt, September 10-14, pp. 496-505. Morgan Kauffman Publishers Inc., San Francisco, CA, USA.
5. Martin, P., Li, H., Zheng, M., Romanufa, K. and Powley, W. (2000) Dynamic reconfiguration algorithm: Dynamic tuning of multiple buffer pools. In Proc. Conf. Database and Expert Systems Applications (DEXA'2000), London, UK, September 4-8, pp. 92-101. Springer-Verlag, New York.
6. Sinnwell,M. and Kónig,A.C. (1999) Managing distributed memory to meet multiclass workload response time goals. In Proc. 15th Int. Conf. Data Engineering, Sydney, Australia, March 23-26, pp. 87-94. IEEE Computer Society, Los Alamitos, CA.
7. Weikum, G., Christian, A., Kraiss, A. and Sinnwell, M. (1999) Towards self-tuning memory management for data servers. IEEE Data Eng. Bull., 22(2), 3-11.
8. IBM. (2003) DB2 Universal Database Version 8.1 Administration Guide: Performance.
9. Brown, K., Carey, M. and Livny, M. (1993) Towards an autopilot in the DBMS performance cockpit. In Proc. Conf. High Performance Transaction-Processing Systems, Pacific Grove, CA, USA, September 26-29.
10. Bernstein, P. et al. (1998) The Asilomar report on database research. ACM SIGMOD Rec., 27(4), 74-80.
11. Schiefer, B. and Valentin, G. (1999) DB2 universal database performance tuning. IEEE Data Eng. Bull., 22(2), 12-19.
12. Brown, K., Carey, M. and Livny, M. (1993) Managing memory to meet multiclass workload response time goals. In Proc. 19th Int. Conf. Very Large Databases, Dublin, Ireland, August 24-27, pp. 328-341. Morgan Kauffman Publishers Inc., San Francisco, CA, USA.
13. Chung, J.-T., Ferguson, D., Wang, G., Nikolaou, C. and Teng, J. (1995) Goal-oriented dynamic buffer pool management for database systems. In Proc. Int. Conf. Engineering of Complex Systems (ICECCS'95), Ft Lauderdale, FL, USA, November 6-10, pp. 191-198. IEEE Computer Society, Los Alamitos, CA.
14. Chaudhuri, S. and Weikum, G. (2000) Rethinking database system architecture: Towards a self-tuning RISC-style database architecture. In Proc. 26th Int. Conf. Very Large Databases, Cairo, Egypt, September 10-14, pp. 1-10. Morgan Kauffman Publishing Inc., San Francisco, CA, USA.
15. IBM. (2001) Autonomic Computing: IBM's Perspective on the State of Information Technology. Available at http://www-1.ibm.com/industries/ government/doc/content/bin/auto.pdf.
16. Lohman, G., Valentin, G., Zilio, D., Zuliani, M. and Skelly, A. (2000) DB2 Advisor: An optimizer smart enough to recommend its own indexes. In Proc. 16th IEEE Conf. Data Engineering, San Diego, CA, USA, February 28-March 3, pp. 101-110. IEEE Computer Society.
17. Microsoft Corp. (2002) Microsoft SQL Server 2000 Documentation.
18. Oracle Corp. (2001) Oracle 9i Manageability Features. An Oracle White Paper, September. Available at http://www.oracle.com/ip/deploy/database/ oracle9i/collateral/ma_bwp10.pdf.
19. Oracle 9i Materialized Views. An Oracle White Paper, May 2001. Available at http://technet.oracle.com/products/oracle9i/pdf/o9i_mv.pdf.
20. Xu, X., Martin, P. and Powley, W. (2002) Configuring buffer pools in DB2UDB. In Proc. CASCON 2002, Toronto, ON, Canada, September 30-October 3, pp. 171-182. IBM Press, Toronto, ON, Canada.
21. Nikolaou, C., Labrinidis, A., Bohn, V., Ferguson, D., Artavanis, M., Kloukinas, C. and Marazakis, M. (1998) The Impact of Workload Clustering on Transaction Routing. Technical Report FORTH-ICS TR-238.
22. Dan, A., Yu, P. and Chung, J.-Y. (1995) Characterization of database access pattern for analytic prediction of buffer hit probability. VLDB J., 4(1), 127-154.
23. Dan, A., Yu, P. and Chung, J.-Y. (1993) Database access characterization for buffer hit prediction. In Proc. 9th Int. Conf. Data Engineering, Vienna, Austria, April 19-23, pp. 134-143. IEEE Computer Society, Los Alanitos, CA.
24. Brown, K., Carey, M. and Livny, M. (1996) Goal-oriented buffer management revisited. In Proc. 1996 ACM SIGMOD Int. Conf. Management of Data, Montreal, Quebec, Canada, June 4-6, pp. 353-364. ACM Press, New York, NY.
25. Belady, L. A. (1966) A study of replacement algorithms for virtual storage computer. IBM Syst. J., 5(2), 78-101.
26. Horst, R. and Tuy, H. (1996) Global Optimization-Deterministic Approaches. Springer, Berlin/Heidelberg/New York.
27. Mockus, J., Eddy, W., Mockus, A., Mockus, L. and Reklaitis, G. (1996) Bayesian Heuristic Approach to Discrete and Global Optimization. Kluwer Academic Publishers, Dordrecht/Boston/London.
28. Zhigljavsky, A. A. (1991) Theory of Global Random Search. Kluwer Academic Publishers, Dordrecht/Boston/London.
29. Reeves, C. (Ed). (1993) Modern Heuristic Techniques for Combinatorial Problems. John Wiley & Sons, Inc., New York, NY, USA.
30. Tian, W., Powley, W. and Martin, P. (2003) Techniques for automatically sizing multiple buffer pools in DB2. In Proc. CASCON 2003, Toronto, ON, Canada, October 6-9, pp. 237-245. IBM Press, Toronto, ON, Canada.
31. Transaction Processing Council (2004) TPC-C Benchmark Specification. Available at http://www.tpc.org.
32. Ogeer, N. (2004) Buffer Management Strategies for PostgreSQL. M.Sc. ThesisSchool of Computing, Queen's University, Kingston, ON, Canada.
33. Jain, A. K., Murty, M. N. and Flynn, P. J. (1999) Data clustering: A review. ACM Comput. Surv., 31(3), 264-323.