中科微点-全球专利检索

  1. Login
  2. Sign Up

Search Results

610 records (took 0.026 seconds)

    TRACKING CHANGES IN DATABASE DATA
    152.
    发明申请
    TRACKING CHANGES IN DATABASE DATA 有权

    公开(公告)号：US20220245121A1

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

    申请号：US17660132

    申请日：2022-04-21

    Applicant: Snowflake Inc.

    Inventor： Istvan Cseri ,  Torsten Grabs ,  Benoit Dageville

    IPC: G06F16/23 ,  G06F16/27 ,  G06F16/2455

    Abstract: A method includes partitioning a database table into a first plurality of partitions. A plurality of changes are executed on the database table in response to a transaction. The changes occur at a corresponding plurality of timestamps and result in a second plurality of partitions. The database table is updated to include a log with the plurality of changes. For each change of the plurality of changes, the log includes and an identification of a portion of the database table the change is applied to. A selection of a first timestamp and a second timestamp of the plurality of timestamps is detected. A delta is generated in response to the selection. The delta indicates a total change occurring to the database table between a first change of the plurality of changes corresponding to the first timestamp and a second change of the plurality of changes corresponding to the second timestamp.

    TRACKING INTERMEDIATE CHANGES IN DATABASE DATA
    154.
    发明申请
    TRACKING INTERMEDIATE CHANGES IN DATABASE DATA 有权

    公开(公告)号：US20220222247A1

    公开(公告)日：2022-07-14

    申请号：US17656960

    申请日：2022-03-29

    Applicant: Snowflake Inc.

    Inventor： Torsten Grabs ,  Istvan Cseri ,  Benoit Dageville

    IPC: G06F16/23 ,  G06F16/22 ,  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.

    DATA REPLICATION AND DATA FAILOVER IN DATABASE SYSTEMS
    156.
    发明申请
    DATA REPLICATION AND DATA FAILOVER IN DATABASE SYSTEMS 有权

    公开(公告)号：US20220215041A1

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

    申请号：US17703804

    申请日：2022-03-24

    Applicant: Snowflake Inc.

    Inventor： Benoit Dageville ,  Eric Robinson ,  Martin Hentschel

    IPC: G06F16/27 ,  G06F16/245

    Abstract: Replication and failover of database data is disclosed. A method includes copying a first dataset of a first account stored in a primary deployment to a secondary deployment. The method includes determining that the first dataset stored in the primary deployment is unavailable. The method includes executing a first transaction on the first dataset at the secondary deployment in response to determining that the first dataset stored in the primary deployment is unavailable. The method includes executing a second transaction on a second dataset of a second account at the primary deployment while the first dataset of the first account stored in the primary deployment is unavailable.

    Replicating a database at a remote deployment
    159.
    发明授权
    Replicating a database at a remote deployment 有权

    公开(公告)号：US11347773B1

    公开(公告)日：2022-05-31

    申请号：US17490614

    申请日：2021-09-30

    Applicant: Snowflake Inc.

    Inventor： Pui Kei Johnston Chu ,  Benoit Dageville ,  Shreyas Narendra Desai ,  Sameer Deshpande ,  Subramanian Muralidhar ,  Di Wu

    IPC: G06F16/00 ,  G06F16/27 ,  G06F16/182

    Abstract: Disclosed herein are systems and methods for database replication to a remote deployment with automated fulfillment. In an embodiment, a data platform detects receipt of a database-replication request associated with a data consumer, requesting availability of a local instance of a primary-deployment database in a remote-deployment account of a data provider at a remote deployment of the data platform. The data platform responsively performs remote-deployment-activation operations including provisioning the remote-deployment account with a set of one or more replication-preparation objects associated with the primary-deployment database, and also including invoking at least one refresh command with respect to the set of one or more replication-preparation objects, which makes available to the data consumer a local instance of the primary-deployment database in the remote-deployment account of the data provider at the remote deployment of the data platform.

Patent Agency Ranking