US 12,405,896 B2
Processing instructions to invalidate cached resultant data in a database system
David Charles Boutcher, Newcastle upon Tyne (GB); and Rob Bestgen, Rochester, MN (US)
Assigned to Ocient Holdings LLC, Chicago, IL (US)
Filed by Ocient Holdings LLC, Chicago, IL (US)
Filed on Mar. 28, 2024, as Appl. No. 18/619,912.
Claims priority of provisional application 63/498,881, filed on Apr. 28, 2023.
Prior Publication US 2024/0362167 A1, Oct. 31, 2024
Int. Cl. G06F 16/00 (2019.01); G06F 12/0891 (2016.01)
CPC G06F 12/0891 (2013.01) 20 Claims
OG exemplary drawing
 
1. A method for execution by at least one processor of a database system, comprising:
processing a first instruction to execute a first query by executing the first query via access to a first relational database table in first storage resources to generate first resultant data for the first query;
caching the first resultant data in cache memory resources during a first temporal period for use in subsequent query execution based on determining to cache the first resultant data for the first query;
processing a second instruction to re-execute the first query during the first temporal period by accessing the first resultant data in the cache memory resources;
receiving a cached resultant invalidation instruction indicating the first relational database table;
removing the first resultant data from the cache memory resources during a second temporal period based on processing the cached resultant invalidation instruction; and
processing a third instruction to re-execute the first query after the second temporal period by re-executing the first query via access to the first relational database table in the first storage resources to re-generate corresponding first resultant data for the first query.