Back to results
US 2019/0102433 A1Published application
Storing derived summaries on persistent memory of a storage device
AssigneeOracle International Corporation
InventorsKrishnan Meiyyappan, Semen Ustimenko, Adrian Tsz Him Ng, Kothanda Umamageswaran
Life of this patent
Estimating the term…
Abstract
Region summaries of database data are stored in persistent memory of a storage cell. Because the region summaries are stored in persistent memory, when a storage cell is powered off and data in volatile memory is not retained, region summaries are nevertheless preserved in persistent memory. When the storage cell comes online, the region summaries already exist and may be used without the delay attendant to regenerating the region summaries stored in volatile memory.
Claims9
A method, comprising:
- a storage device receiving a first filtered data block request from a database server specifying a range of data blocks to scan according to filtering criteria specified by said first filtered data block request, said range of data blocks corresponding to a plurality of regions described by an access-derived summary that is stored in non-volatile RAM (NVRAM) of said storage device;
- for a subset of regions of said plurality of regions:
- based on said access-derived summary, determining that said subset of regions do not contain any data blocks that have rows that satisfy said filtering criteria;
- in response to determining that said subset of regions contains no data blocks that have rows that satisfy said filtering criteria, pruning said subset of regions from scanning and filtering;
- and
- for a first region of said plurality of regions not in said subset of regions:
- performing a filtered data block scan on said first region;
- based on a result of the said filtered data block scan, updating said access-derived summary.
5 more elements
Dependencies are inferred from the claim text.