US 10,891,288 B2
Data sharing and materialized views in multiple tenant database systems
Prasanna Rajaperumal, San Mateo, CA (US); Thierry Cruanes, San Mateo, CA (US); Allison Waingold Lee, San Mateo, CA (US); Igor Demura, San Mateo, CA (US); Jiaqi Yan, San Mateo, CA (US); and Benoit Dageville, San Mateo, CA (US)
Assigned to Snowflake Inc., San Mateo, CA (US)
Filed by Snowflake Inc., San Mateo, CA (US)
Filed on Apr. 1, 2020, as Appl. No. 16/837,555.
Application 16/837,555 is a continuation of application No. 16/705,664, filed on Dec. 6, 2019, granted, now 10,628,415.
Application 16/705,664 is a continuation of application No. 16/428,367, filed on May 31, 2019.
Prior Publication US 2020/0379996 A1, Dec. 3, 2020
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/2453 (2019.01); G06F 16/27 (2019.01); G06F 16/23 (2019.01); G06F 16/22 (2019.01); G06F 16/2455 (2019.01)
CPC G06F 16/24539 (2019.01) [G06F 16/2282 (2019.01); G06F 16/2393 (2019.01); G06F 16/24552 (2019.01); G06F 16/278 (2019.01)] 30 Claims
OG exemplary drawing
1. A method comprising:
generating a materialized view over a share object, the share object including data associated with a first account;
updating the data associated with the first account subsequent to generating the materialized view;
merging the materialized view and the share object;
determining that the materialized view is stale with respect to the share object based at least in part on the merging;
generating a refreshed materialized view with respect to the share object in response to the determining; and
sharing the refreshed materialized view to a second account in response to a request from the second account.