US 11,841,841 B2
Stand in tables
Lloyd Tabb, Santa Cruz, CA (US); Michael Toy, Los Altos, CA (US); and Conrad Slimmer, Santa Cruz, CA (US)
Assigned to Google LLC, Mountain View, CA (US)
Filed by Google LLC, Mountain View, CA (US)
Filed on Dec. 6, 2022, as Appl. No. 18/062,303.
Application 18/062,303 is a continuation of application No. 17/143,104, filed on Jan. 6, 2021, granted, now 11,531,664.
Prior Publication US 2023/0098361 A1, Mar. 30, 2023
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/22 (2019.01); G06F 16/2455 (2019.01); G06F 16/248 (2019.01)
CPC G06F 16/2255 (2019.01) [G06F 16/2282 (2019.01); G06F 16/248 (2019.01); G06F 16/2455 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A computer-implemented method executed by data processing hardware that causes the data processing hardware to perform operations comprising:
obtaining a query querying a database, the query referencing a materialized table generated from the database, the referenced materialized table stored on memory hardware in communication with the data processing hardware and comprising a cached copy of data from the database;
determining a hash value of the referenced materialized table, the hash value representing a hash of at least a portion of the referenced materialized table;
determining that the hash value of the referenced materialized table is identical to one of a plurality of pre-stored hash values, each pre-stored hash value of the plurality of pre-stored hash values representing a hash of an associated different materialized table; and
based on determining that the hash value of the referenced materialized table is identical to one of the plurality of pre-stored hash values, determining, using the referenced materialized table, a query result for the query.