中科微点-全球专利检索

  1. Login
  2. Sign Up

Search Results

1753 records (took 0.03 seconds)

    IDENTIFYING SOFTWARE REGRESSIONS BASED ON QUERY RETRY ATTEMPTS IN A DATABASE ENVIRONMENT
    561.
    发明申请
    IDENTIFYING SOFTWARE REGRESSIONS BASED ON QUERY RETRY ATTEMPTS IN A DATABASE ENVIRONMENT 有权

    公开(公告)号：US20220083534A1

    公开(公告)日：2022-03-17

    申请号：US17536180

    申请日：2021-11-29

    Applicant: Snowflake Inc.

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

    IPC: G06F16/23 ,  G06F16/2455

    Abstract: Systems, methods, and devices for retrying a query. A method includes receiving a query directed to database data and assigning execution of the query to one or more execution nodes of an execution platform, the one or more execution nodes configured to execute the query on a first version of a database platform. The method includes determining that execution of the query was unsuccessful. The method includes assigning a first retry execution of the query to the one or more execution nodes of the execution platform and determining whether a regression or an intermittent fault caused the execution of the query to be unsuccessful based at least in part on whether the first retry execution of the query was successful or unsuccessful.

    Processing of queries over external tables
    562.
    发明授权
    Processing of queries over external tables 有权

    公开(公告)号：US11269869B2

    公开(公告)日：2022-03-08

    申请号：US17498382

    申请日：2021-10-11

    Applicant: Snowflake Inc.

    Inventor： Subramanian Muralidhar ,  Benoit Dageville ,  Thierry Cruanes ,  Nileema Shingte ,  Saurin Shah ,  Torsten Grabs ,  Istvan Cseri

    IPC: G06F16/20 ,  G06F16/242 ,  G06F3/06 ,  G06F16/2453 ,  G06F16/25 ,  G06F16/23

    Abstract: Disclosed herein are systems and methods for processing queries over external tables. In an embodiment, a database platform receives a query directed at least to data in an external table stored in a storage platform that is external to the database platform. The database platform uses metadata that summarizes the data in the external table to identify one or more partitions of the external table as potentially including data satisfying the query, and generates a query plan that includes a plurality of discrete subtasks that collectively include instructions to scan the identified one or more partitions of the external table for data satisfying the query. The database platform assigns, based on the metadata, the plurality of discrete subtasks to one or more nodes in an execution platform, and refreshes the metadata in response to a threshold number of modifications being made to the external table.

    Task scheduling and querying in database systems
    563.
    发明授权
    Task scheduling and querying in database systems 有权

    公开(公告)号：US11269866B2

    公开(公告)日：2022-03-08

    申请号：US17461208

    申请日：2021-08-30

    Applicant: Snowflake Inc.

    Inventor： Istvan Cseri ,  Torsten Grabs ,  Benoit Dageville

    IPC: G06F16/00 ,  G06F16/23 ,  G06F9/46

    Abstract: Systems, methods, and devices for executing a task on database data in response to a trigger event are disclosed. A method includes executing a transaction on a table comprising database data, wherein executing the transaction comprises generating a new table version. The method includes, in response to the transaction being fully executed, generating a change tracking entry comprising an indication of one or more modifications made to the table by the transaction and storing the change tracking entry in a change tracking stream. The method includes executing a task on the new table version in response to a trigger event.

    INCREMENTAL RECLUSTERING OF DATABASE TABLES USING RECLUSTERING-COUNT LEVELS
    564.
    发明申请
    INCREMENTAL RECLUSTERING OF DATABASE TABLES USING RECLUSTERING-COUNT LEVELS 有权

    公开(公告)号：US20220067016A1

    公开(公告)日：2022-03-03

    申请号：US17511064

    申请日：2021-10-26

    Applicant: Snowflake Inc.

    Inventor： Jiaqi Yan ,  Thierry Cruanes ,  Jeffrey Rosen ,  William Waddington ,  Prasanna Rajaperumal ,  Abdul Munir

    IPC: G06F16/22 ,  G06F16/27 ,  G06F7/08 ,  G06F16/28

    Abstract: The subject technology determines whether a table is sufficiently clustered. The subject technology in response to determining the table is not sufficiently clustered, selects one or more micro-partitions of the table to be reclustered. The subject technology constructs a data structure for the table. The subject technology extracts minimum and maximum endpoints for each micro-partition in the data structure. The subject technology sorts each of one or more peaks in the data structure based on height. The subject technology sorts overlapping micro-partitions based on width. The subject technology selects based on which micro-partitions are within the tallest peaks of the one or more peaks and further based on which of the overlapping micro-partitions have the widest widths.

Patent Agency Ranking