The Effect of Buffer Size on Pages Accessed in Random Files
- UNCG Author/Contributor (non-UNCG co-authors, if there are any, appear on document)
- Prashant Palvia, Joe Rosenthal Excellence Professor and Director of the McDowell Research Center for Global IT Management (Creator)
- Institution
- The University of North Carolina at Greensboro (UNCG )
- Web Site: http://library.uncg.edu/
Abstract: Prior works, for estimating the number of pages (blocks) accessed from secondary memory to retrieve a certain number of records for a query, have ignored the effect of main memory buffer size. While this may not cause any adverse impact for special cases, in most cases the impact of buffer sizes will be to increase the number of page accesses. This paper describes the reasons for the impact due to a limited buffer size and develops new expressions for the number of pages accessed. The accuracy of the expressions is evaluated by simulation modeling; and the effects of limited buffer size are discussed. Analytical works in database analysis and design should use the new expressions: especially when the effect of the buffer size is significant.
The Effect of Buffer Size on Pages Accessed in Random Files
PDF (Portable Document Format)
283 KB
Created on 1/27/2011
Views: 2241
Additional Information
- Publication
- Information Systems, Vol. 13, No. 2,1988, pp.187-191
- Language: English
- Date: 1988
- Keywords
- Pages accessed, Buffer size