中科微点-全球专利检索

  1. Login
  2. Sign Up

Search Results

147 records (took 0.045 seconds)

    Transient materialized view rewrite
    23.
    发明授权
    Transient materialized view rewrite 有权

    公开(公告)号：US12026159B2

    公开(公告)日：2024-07-02

    申请号：US18059125

    申请日：2022-11-28

    Applicant: Snowflake Inc.

    Inventor： Shrainik Jain ,  Allison Waingold Lee ,  Boyung Lee ,  Prasanna Rajaperumal ,  Jiaqi Yan ,  Yongsik Yoon

    IPC: G06F16/2453

    CPC classification number: G06F16/24542

    Abstract: Queries executed against a materialized view can execute up to orders of magnitude faster than equivalent queries on a source (or base) table. However, although a query can reference a materialized view directly, a user (e.g., query author) may not know about a relevant materialized view. Moreover, if a source table has multiple materialized views generated, the user may not know which materialized view to reference in the query. Thus, embodiments of the present disclosure provide techniques for automatically rewriting queries directed to a source table to utilize existing materialized views.

    DATA OVERLAP COUNT ADJUSTMENT IN A MULTIPLE TENANT DATABASE SYSTEM
    28.
    发明申请
    DATA OVERLAP COUNT ADJUSTMENT IN A MULTIPLE TENANT DATABASE SYSTEM 有权

    公开(公告)号：US20220327232A1

    公开(公告)日：2022-10-13

    申请号：US17847681

    申请日：2022-06-23

    Applicant: SNOWFLAKE INC.

    Inventor： Justin Langseth ,  Matthew J. Glickman ,  Christian Kleinerman ,  Robert Muglia ,  Daniel Freundel ,  Thierry Cruanes ,  Allison Waingold Lee

    IPC: G06F21/62 ,  G06F16/2455 ,  H04L9/32

    Abstract: Systems, methods, and devices for generating a secure join of database data are disclosed. A method creates a secure view of datapoints of a consumer account and processes, using a secure user defined function (UDF), the datapoints of the consumer account and datapoints of a provider account to generate a secure join key. The datapoints of the consumer account are provided to the secure UDF using the secure view. The method further performs, by a processor, an analysis of the datapoints of the consumer account and the datapoints of the provider account of the secure join key. The analysis returns a count value of overlapping datapoints between the consumer account and the provider account. The method further adjusts the count value of overlapping datapoints based on a number of distinct rows associated with the provider account, and provides the adjusted count value of overlapping datapoints to the consumer account.

    Aggregation operator optimization during query runtime
    29.
    发明授权
    Aggregation operator optimization during query runtime 有权

    公开(公告)号：US11468063B2

    公开(公告)日：2022-10-11

    申请号：US17232821

    申请日：2021-04-16

    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 provides information, corresponding to properties of a build side of a join operation, to a bloom filter. The subject technology, based at least in part on the information from the bloom filter, determines, during executing of a query plan, at least one property of the join operation to determine whether to switch an aggregation operator to a pass through mode, the at least one property comprising at least a reduction rate. The subject technology, switches, in response to the reduction rate being below a threshold value, the aggregation operator to the pass through mode during runtime of the query plan and, while the aggregation operator is in the pass through mode, an input stream of data goes through the aggregation operator without being analyzed and the input stream of data matches an output stream of data flowing out of the aggregation operator.

Patent Agency Ranking