The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Sep. 07, 2021
Filed:
May. 31, 2019
Snowflake Inc., Bozeman, MT (US);
Prasanna Rajaperumal, Fremont, CA (US);
Thierry Cruanes, San Mateo, CA (US);
Allison Waingold Lee, San Carlos, CA (US);
Igor Demura, Cupertino, CA (US);
Jiaqi Yan, San Carlos, CA (US);
Benoit Dageville, Foster City, CA (US);
Snowflake Inc., Bozeman, MT (US);
Abstract
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.