Performance of a database manager in a virtual memory system
ACM Transactions on Database Systems (TODS)
An experimental study of computer system performance
ACM '72 Proceedings of the ACM annual conference - Volume 2
Logical, internal, and physical reference behavior in CODASYL database systems
ACM Transactions on Database Systems (TODS)
Principles of database buffer management
ACM Transactions on Database Systems (TODS)
A look-ahead data staging architecture for relational data base machines
ISCA '81 Proceedings of the 8th annual symposium on Computer Architecture
The transaction resolution journal: extending the before journal
ACM SIGOPS Operating Systems Review
Fixing pages in a database buffer
ACM SIGMOD Record
Design and performance tools for data base systems
VLDB '77 Proceedings of the third international conference on Very large data bases - Volume 3
Incremental file reorganization schemes
VLDB '85 Proceedings of the 11th international conference on Very Large Data Bases - Volume 11
Data base system performance prediction using an analytical model (invited paper)
VLDB '81 Proceedings of the seventh international conference on Very Large Data Bases - Volume 7
AFIPS '82 Proceedings of the June 7-10, 1982, national computer conference
Effect of replacement algorithms on a paged buffer database system
IBM Journal of Research and Development
| Hi-index | 0.00 |
Buffer pools are created and managed in database systems in order to reduce the total number of accesses to the I/O devices. In systems using virtual memory, any reduction in I/O accesses may be accompanied by an increase in paging. The effects of these factors on system performance are quantified, where system performance is a function of page faults and database accesses to the I/O devices. A previous study of this phenomenon is extended through the analysis of empirical data gathered in a multifactor experiment. In this study memory is partitioned between the program and the buffer so that the impact of the controlled factors can be more effectively evaluated. It is possible to improve system performance through the use of different paging algorithms in the program partition and the buffer partition. Also, the effects on system performance as the virtual buffer size is increased beyond the real memory allocated to the buffer partition are investigated.