中科微点-全球专利检索

  1. Login
  2. Sign Up

Search Results

41 records (took 0.02 seconds)

    Automated query retry execution using multiple computing nodes in a database system
    1.
    发明授权
    Automated query retry execution using multiple computing nodes in a database system 有权

    公开(公告)号：US12164405B2

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

    申请号：US18160720

    申请日：2023-01-27

    Applicant: Snowflake Inc.

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

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

    Abstract: Techniques for automated query retry in a database platform include decoding, by at least one hardware processor, a query directed to database data. The query is received by a first management node from a client account of a database system. The method further includes configuring an execution of the query by a first computing node associated with the first management node. The method includes detecting the execution of the query results in a failed execution. The query is transferred from the first management node to a second management node based on the failed execution. The second management node is configured to process tasks that are internal to the database system. A retry execution of the query by a second computing node is configured. The second computing node is associated with the second management node. A cause of the failed execution is determined based on a result of the retry execution.

    Decoupling internal and external tasks in a database environment
    2.
    发明授权
    Decoupling internal and external tasks in a database environment 有权

    公开(公告)号：US11409626B2

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

    申请号：US16555996

    申请日：2019-08-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: Systems, methods, and devices for retrying a query. A method includes receiving, by a first database query manager, a query directed to database data from a client account. The method includes assigning an original execution of the query to one or more execution nodes of an execution platform. The method includes determining the original execution of the query was unsuccessful. The method includes transferring the query to a second database query manager configured to manage internal tasks for improving operation of a database platform that are not received from client accounts. The method includes assigning, by the second database query manager, a retry execution of the query to one or more execution nodes of an execution platform.

    DECOUPLING INTERNAL AND EXTERNAL TASKS IN A DATABASE ENVIRONMENT
    3.
    发明申请
    DECOUPLING INTERNAL AND EXTERNAL TASKS IN A DATABASE ENVIRONMENT 有权

    公开(公告)号：US20210064502A1

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

    申请号：US16555996

    申请日：2019-08-29

    Applicant: Snowflake Inc.

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

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

    Abstract: Systems, methods, and devices for retrying a query. A method includes receiving, by a first database query manager, a query directed to database data from a client account. The method includes assigning an original execution of the query to one or more execution nodes of an execution platform. The method includes determining the original execution of the query was unsuccessful. The method includes transferring the query to a second database query manager configured to manage internal tasks for improving operation of a database platform that are not received from client accounts. The method includes assigning, by the second database query manager, a retry execution of the query to one or more execution nodes of an execution platform.

    Projection constraints in a query processing system
    5.
    发明授权
    Projection constraints in a query processing system 有权

    公开(公告)号：US11928157B2

    公开(公告)日：2024-03-12

    申请号：US17934814

    申请日：2022-09-23

    Applicant: Snowflake Inc.

    Inventor： Khalid Zaman Bijon ,  Thierry Cruanes ,  Simon Holm Jensen ,  Allison Waingold Lee ,  Daniel N. Meredith ,  Subramanian Muralidhar ,  David Schultz ,  Zixi Zhang

    IPC: G06F16/903

    CPC classification number: G06F16/90335

    Abstract: A constraint system enforces projection constraints on data values stored in specified columns of a shared dataset when queries are received by a database system. A projection constraint identifies that the data in a column may be restricted from being projected (e.g., presented, read, outputted) in an output to a received query, while allowing specified operations to be performed on the data and a corresponding output to be provided. For example, the projection constraint may indicate a context for a query that triggers the constraint, such as based on the user that submitted the query. Enforcing projection constraints on queries received at the database system allows for data to be shared and used anonymously by entities to perform various operations without the need to tokenize the data.

    Automated query retry execution in a database system
    6.
    发明授权
    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.

    Performing geospatial-function join using single interval join
    7.
    发明授权
    Performing geospatial-function join using single interval join 有权

    公开(公告)号：US11036739B1

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

    申请号：US16944049

    申请日：2020-07-30

    Applicant: Snowflake Inc.

    Inventor： Matthias Carl Adams ,  Simon Holm Jensen ,  Spyridon Triantafyllis

    IPC: G06F16/00 ,  G06F7/00 ,  G06F16/2453

    Abstract: A database platform receives query instructions for a query on a database, where the query instructions include a geospatial-function join that includes a geospatial-function predicate. The database platform generates a query-execution plan by replacing the geospatial-function join with a single interval join that has an interval-join predicate that is implied by the geospatial-function predicate, and by also inserting a filter above the single interval join to apply the geospatial-function predicate. The database platform executes the query-execution plan, and returns query results in response to the query.

Patent Agency Ranking