US 12,147,426 B2
Computerized systems and methods for materialized view matching
Carl-Christian Kanne, Campbell, CA (US); Brian Guarraci, Highlands Ranch, CO (US); Chris Brand, Livermore, CA (US); Eric Ranstrom, Moraga, CA (US); and Kevin Beyer, San Francisco, CA (US)
Assigned to WORKDAY, INC., Pleasanton, CA (US)
Filed by WORKDAY, INC., Pleasanton, CA (US)
Filed on Mar. 14, 2022, as Appl. No. 17/693,917.
Prior Publication US 2023/0289341 A1, Sep. 14, 2023
Int. Cl. G06F 16/00 (2019.01); G06F 16/215 (2019.01); G06F 16/2453 (2019.01); G06F 16/2455 (2019.01)
CPC G06F 16/24539 (2019.01) [G06F 16/215 (2019.01); G06F 16/2456 (2019.01)] 17 Claims
OG exemplary drawing
 
1. A method comprising:
receiving, by a device, a query, the query comprising a request for information stored in a database, the received query initially configured to read base tables of the database;
identifying, by the device, based at least on the request, a set of coverage filters that each corresponds to at least one column field of the database;
accessing, by the device, a plurality of materialized views based on the identified set of coverage filters, each of the plurality of materialized views being previously generated in response to a past query performed in relation to the database, each materialized view having an associated coverage filter;
determining, by the device, a set of materialized views from the plurality of materialized views based on the coverage filters of each materialized view and the request;
aggregating, by the device, via execution of a view matching and view combination algorithm, the determined set of materialized views;
modifying, by the device, the received query, the modification causing the query to function to read the determined set of materialized views instead of the initially configured base tables;
executing, by the device, the modified query against the database based on the aggregated set of materialized views; and
providing, by the device, a result based on execution of the query.