MATERIALIZED VIEW SUB-DATABASE REPLICATION

    公开(公告)号:US20220292115A1

    公开(公告)日:2022-09-15

    申请号:US17804753

    申请日:2022-05-31

    Applicant: Snowflake Inc.

    Abstract: A system for sub-table replication within a materialized view of a source data table. A materialized view of a source data table is generated based on a query, the source data table having a plurality of data table rows associated with a plurality of client identifiers and including an entitlements column and data content, the entitlements column including a plurality of provider account identifiers and a plurality of consumer account identifiers. An update to an entitlements table of the source data table is detected where the entitlements table includes a plurality of entitlements table rows and where the entitlements table rows are associated with the client identifiers, the consumer account identifiers, and the provider account identifiers. An update to the source data table based on the first update to the entitlements table is detected, and an incremental replication of the materialized view of the source data table is performed.

    Message-based database replication
    56.
    发明授权

    公开(公告)号:US10862873B1

    公开(公告)日:2020-12-08

    申请号:US16863191

    申请日:2020-04-30

    Applicant: Snowflake Inc.

    Abstract: A networked device communication system can configure network devices (e.g., a primary and secondary database) to send and receive sequences of messages, such as replicated data, using one or more keypairs and wrapping keys. The sequences of messages can include an initial set of messages that are encrypted by a wrapping key, and further include another set of messages that are encrypted by a replaced staggered key. The sequence of messages can be configured to be decrypted without exporting keys of hardware security modules.

    Transferring Connections in a Multiple Deployment Database

    公开(公告)号:US20200301942A1

    公开(公告)日:2020-09-24

    申请号:US16357822

    申请日:2019-03-19

    Applicant: Snowflake Inc.

    Abstract: Systems, methods, and devices for transitioning a client connection for a database from a first deployment of the database to a second deployment of the database. A method includes maintaining the client connection between a client and the first deployment such that database traffic occurs at the first deployment. The method includes generating a unique identification that references a first connection object of the first deployment and a second connection object of a second deployment. The method includes receiving a notification that the first deployment is unavailable and providing an external connection group unique identification to the second deployment for the second deployment to determine whether the client should be connected to the second deployment. The method includes receiving a uniform resource locator from the second deployment if the client should be connected to the second deployment.

    DIRECTING REQUESTS TO DATABASES BASED ON CLIENT ACCOUNT ASSOCIATION

    公开(公告)号:US20250053576A1

    公开(公告)日:2025-02-13

    申请号:US18931781

    申请日:2024-10-30

    Applicant: Snowflake Inc.

    Abstract: Systems of methods of directing requests to databases based on client account association is disclosed. A method includes determining a first client account associated with a first request to perform a first transaction. The method includes determining a second client account associated with a second request to perform a second transaction. The method includes selecting, for the first request, a primary deployment that stores a first dataset responsive to determining the first client account associated with the first request. The method includes selecting, for the second request, a secondary deployment that stores a second dataset that includes the first dataset responsive to determining the second client account associated with the second request. The method includes executing, while the primary deployment and the secondary deployment are both available, the first transaction on the first dataset at the primary deployment and the second transaction on the second dataset at the secondary deployment.

Patent Agency Ranking