About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
Publication
Information Systems
Paper
Prefetching-a performance analysis
Abstract
Reduction of page faults and thus, response times, is one of the keys to overall improvement of database access behavior. Assuming a transaction load of predominantly schematic or canned transactions, exploitation of preknowledge of transaction access patterns leads to the concept of prefetching, i.e. loading data pages into the system buffer in advance and before a time-critical access request is issued. Thus, the time behavior of a main memory database can be achieved. The justification of prefetching is only given by satisfying the time restriction in real-time application. This paper presents the concept and an experimental validation clearly identifying potential gains. © 1990.