利索-全球专利检索

  1. 登录
  2. 注册

搜索结果

423 条记录 (耗时 0.033 秒)

    Granting access to resources of a database
    1.
    发明授权
    Granting access to resources of a database 有权

    公开(公告)号：US12013960B2

    公开(公告)日：2024-06-18

    申请号：US18343361

    申请日：2023-06-28

    申请人： SNOWFLAKE INC.

    发明人： Benoit Dageville ,  Thierry Cruanes ,  Martin Hentschel ,  Peter Povinec

    IPC分类号： G06F21/62 ,  G06F16/25

    CPC分类号： G06F21/6218 ,  G06F16/256 ,  G06F2221/2145

    摘要： A method of sharing data in a multi-tenant database includes inspecting, by a processing device of a multiple tenant database, a sharer account to determine an existence of a link between an alias object in a target account and a database, wherein the database is linked to a first role object included in a share object in the sharer account. The method includes granting a second role object, in the target account, access rights to the alias object, wherein the first role object having one or more grants to one or more resources of the sharer account, and wherein the target account accesses the one or more resources using the one or more grants of the share object and using the alias object without at least one of copying the one or more resources or transmitting the one or more resources.

    Projection constraints in a query processing system
    6.
    发明授权
    Projection constraints in a query processing system 有权

    公开(公告)号：US11928157B2

    公开(公告)日：2024-03-12

    申请号：US17934814

    申请日：2022-09-23

    申请人： Snowflake Inc.

    发明人： Khalid Zaman Bijon ,  Thierry Cruanes ,  Simon Holm Jensen ,  Allison Waingold Lee ,  Daniel N. Meredith ,  Subramanian Muralidhar ,  David Schultz ,  Zixi Zhang

    IPC分类号： G06F16/903

    CPC分类号： G06F16/90335

    摘要： A constraint system enforces projection constraints on data values stored in specified columns of a shared dataset when queries are received by a database system. A projection constraint identifies that the data in a column may be restricted from being projected (e.g., presented, read, outputted) in an output to a received query, while allowing specified operations to be performed on the data and a corresponding output to be provided. For example, the projection constraint may indicate a context for a query that triggers the constraint, such as based on the user that submitted the query. Enforcing projection constraints on queries received at the database system allows for data to be shared and used anonymously by entities to perform various operations without the need to tokenize the data.

    USER DEFINED FUNCTION MEMOIZATION
    7.
    发明公开
    USER DEFINED FUNCTION MEMOIZATION 审中-公开

    公开(公告)号：US20240028591A1

    公开(公告)日：2024-01-25

    申请号：US18477694

    申请日：2023-09-29

    申请人： Snowflake Inc

    发明人： Raja Suresh Krishna Balakrishnan ,  Thierry Cruanes ,  Yujie Li ,  Subramanian Muralidhar ,  David Schultz ,  Jiaqi Yan

    IPC分类号： G06F16/2453 ,  G06F21/53

    CPC分类号： G06F16/24539 ,  G06F21/53 ,  G06F2221/034

    摘要： A data platform that implements memoizable functions for database objects. The data platform detects a first execution of a memoizable function and generates a first key based on metadata of one or more database objects operated on by the memoizable function and generates a first result for the memoizable function based on the one or more database objects. The data platform detects a second execution of the memoizable function and generates a second key based on the metadata of the one or more database objects operated on by the memoizable function. When the first key and the second key are equal, the data platform reuses the first result of the memoizable function. When the first key and second key do not match, the data platform generates a second result for the second execution of the memoizable function.

    SHARING MATERIALIZED VIEWS IN MULTIPLE TENANT DATABASE SYSTEMS
    8.
    发明公开
    SHARING MATERIALIZED VIEWS IN MULTIPLE TENANT DATABASE SYSTEMS 审中-公开

    公开(公告)号：US20230418818A1

    公开(公告)日：2023-12-28

    申请号：US18463904

    申请日：2023-09-08

    申请人： Snowflake Inc.

    发明人： Prasanna Rajaperumal ,  Thierry Cruanes ,  Allison Waingold Lee ,  Igor Demura ,  Jiaqi Yan ,  Benoit Dageville

    IPC分类号： G06F16/2453

    CPC分类号： G06F16/24539

    摘要： 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.

    Data clean rooms using defined access
    9.
    发明授权
    Data clean rooms using defined access 有权

    公开(公告)号：US11803432B1

    公开(公告)日：2023-10-31

    申请号：US18051457

    申请日：2022-10-31

    申请人： Snowflake Inc.

    发明人： Artin Avanes ,  Thierry Cruanes ,  Monica J. Holboke ,  Allison Waingold Lee ,  Subramanian Muralidhar ,  David Schultz

    IPC分类号： G06F9/54 ,  G06F16/2455 ,  G06F21/62

    CPC分类号： G06F9/547 ,  G06F9/541 ,  G06F16/2456 ,  G06F21/6254

    摘要： In an embodiment, a data platform creates an application in a data-provider account. The application includes one or more APIs corresponding to one or more underlying code blocks. The data platform shares provider data with the application in the data-provider account, and also installs, in a data-consumer account, an application instance of the application. The application instance includes one or more APIs corresponding to the one or more APIs in the application in the data-provider account. The data platform shares consumer data with the application instance in the data-consumer account, and invokes one or more of the APIs of the application instance to execute respective associated underlying code blocks, which are not visible to the data-consumer account. The data platform also saves output of the one or more respective associated underlying code blocks locally within the data-consumer account.