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:
Feb. 27, 2024
Filed:
Mar. 26, 2020
Snowflake Inc., Bozeman, MT (US);
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);
Benoit Dageville, San Mateo, CA (US);
Snowflake Inc., Bozeman, MT (US);
Abstract
Systems, methods, and devices for sharing materialized views in multiple tenant database systems. A method includes defining a materialized view over a source table that is associated with a first account of a multiple tenant database. The method includes defining cross-account access rights to the materialized view to a second account such that that second account can read the materialized view without copying the materialized view. The method includes modifying the source table for the materialized view. The method includes identifying whether the materialized view is stale with respect to the source table by merging the materialized view and the source table.