中科微点-全球专利检索

  1. Login
  2. Sign Up

Search Results

610 records (took 0.038 seconds)

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

    公开(公告)号：US20230418818A1

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

    申请号：US18463904

    申请日：2023-09-08

    Applicant: Snowflake Inc.

    Inventor： Prasanna Rajaperumal ,  Thierry Cruanes ,  Allison Waingold Lee ,  Igor Demura ,  Jiaqi Yan ,  Benoit Dageville

    IPC: G06F16/2453

    CPC classification number: G06F16/24539

    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.

    Fine-grained access control via database roles
    24.
    发明授权
    Fine-grained access control via database roles 有权

    公开(公告)号：US11822689B2

    公开(公告)日：2023-11-21

    申请号：US18109191

    申请日：2023-02-13

    Applicant: Snowflake Inc.

    Inventor： Damien Carru ,  Pui Kei Johnston Chu ,  Benoit Dageville ,  Shreyas Narendra Desai ,  Subramanian Muralidhar ,  Bowen Zhang

    IPC: G06F21/62 ,  G06F16/25 ,  G06F16/21

    CPC classification number: G06F21/6218 ,  G06F16/21 ,  G06F16/256 ,  G06F2221/2141

    Abstract: Embodiments of the present disclosure relate to sharing database roles using hidden roles. A database role may be generated within a database container having a plurality of data objects, wherein the database role exists exclusively within the database container. A set of grants to a particular subset of the plurality of data objects of the database container may be assigned to the database role and the database role may be granted to the share object. The share object is mounted within a consumer account to generate an imported database container within the consumer account, the imported database container including an imported copy of the database role. The imported copy of the database role may be granted to each of one or more account level roles of the consumer account to share the particular subset of the plurality of data objects without creating proxy objects in the consumer account that represent the particular subset of the plurality of data objects.

    Shared object discovery techniques
    25.
    发明授权
    Shared object discovery techniques 有权

    公开(公告)号：US11809586B2

    公开(公告)日：2023-11-07

    申请号：US17980427

    申请日：2022-11-03

    Applicant: Snowflake Inc.

    Inventor： Damien Carru ,  Jeremy Yujui Chen ,  Pui Kei Johnston Chu ,  Benoit Dageville ,  Subramanian Muralidhar

    IPC: G06F7/00 ,  G06F16/00 ,  G06F21/62 ,  G06F16/21 ,  G06F16/2455

    CPC classification number: G06F21/6218 ,  G06F16/213 ,  G06F16/24552

    Abstract: A consumer account may invoke an operation referencing a set of shared objects stored within a database of a provider account using an imported database that makes the set of shared objects available within the consumer account. A call context of the operation may be updated to cache the imported database, which references a share created from the provider account database, the share having grants to the set of shared objects. One or more database level objects may be discovered in a context of the share and each role granted to the share may be obtained based on the one or more database level objects. Whether any role granted to the share has access to any of the set of shared objects may be determined and the operation may be executed for each of the set of shared objects to which any role granted to the share has access.

    SHARED OBJECT DISCOVERY TECHNIQUES
    29.
    发明申请
    SHARED OBJECT DISCOVERY TECHNIQUES 有权

    公开(公告)号：US20230135712A1

    公开(公告)日：2023-05-04

    申请号：US17980427

    申请日：2022-11-03

    Applicant: Snowflake Inc.

    Inventor： Damien Carru ,  Jeremy Yujui Chen ,  Pui Kei Johnston Chu ,  Benoit Dageville ,  Subramanian Muralidhar

    IPC: G06F21/62 ,  G06F16/2455 ,  G06F16/21

    Abstract: A consumer account may invoke an operation referencing a set of shared objects stored within a database of a provider account using an imported database that makes the set of shared objects available within the consumer account. A call context of the operation may be updated to cache the imported database, which references a share created from the provider account database, the share having grants to the set of shared objects. One or more database level objects may be discovered in a context of the share and each role granted to the share may be obtained based on the one or more database level objects. Whether any role granted to the share has access to any of the set of shared objects may be determined and the operation may be executed for each of the set of shared objects to which any role granted to the share has access.

    Automated query retry execution in a database system
    30.
    发明授权
    Automated query retry execution in a database system 有权

    公开(公告)号：US11640347B2

    公开(公告)日：2023-05-02

    申请号：US17809780

    申请日：2022-06-29

    Applicant: Snowflake Inc.

    Inventor： Benoit Dageville ,  Johan Harjono ,  Simon Holm Jensen ,  Kunal Prafulla Nabar ,  Steven James Pelley

    IPC: G06F11/30 ,  G06F16/2458 ,  G06F11/34 ,  G06F16/242

    Abstract: Techniques for automated query retry in a database platform include decoding, by at least one hardware processor, a query directed to database data from a client account of a database platform. The method further includes decoding, by the at least one hardware processor, an indication that execution of the query on at least one computing node of the database platform results in a failed execution. The method further includes configuring a processing loop with continuous retry executions of the query on the at least one computing node based on the indication. The method further includes exiting the processing loop based on detecting a retry execution of the continuous retry executions results in at least one successful execution of the query. The method includes logging each attempt to execute the query during the continuous retry executions in a query status log until the at least one successful execution of the query.

Patent Agency Ranking