中科微点-全球专利检索

  1. Login
  2. Sign Up

Search Results

147 records (took 0.018 seconds)

    AGGREGATION OPERATOR OPTIMIZATION DURING QUERY RUNTIME
    133.
    发明申请
    AGGREGATION OPERATOR OPTIMIZATION DURING QUERY RUNTIME 有权

    公开(公告)号：US20210232583A1

    公开(公告)日：2021-07-29

    申请号：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.

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

    公开(公告)号：US20210089533A1

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

    申请号：US16857790

    申请日：2020-04-24

    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 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.

Patent Agency Ranking