中科微点-全球专利检索

  1. Login
  2. Sign Up

Search Results

610 records (took 0.05 seconds)

    Automated query retry execution using multiple computing nodes in a database system
    224.
    发明授权
    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.

    Task scheduling using a stream of committed transactions
    225.
    发明授权
    Task scheduling using a stream of committed transactions 有权

    公开(公告)号：US12153569B2

    公开(公告)日：2024-11-26

    申请号：US17653491

    申请日：2022-03-04

    Applicant: Snowflake Inc.

    Inventor： Istvan Cseri ,  Torsten Grabs ,  Benoit Dageville

    IPC: G06F16/23 ,  G06F9/46

    Abstract: A method includes generating a task using a plurality of logical statements embedded in a database, the plurality of logical statements corresponding to a data modification. Database data is ingested into a staging table that is configured within the database. The task is executed based on applying the data modification to a first set of partitions storing the database data and generating a second set of partitions. The second set of partitions store modified data corresponding to the database data. A stream of committed transactions is advanced at least in part by adding an entry into the stream. The entry corresponds to committed transactions performed on the first set of partitions during the data modification. A data processing task is scheduled for execution on the modified data based on the advancing of the stream offset.

    ACTIVE INVALIDATION OF METADATA CACHE ENTRIES
    226.
    发明公开
    ACTIVE INVALIDATION OF METADATA CACHE ENTRIES 审中-公开

    公开(公告)号：US20240330296A1

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

    申请号：US18128152

    申请日：2023-03-29

    Applicant: Snowflake Inc.

    Inventor： Benoit Dageville ,  Lyuping Du ,  Martin Hentschel ,  Elkhan Mammedov ,  Lukas Moll ,  Vikram Wakade

    IPC: G06F16/2455 ,  G06F16/23

    CPC classification number: G06F16/24552 ,  G06F16/2358 ,  G06F16/2365

    Abstract: Techniques for active invalidation of cache entries are described. A first timestamp and a second timestamp are stored by a compute instance, the first timestamp corresponding to an initial time the computing instance read from a version update log in a database and the second timestamp corresponding to a last time the computing instance read from the version update log in the database. The compute instance can read records from the version update log that are associated with version timestamps greater than the second timestamp. The compute instance can invalidate a first set of cache entries with older versions stored in a cache based on reading the records, retaining a second set of cache entries, and then execute a query using the second set of cache entries.

    Data replication and data failover in database systems
    227.
    发明授权
    Data replication and data failover in database systems 有权

    公开(公告)号：US12105734B2

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

    申请号：US16700958

    申请日：2019-12-02

    Applicant: Snowflake Inc.

    Inventor： Benoit Dageville ,  Eric Robinson ,  Martin Hentschel

    IPC: G06F16/245 ,  G06F16/27 ,  H04L67/1097

    CPC classification number: G06F16/273 ,  G06F16/245 ,  H04L67/1097

    Abstract: Replication and failover of database data is disclosed. A method includes replicating database data stored in a primary deployment such that the database data is further stored in a secondary deployment. The method includes executing one or more updates to the database data at the secondary deployment when the primary deployment is unavailable and propagating the one or more updates to the primary deployment when the primary deployment becomes available again. The method includes executing queries on the database data at the primary deployment when the primary deployment is available.

    LOADING PROCEDURES OF VERSIONED SCHEMA
    228.
    发明公开
    LOADING PROCEDURES OF VERSIONED SCHEMA 审中-公开

    公开(公告)号：US20240311136A1

    公开(公告)日：2024-09-19

    申请号：US18676446

    申请日：2024-05-28

    Applicant: Snowflake Inc.

    Inventor： Damien Carru ,  Benoit Dageville ,  Unmesh Jagtap ,  Subramanian Muralidhar ,  Jan Michael Timmerman

    IPC: G06F8/65 ,  G06F16/21

    CPC classification number: G06F8/65 ,  G06F16/219

    Abstract: A versioned schema of a data platform. A process of maintaining a call stack of executing objects of an application package having a versioned schema includes calling, by a first procedure executed by one or more processors, a second procedure of a versioned application instance, and determining, by the first procedure, a version of the second procedure based on a call context. In response to determining that the version of the second procedure is not in the call context, the first procedure determines a current version of the versioned application package adds the current version to the call context as the version of the second procedure.

Patent Agency Ranking