-
公开(公告)号：US20230244695A1
公开(公告)日：2023-08-03
申请号：US18295987
申请日：2023-04-05
Applicant: Snowflake Inc.
Inventor： Pui Kei Johnston Chu , Shreyas Narendra Desai , German Alberto Gil Echeverri , Prasanna Krishnan , Nithin Mahesh , Subramanian Muralidhar , Eric Robinson , Sahaj Saini
IPC: G06F16/27 , G06F16/23 , G06F16/22 , G06Q30/018 , G06Q30/0204
CPC classification number: G06F16/275 , G06F16/2282 , G06F16/2379 , G06Q30/0185 , G06Q30/0205
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.
-
公开(公告)号：US20230138110A1
公开(公告)日：2023-05-04
申请号：US17809829
申请日：2022-06-29
Applicant: Snowflake Inc.
Inventor： Lin Chan , Tianyi Chen , Robert Bengt Benedikt Gernhardt , Nithin Mahesh , Eric Robinson
Abstract: Techniques for executing show commands are described herein. A plurality of navigation steps is utilized, each navigation step corresponding to a different layer in a database structure and each navigation step including an operator to fetch items from a metadata database up to respective bounded limits. Dependency information is also fetched for objects of the specified object type in the show command. After a set of objects from the last layer are processed, memory for the navigation steps is flushed and the next set of objects are processed.
-
公开(公告)号：US11539677B2
公开(公告)日：2022-12-27
申请号：US17656620
申请日：2022-03-25
Applicant: Snowflake Inc.
Inventor： Damien Carru , Robert Bengt Benedikt Gernhardt , Martin Hentschel , Nithin Mahesh , Eric Robinson
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.
-
公开(公告)号：US11436257B2
公开(公告)日：2022-09-06
申请号：US17352044
申请日：2021-06-18
Applicant: Snowflake Inc.
Inventor： Pui Kei Johnston Chu , Shreyas Narendra Desai , German Alberto Gil Echeverri , Prasanna Krishnan , Nithin Mahesh , Subramanian Muralidhar , Eric Robinson , Sahaj Saini
Abstract: A method of implementing sub-table replication starts with the processor detecting an update to an entitlements table. The processor performs filtering of a data table based on the update to the entitlements table. The data table including an entitlements column. The processor detects an update to the entitlements column and performs incremental replication of the data table by causing a version-based replication to be executed. Other embodiments are also described herein.
-
公开(公告)号：US11314777B2
公开(公告)日：2022-04-26
申请号：US17491392
申请日：2021-09-30
Applicant: Snowflake Inc.
Inventor： Benoit Dageville , Eric Robinson , Martin Hentschel
IPC: G06F16/30 , G06F16/27 , 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.
-
Patent Agency Ranking
公开(公告)号：US20220116360A1
公开(公告)日：2022-04-14
申请号：US17644854
申请日：2021-12-17
Applicant: Snowflake Inc.
Inventor： Robert Bengt Benedikt Gernhardt , Mikhail Kazhamiaka , Eric Robinson , Rodney Weaver
Abstract: A network device communication system can configure network devices (e.g., a primary and secondary database) to send and receive sequences messages, such as replication data, over a channel comprising a plurality of private network nodes. The messages can be generated and encrypted using one or more key pairs and changing wrapping replication keys to send and receive the messages between different types of database deployments.
-
公开(公告)号：US11063911B1
公开(公告)日：2021-07-13
申请号：US17162919
申请日：2021-01-29
Applicant: Snowflake Inc.
Inventor： Robert Bengt Benedikt Gernhardt , Mikhail Kazhamiaka , Eric Robinson , Rodney Weaver
Abstract: A network device communication system can configure network devices (e.g., a primary and secondary database) to send and receive sequences messages, such as replication data, over a channel comprising a plurality of private network nodes. The messages can be generated and encrypted using one or more key pairs and changing wrapping replication keys to send and receive the messages between different types of database deployments.
-
公开(公告)号：US10997210B1
公开(公告)日：2021-05-04
申请号：US16944983
申请日：2020-07-31
Applicant: Snowflake Inc.
Inventor： Pui Kei Johnston Chu , Shreyas Narendra Desai , German Alberto Gil Echeverri , Prasanna Krishnan , Nithin Mahesh , Subramanian Muralidhar , Eric Robinson , Sahaj Saini
Abstract: A method of implementing sub-table replication starts with the processor detecting a first update to an entitlements table. The processor filters of a data table based on the first update. The processor then detects a second update to the entitlements table and performs incremental replication of the data table by causing a full inventory replication at a next refresh to be executed for provider accounts associated with the provider account identifiers in the entitlements table. Other embodiments are also described herein.
-
公开(公告)号：US10997207B2
公开(公告)日：2021-05-04
申请号：US17064888
申请日：2020-10-07
Applicant: Snowflake Inc.
Inventor： Eric Robinson , Benoit Dageville , Shigeyuki Takeda , Kristopher Wagner
Abstract: The subject technology generates a unique identification that references a first connection object of a first deployment and a second connection object of a second deployment of a database. The subject technology receives a notification that the first deployment is unavailable, the notification that the first deployment is unavailable comprises an indication of a downtime for the first deployment. The subject technology provides an external connection group unique identification to the second deployment for the second deployment to determine whether a client is to be connected to the second deployment. The subject technology receives a uniform resource locator from the second deployment when a client device is to be connected to the second deployment, the uniform resource locator being provided to the client device for connecting to the second deployment.
-
公开(公告)号：US20210019331A1
公开(公告)日：2021-01-21
申请号：US17064888
申请日：2020-10-07
Applicant: Snowflake Inc.
Inventor： Eric Robinson , Benoit Dageville , Shigeyuki Takeda , Kristopher Wagner
Abstract: The subject technology generates a unique identification that references a first connection object of a first deployment and a second connection object of a second deployment of a database. The subject technology receives a notification that the first deployment is unavailable, the notification that the first deployment is unavailable comprises an indication of a downtime for the first deployment. The subject technology provides an external connection group unique identification to the second deployment for the second deployment to determine whether a client is to be connected to the second deployment. The subject technology receives a uniform resource locator from the second deployment when a client device is to be connected to the second deployment, the uniform resource locator being provided to the client device for connecting to the second deployment.
-
-
-
-
-
-
-
-
-
Search Results
74
records
(took 0.024 seconds)
