The LRU-K Page Replacement Algorithm for Database Disk Buffering

ACM SIGMOD Record

Volumn 22, Issue 2, 1993, Pages 297-306

  O'Neil, Elizabeth J ^a   O'Neil, Patrick E ^a   Weikum, Gerhard ^b  

^a UNIVERSITY OF MASSACHUSETTS BOSTON   (United States)

^b ETH ZURICH   (Switzerland)

Author keywords

[No Author keywords available]

Indexed keywords

BUFFERING ALGORITHM; DATABASE DISKS; INTER-ARRIVAL TIME; K ALGORITHM; K METHODS; KEEP TRACK OF; NEW APPROACHES; PAGE REPLACEMENT ALGORITHMS; STATISTICAL INFERENCE; TIME OF REFERENCES;

DATABASE SYSTEMS; MAGNETIC DISK STORAGE;

ALGORITHMS; BUFFER CIRCUITS; COMPUTER SIMULATION; DATABASE SYSTEMS; STATISTICAL METHODS;

BUFFERING ALGORITHMS; DATABASE DISK BUFFERING; DATABASE PAGES; LEAST RECENTLY USED-K METHOD; OPTIMAL STATISTICAL INFERENCE; PAGE REPLACEMENT ALGORITHM; PAGES MEMORY;

EID: 0027621695     PISSN: 01635808     EISSN: None     Source Type: Journal    
DOI: 10.1145/170036.170081     Document Type: Article

References (26)

1. Rafael Alonso, Daniel Barbara, Hector Garcia-Molina, Data Caching Issues in an Information Retrieval System, ACM Transactions on Database Systems, v. 15, no. 3, pp. 359-384, September 1990.
2. Alfred V. Aho, Peter J. Denning, and Jeffrey D. Ullman: Principles of Optimal Page Replacement. J. ACM, v. 18, no. 1, pp. 80-93, 1971.
3. Ellis E. Chang, Randy H. Katz, Exploiting Inheritance and Structure Semantics for Effective Clustering and Buffering in an Object-Oriented DBMS, Proceedings of the 1989 ACM SIGMOD Conference, pp. 348-357.
4. Hong-Tai Chou and David J. DeWitt: An Evaluation of Buffer Management Strategies for Relational Database Systems. Proceedings of the Eleventh International Conference on Very Large Databases, pp. 127-141, August 1985.
5. George Copeland, Tom Keller, and Marc Smith: Database Buffer and Disk Configuring and the Battle of the Bottlenecks. Proceedings of the Fourth International Workshop on High Performance Transaction Systems, September 1991.
6. C.Y. Chan, B.C. Ooi, H. Lu, Extensible Buffer Management of Indexes, Proceedings of the Eighteenth International Conference on Very Large Data Bases, pp. 444-454, August 1992.
7. Edward G. Coffman, Jr. and Peter J. Denning: Operating Systems Theory. Prentice-Hall, 1973.
8. Asit Dan and Don Towsley: An Approximate Analysis of the LRU and FIFO Buffer Replacement Schemes. Proceedings of the 1990 ACM Sigmetrics Conference, v. 18, No. 1, pp. 143-149.
9. P. J. Denning: The Working Set Model for Program Behavior. Communications of the ACM, v. 11, no. 5, pp. 323-333, 1968.
10. Wolfgang Effelsberg and Theo Haerder: Principles of Database Buffer Management. ACM Transactions on Database Systems, v. 9, no. 4, pp. 560-595, December 1984.
11. Christos Faloutsos, Raymond Ng, and Timos Sellis, Predictive Load Control for Flexible Buffer Allocation, Proceedings of the Seventeenth International Conference on Very Large Data Bases, pp. 265-274, September 1991.
12. Jim Gray and Franco Putzolu: The Five Minute Rule for Trading Memory for Disk Accesses and The 10 Byte Rule for Trading Memory for CPU Time. Proceedings of the 1987 ACM SIGMOD Conference, pp. 395-398.
13. Laura M. Haas et al., Starburst Mid-Flight: As the Dust Clears, IEEE Transactions on Knowledge and Data Engineering, v. 2, no. 1, pp. 143-160, March 1990.
14. R. Jauhari, M. Carey, M. Livny, Priority-Hints: An Algorithm for Priority-Based Buffer Management, Proceedings of the Sixteenth International Conference on Very Large Data Bases, August 1990.
15. D.E. Knuth, The Art of Computer Programming, Volume 3: Sorting and Searching, Addison-Wesley, 1973.
16. Raymond Ng, Christos Faloutsos, T. Sellis, Flexible Buffer Allocation Based on Marginal Gains, Proceedings of the 1991 ACM SIGMOD Conference, pp. 387-396.
17. Elizabeth O'Neil, Patrick O'Neil, and Gerhard Weikum, The LRU-K Page Replacement Algorithm for Database Disk Buffering, Tech. Report 92-4, Department of Mathematics and Computer Science, University of Massachusetts at Boston, December 1, 1992.
18. Mark Palmer, Stanley B. Zdonik, Fido: A Cache That Learns to Fetch, Proceedings of the Seventeenth International Conference on Very Large Databases, pp. 255-264, September 1991.
19. Allen Reiter: A Study of Buffer Management Policies for Data Management Systems. Tech. Summary Rep. No. 1619, Mathematics Research Center, Univ. of Wisconsin, Madison, March 1976.
20. John T. Robinson and Murtha V. Devarakonda: Data Cache Management Using Frequency-Based Replacement. Proceedings of the 1990 ACM Sigmetrics Conference, v. 18, No. 1, pp. 134-142.
21. Giovanni Mario Sacco and Mario Schkolnick: Buffer Management in Relational Database Systems, ACM Transactions on Database Systems, v. 11, no. 4, pp. 473-498, December 1986.
22. Dennis E. Shasha, Database Tuning: A Principled Approach, Prentice Hall, 1992.
23. Michael Stonebraker: Operating System Support for Database Management. Communications of the ACM, v. 24, no. 7, pp. 412-418, July 1981.
24. J.Z. Teng, R.A. Gumaer, Managing IBM Database 2 Buffers to Maximize Performance, IBM Systems Journal, v. 23, n. 2, pp. 211-218, 1984.
25. Transaction Processing Performance Council (TPC): TPC BENCHMARK A Standard Specification. The Performance Handbook: for Database and Transaction Processing Systems, Morgan Kaufmann 1991.
26. P.S. Yu, D.W. Cornell, Optimal Buffer Allocation in a Multi-query Environment, Proceedings of the Seventh International Conference on Data Engineering, pp. 622-631, April 1991.