中科微点-全球专利检索

  1. Login
  2. Sign Up

Search Results

147 records (took 0.024 seconds)

    Pipeline level optimization of aggregation operators in a query plan during runtime
    12.
    发明授权
    Pipeline level optimization of aggregation operators in a query plan during runtime 有权

    公开(公告)号：US11144550B2

    公开(公告)日：2021-10-12

    申请号：US16857817

    申请日：2020-04-24

    Applicant: Snowflake Inc.

    Inventor： Bowei Chen ,  Thierry Cruanes ,  Florian Andreas Funke ,  Allison Waingold Lee ,  Jiaqi Yan

    IPC: G06F16/2453 ,  G06F16/2455 ,  G06F16/22

    Abstract: The subject technology receives a query plan, the query plan comprising a set of query operations, the set of query operations including at least one aggregation and a join operation, the join operation including a build side and a probe side. The subject technology inserts an aggregation operator below the probe side of the join operation. The subject technology causes the build side of the join operation to generate a hash table. The subject technology causes the build side of the join operation to generate a bloom filter based at least in part on the hash table and provide information, corresponding to properties of the build side, to a bloom filter. Based at least in part on the information, the subject technology determines at least one property of the join operation to determine whether to switch the aggregation operator to a pass through mode.

    Secure data sharing in a multi-tenant database system
    13.
    发明授权
    Secure data sharing in a multi-tenant database system 有权

    公开(公告)号：US11036881B2

    公开(公告)日：2021-06-15

    申请号：US16241463

    申请日：2019-01-07

    Applicant: Snowflake Inc.

    Inventor： Allison Waingold Lee ,  Peter Povinec ,  Martin Hentschel ,  Robert Muglia

    IPC: G06F21/62 ,  G06F21/78 ,  G06F16/245 ,  G06F16/22 ,  G06F21/60

    Abstract: Systems, methods, and devices for implementing secure views for zero-copy data sharing in a multi-tenant database system are disclosed. A method includes generating a share object in a first account comprising a share role. The method includes associating view privileges for the share object such that an underlying detail of the share object comprises a secure user-defined function definition. The method includes granting, to a second account, cross-account access rights to the share role or share object in the first account. The method includes receiving a request from the second account to access data or services of the first account and providing a response to the second account based on the data or services of the first account. The method is such that the underlying detail of the share object that comprises the secure user-defined function definition is hidden from the second account and visible to the first account.

    PLACEMENT OF ADAPTIVE AGGREGATION OPERATORS AND PROPERTIES IN A QUERY PLAN
    14.
    发明申请
    PLACEMENT OF ADAPTIVE AGGREGATION OPERATORS AND PROPERTIES IN A QUERY PLAN 有权

    公开(公告)号：US20210173839A1

    公开(公告)日：2021-06-10

    申请号：US17180323

    申请日：2021-02-19

    Applicant: Snowflake Inc.

    Inventor： Bowei Chen ,  Thierry Cruanes ,  Florian Andreas Funke ,  Allison Waingold Lee ,  Jiaqi Yan

    IPC: G06F16/2453

    Abstract: The subject technology receives a query plan, the query plan comprising a set of query operations, the set of query operations including at least one aggregation and at least one join operation. The subject technology analyzes the query plan to identify an aggregation that is redundant. The subject technology removes the aggregation based at least in part on the analyzing. The subject technology determines at least one aggregation property corresponding to at least one query operation of the query plan. The subject technology inserts at least one adaptive aggregation operator in the query plan based at least in part on the at least one aggregation property, the at least one aggregation property comprising a set of aggregation properties. The subject technology provides a modified query plan based at least in part on the inserted at least one adaptive aggregation operator in the query plan.

    PIPELINE LEVEL OPTIMIZATION OF AGGREGATION OPERATORS IN A QUERY PLAN DURING RUNTIME
    15.
    发明申请
    PIPELINE LEVEL OPTIMIZATION OF AGGREGATION OPERATORS IN A QUERY PLAN DURING RUNTIME 有权

    公开(公告)号：US20210089535A1

    公开(公告)日：2021-03-25

    申请号：US16857817

    申请日：2020-04-24

    Applicant: Snowflake Inc.

    Inventor： Bowei Chen ,  Thierry Cruanes ,  Florian Andreas Funke ,  Allison Waingold Lee ,  Jiaqi Yan

    IPC: G06F16/2453 ,  G06F16/2455 ,  G06F16/22

    Abstract: The subject technology receives a query plan, the query plan comprising a set of query operations, the set of query operations including at least one aggregation and a join operation, the join operation including a build side and a probe side. The subject technology inserts an aggregation operator below the probe side of the join operation. The subject technology causes the build side of the join operation to generate a hash table. The subject technology causes the build side of the join operation to generate a bloom filter based at least in part on the hash table and provide information, corresponding to properties of the build side, to a bloom filter. Based at least in part on the information, the subject technology determines at least one property of the join operation to determine whether to switch the aggregation operator to a pass through mode.

    SECURE DATA SHARING IN A MULTI-TENANT DATABASE SYSTEM
    19.
    发明申请
    SECURE DATA SHARING IN A MULTI-TENANT DATABASE SYSTEM 审中-公开

    公开(公告)号：US20200226281A1

    公开(公告)日：2020-07-16

    申请号：US16836521

    申请日：2020-03-31

    Applicant: Snowflake Inc.

    Inventor： Martin Hentschel ,  Allison Waingold Lee ,  Robert Muglia ,  Peter Povinec

    IPC: G06F21/62 ,  G06F16/245 ,  G06F16/22

    Abstract: Systems, methods, and devices for implementing secure views for zero-copy data sharing in a multi-tenant database system are disclosed. A method includes generating a share object in a first account comprising a share role. The method includes associating view privileges for the share object such that an underlying detail of the share object comprises a secure view definition. The method includes granting, to a second account, cross-account access rights to the share role or share object in the first account. The method includes receiving a request from the second account to access data or services of the first account and providing a response to the second account based on the data or services of the first account. The method is such that the underlying detail of the share object that comprises the secure view definition is hidden from the second account and visible to the first account.

Patent Agency Ranking