US 11,841,848 B2
Stored procedures for incremental updates to internal tables for materialized views
Yannis Papakonstantinou, La Jolla, CA (US); Vuk Ercegovac, Campbell, CA (US); Andre Hernich, Berlin (DE); Enrico Siragusa, Berlin (DE); and Gaurav Saxena, Cupertino, CA (US)
Assigned to Amazon Technologies, Inc., Seattle, WA (US)
Filed by Amazon Technologies, Inc., Seattle, WA (US)
Filed on Jun. 6, 2022, as Appl. No. 17/805,676.
Application 17/805,676 is a continuation of application No. 16/698,827, filed on Nov. 27, 2019, granted, now 11,354,304.
Prior Publication US 2022/0300492 A1, Sep. 22, 2022
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/23 (2019.01); G06F 16/22 (2019.01); G06F 16/242 (2019.01)
CPC G06F 16/2393 (2019.01) [G06F 16/2282 (2019.01); G06F 16/2445 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A system, comprising:
one or more processors; and
a memory, that stores program instructions that, when executed by the at least one processor, cause the one or more processors to implement a database service, configured to:
receive a query that is directed to a materialized view created for a database;
rewrite the query to use a number of internal tables determined and created for the materialized view according to a materialized view definition from one or more tables of the database; and
perform the rewritten query using the number of internal tables to return a result for the query, wherein the number of internal tables are updated to provide an updated version of the materialized view for performing the rewritten query according to one or more stored procedures determined and created for updating the materialized view.