Data sharing and materialized views in multiple tenant database systems
AssigneeSnowflake Inc.
InventorsPrasanna Rajaperumal, Thierry Cruanes, Allison Waingold Lee, Igor Demura, Jiaqi Yan, Benoit Dageville
Life of this patent
Estimating the term…
Loading patent…
AssigneeSnowflake Inc.
InventorsPrasanna Rajaperumal, Thierry Cruanes, Allison Waingold Lee, Igor Demura, Jiaqi Yan, Benoit Dageville
Estimating the term…
Systems, methods, and devices for generating and updating cross-account materialized views in multiple tenant database systems. A method includes defining a share object in a first account wherein the share object includes data associated with the first account. The method includes granting cross-account access rights to the share object to a second account such that the second account has access to the share object without copying the share object. The method includes generating a materialized view over the share object. The method includes updating the data associated with the first account. The method includes identifying whether the materialized view is stale with respect to the share object by merging the materialized view and the share object.
A system comprising:
A method comprising:
A processor that is configurable to execute instructions stored in non-transitory computer readable storage medium, the instructions comprising:
Dependencies are inferred from the claim text.