Selectively reading data from cache and primary storage based on whether cache is overloaded
US10430338B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Jan 21, 2010 |
| Grant date | Oct 1, 2019 |
| Priority date | — |
| Expiry date | Mar 1, 2034 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F12/0866
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Techniques are provided for using an intermediate cache to provide some of the items involved in a scan operation, while other items involved in the scan operation are provided from primary storage. Techniques are also provided for determining whether to service an I/O request for an item with a copy of the item that resides in the intermediate cache based on factors such as a) an identity of the user for whom the I/O request was submitted, b) an identity of a service that submitted the I/O request, c) an indication of a consumer group to which the I/O request maps, d) whether the I/O request is associated with an offloaded filter provided by the database server to the storage system, or e) whether the intermediate cache is overloaded. Techniques are also provided for determining whether to store items in an intermediate cache in response to the items being retrieved, based on logical characteristics associated with the requests that retrieve the items.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.