DATA REPLICATION AND DATA FAILOVER IN DATABASE SYSTEMS

    公开(公告)号:US20220019600A1

    公开(公告)日:2022-01-20

    申请号:US17491392

    申请日:2021-09-30

    Applicant: Snowflake Inc.

    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.

    Identifying software regressions based on query retry attempts in a database environment

    公开(公告)号:US11216446B2

    公开(公告)日:2022-01-04

    申请号:US16555970

    申请日:2019-08-29

    Applicant: Snowflake Inc.

    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.

    Data sharing in a multi-tenant database system

    公开(公告)号:US11210415B2

    公开(公告)日:2021-12-28

    申请号:US17347143

    申请日:2021-06-14

    Applicant: SNOWFLAKE INC.

    Abstract: A method for sharing data in a multi-tenant database includes receiving, by a target account of a multiple tenant database, access rights of a share object in a first account of the multiple tenant database, wherein the share object having access rights to a database object of the first account and wherein access to the database object of the first account by the target account is based on the access rights of the share object. The method also includes receiving, by one or more processors of the target account, access rights to an alias object, wherein the alias object references the database object of the first account.

    TRIGGERS OF SCHEDULED TASKS IN DATABASE SYSTEMS

    公开(公告)号:US20210357391A1

    公开(公告)日:2021-11-18

    申请号:US17389234

    申请日:2021-07-29

    Applicant: Snowflake Inc.

    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.

    Transactional streaming of change tracking metadata

    公开(公告)号:US11169983B1

    公开(公告)日:2021-11-09

    申请号:US17364562

    申请日:2021-06-30

    Applicant: Snowflake Inc.

    Abstract: Systems, methods, and devices for generating a transactional change tracking summary for a database. A method includes executing a transaction on a table of a database, wherein the table includes a micro-partition and the transaction is executed on the micro-partition. The method includes, in response to the transaction being fully executed, generating a change tracking entry comprising an indication of one or modifications made to the table by the transaction. The method includes storing the change tracking entry in a change tracking stream, wherein the change tracking stream includes one or more sequential change tracking entries that each correspond to a different transaction that is fully executed on the table.

Patent Agency Ranking