Database Buffer Size Investigation for OLTP Workloads

SIGMOD Record (ACM Special Interest Group on Management of Data)

Volumn 26, Issue 2, 1997, Pages 112-122

  Tsuei, Thin Fong ^a   Packer, Allan N ^a   Ko, Keng Tai ^a  

^a NONE

Author keywords

[No Author keywords available]

Indexed keywords

ALGORITHMS; BUFFER STORAGE; COMPUTER ARCHITECTURE; DATA PROCESSING; MULTIPROCESSING SYSTEMS; ONLINE SYSTEMS; STORAGE ALLOCATION (COMPUTER);

ONLINE TRANSACTION PROCESSING (OLTP);

DATABASE SYSTEMS;

EID: 0031168471     PISSN: 01635808     EISSN: None     Source Type: Journal    
DOI: 10.1145/253262.253279     Document Type: Article

References (19)

1. Amdahl, G., "Validity of the Single Processor Approach to Achieving Large Scale Computing Capabilities", AFIPS Conf. Proceedings, 1967
2. Artis, H., "Quantifying Multiprocessor Overheads", Proceedings of CMG Conference, 1991.
3. Chou, H. and DeWitt, D., "An Evaluation of Buffer Management Strategies for Relational Database Systems", Proceedings of VLDB, 1985.
4. "IBM DB2 Administration Guide for Common Servers", IBM Corp. 1995.
5. "IBM DB2 Information and Concepts Guide for Common Servers", IBM Corp. 1995
6. Dan, A. and Towsley, D., "An Approximate Analysis of the LRU and FIFO Buffer Replacement Schemes", Proceedings of Sigmetrics, 1990.
7. Dan, A., Yu, P. and Chung, J., "Database Access Characterization for Buffer Hit Prediction", Database Engineering Conference, 1993.
8. "DataDesk Statistic Guide", Data Description, Inc.
9. Draper, N. and Smith, H., "Applied Regression Analysis", second edition, John Wiley & Sons, 1981.
10. Effelsberg, Wolfgang and Haerder, "Principles of Database Buffer Management", ACM Transactions on Database Systems, Vol. 9, No. 4, December 1984.
11. Gray, J., Editor, "The Benchmark Handbook for Database and Transaction Processing Systems", Second Edition, Morgan Kaufmann, 1993.
12. Gunther, N., "A Simple Capacity Model for Massively Parallel Transaction Systems", proceedings of CMG, 1993.
13. Gunther, N., "Understanding The MP Effect: Multi-processing in Pictures", to appear in Proceedings of CMG, 1996.
14. Lazowska, E., Zahorjan, J., Graham, G., and Sevcik, K., "Quantitative System Performance", Prentice-Hall, 1984.
15. Leutenegger, S. and Dias, D., "A Modeling Study of the TPC-C Benchmark", proceedings of SIGMOD, 1993.
16. McGalliard, J., "Case Study of Table-Top Sizing with Workload-Specific Estimates of the Multiprocessor Effect", proceedings of CMG Conference, 1995.
17. Mohan, C., Haderle, D., Lindsay, B., and Schwarz, P., "Aries: A Transaction Recovery Method Supporting Fine-Granularity Locking and Partial Rollbacks Using Write-Ahead Logging", ACM Transaction on Database Systems, Vol. 17, No. 1, March 1992.
18. Stonebraker, M., "Operating System Support for Database Management", Communications of the ACM, Vol. 24, No. 7, July 1981.
19. TPC Benchmark C Standard Specification Revision 3.0", Transaction Processing Performance Council, February 15, 1995.