Adaptive data prefetch
AssigneeSap SE
InventorsGunes ALUC, Mohammed ABOUZOUR, Bojana BISLIMOVSKA
Life of this patent
Estimating the term…
Abstract
A system includes reception of a request to fetch a first dataset, the request including a first identifier associated with the first dataset, determination, in response to the request, of a first signature associated with the first dataset based on the first identifier and on respective identifiers of one or more datasets fetched consecutively with the first dataset, and determination, based on the determined first signature, of whether to update a first link associating a second dataset with the first dataset, the link indicating to prefetch the first dataset in response to a request to fetch the second dataset.
Claims20
A system comprising:
- a storage system storing a plurality of database tables;
- a buffer cache;
- and
- a server to:
- receive a request to fetch a first dataset associated with one or more of the database tables, the request including a first identifier associated with the first dataset;
- determine a first signature associated with the first dataset based on the first identifier and on respective identifiers of one or more datasets fetched contemporaneously with the first dataset;
- and
- based on the determined first signature, determine whether to update a first link associating a second dataset with the first dataset, the link indicating that the first dataset should be prefetched and stored in the buffer cache in response to reception of a request to fetch the second dataset.
A method comprising:
- receiving a request to fetch a first dataset, the request including a first identifier associated with the first dataset;
- in response to the request, determining a first signature associated with the first dataset based on the first identifier and on respective identifiers of one or more datasets fetched consecutively with the first dataset;
- and
- based on the determined first signature, determining whether to update a first link associating a second dataset with the first dataset, the link indicating to prefetch the first dataset in response to reception of a request to fetch the second dataset.
A non-transitory computer-readable medium storing program code executable by a processing unit of a computing system to:
- receive a request to fetch a first dataset, the request including a first identifier associated with the first dataset;
- in response to the request, determine a first signature associated with the first dataset based on the first identifier and on respective identifiers of one or more datasets fetched consecutively with the first dataset;
- and
- based on the determined first signature, determine whether to update a first link associating a second dataset with the first dataset, the link indicating to prefetch the first dataset in response to a request to fetch the second dataset.
Dependencies are inferred from the claim text.