Patent · US Active

Data sharing and materialized views in multiple tenant database systems

US10628415B1 · kind B1 · utility

28Cited by

1References

28Claims

0Family size

Assignee

Snowflake Inc. · US

Inventors

Prasanna Rajaperumal · San Mateo, US
Thierry Cruanes · San Mateo, US
Allison Waingold Lee · Palomar Park, US
Igor Demura · San Mateo, US
Jiaqi Yan · Menlo Park, US
Benoit Dageville · Foster City, US

Key dates

Filing date	Dec 6, 2019
Grant date	Apr 21, 2020
Priority date	—
Expiry date	Dec 6, 2039

Classification

Technology area (CPC G)Physics
CPC primaryG06F16/278
WIPO fieldComputer technology
WIPO sectorElectrical engineering

Abstract

Systems, methods, and devices for generating and updating cross-account materialized views in multiple tenant database systems. A methods 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.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.