Patent ID: 11868347
Assignee: AMAZON TECHNOLOGIES, INC.
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 13:
14. One or more non-transitory, computer-readable storage media, storing program instructions that when executed on or across one or more computing devices cause the one or more computing devices to implement a query engine for a database that implements:
receiving a query that references a materialized view created from one or tables of the database;
determining that the materialized view of the database cannot be used to perform the query;
rewriting the query to generate a query plan that obtains one or more changes made to the one or more tables from the one or more tables used in the creation of the materialized view using one or more transaction identifiers generated at runtime as parameter values for one or more stored procedures that are created as part of creating the materialized view, and incorporates the one or more changes directly into generating a result for the query from the materialized view; and
returning a result for the rewritten query.