中科微点-全球专利检索

  1. Login
  2. Sign Up

Search Results

610 records (took 0.016 seconds)

    TASK SCHEDULING IN DATABASE SYSTEMS
    213.
    发明申请
    TASK SCHEDULING IN DATABASE SYSTEMS 审中-公开

    公开(公告)号：US20200167343A1

    公开(公告)日：2020-05-28

    申请号：US16705533

    申请日：2019-12-06

    Applicant: Snowflake Inc.

    Inventor： Istvan Cseri ,  Torsten Grabs ,  Benoit Dageville

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

    ACTIVE INVALIDATION OF METADATA CACHE ENTRIES
    217.
    发明申请
    ACTIVE INVALIDATION OF METADATA CACHE ENTRIES 有权

    公开(公告)号：US20250124035A1

    公开(公告)日：2025-04-17

    申请号：US18987523

    申请日：2024-12-19

    Applicant: Snowflake Inc.

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

    IPC: G06F16/2455 ,  G06F16/23

    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.

    Tracking intermediate changes in database data
    219.
    发明授权
    Tracking intermediate changes in database data 有权

    公开(公告)号：US12259877B2

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

    申请号：US18668993

    申请日：2024-05-20

    Applicant: Snowflake Inc.

    Inventor： Torsten Grabs ,  Istvan Cseri ,  Benoit Dageville

    IPC: G06F16/00 ,  G06F16/22 ,  G06F16/23 ,  G06F16/2455

    Abstract: Systems, methods, and devices for tracking a series of changes to database data are disclosed. A method includes executing a transaction to modify data in a micro-partition of a table of a database by generating a new micro-partition that embodies the transaction. The method includes associating transaction data with the new micro-partition, wherein the transaction data comprises a timestamp when the transaction was fully executed, and further includes associating modification data with the new micro-partition that comprises an indication of one or more rows of the table that were modified by the transaction. The method includes joining the transaction data with the modification data to generate joined data and querying the joined data to determine a listing of intermediate modifications made to the table between a first timestamp and a second timestamp.

Patent Agency Ranking