-
公开(公告)号:US11860896B2
公开(公告)日:2024-01-02
申请号:US17935869
申请日:2022-09-27
申请人: Snowflake Inc.
发明人: Robert Bengt Benedikt Gernhardt , Chao-Yang Lo , Nithin Mahesh , Subramanian Muralidhar , Sahaj Saini
IPC分类号: G06F16/00 , G06F16/27 , G06F16/185 , G06F16/11 , G06F16/13
CPC分类号: G06F16/273 , G06F16/11 , G06F16/13 , G06F16/185
摘要: A system for data object replication includes at least one hardware processor and at least one memory storing instructions. The instructions cause the at least one hardware processor to perform operations including decoding a replication request to obtain a data object. Object dependencies associated with the data object and a plurality of additional data objects are determined. A replication sequence of the data object and the plurality of additional data objects is determined based on the object dependencies. A replication of the data object and at least one of the plurality of additional data objects is performed according to the replication sequence. A notification of a successful completion of the replication is generated.
-
公开(公告)号:US20230409431A1
公开(公告)日:2023-12-21
申请号:US18349688
申请日:2023-07-10
申请人: Snowflake Inc.
CPC分类号: G06F11/1435 , G06F16/256 , G06F16/27 , G06F2201/84
摘要: This disclosure provides methods and techniques of data replication involving cross replication group (RG) references. The present disclosure avoids automatic replication failing when an entity in an RG refers to another entity external to the RG. The entity to be replicated within the RG is referred to as the “referring entity,” and the entity as the dangling reference is referred to as the “referred entity.” Although the referring and referred entities are not replicated together in a replication operation, the referred entity may have already been replicated to the target account in another replication operation on a different replication group. In such cases, the data replication procedure may, according to aspects of the present disclosure, check if the referred entity has already been replicated, and if so, proceed to replicate the referring entity without fail, and link the referring and referred entities to enable normal functioning of the referring entity.
-
公开(公告)号:US20230376391A1
公开(公告)日:2023-11-23
申请号:US18158586
申请日:2023-01-24
申请人: Snowflake Inc.
发明人: Abdullah Al Mahmood , Ruta Dhaneshwar , Xin Huang , Ganeshan Ramachandran Iyer , Jiaxing Liang , Nithin Mahesh , Raghav Ramachandran , Purav B. Saraiya , Yanyi Zhang
CPC分类号: G06F11/2028 , G06F16/27 , G06F11/1435
摘要: Described herein are techniques for improving disaster recovery, in particular disaster recovery pertaining to data transfer requests. The data transfer request can be received by each of multiple deployments; however, only a primary deployment can process the request. The data transferred by the primary deployment may be replicated in the secondary deployments. In response to a failover event, one of the secondary deployments can be designated as the new primary development and continue the data transfer based on the data transfer request and the replication information received from the old primary deployment prior to the failover.
-
公开(公告)号:US20230297590A1
公开(公告)日:2023-09-21
申请号:US18323155
申请日:2023-05-24
申请人: Snowflake Inc.
发明人: Robert Bengt Benedikt Gernhardt , Mikhail Kazhamiaka , Nithin Mahesh , Laxman Mamidi , Subramanian Muralidhar , Vishnu Dutt Paladugu , Sahaj Saini
IPC分类号: G06F16/27 , G06F11/14 , G06F16/25 , G06F11/20 , G06F16/182 , G06F16/13 , G06F16/178 , G06F16/11
CPC分类号: G06F16/27 , G06F11/1464 , G06F16/256 , G06F11/2023 , G06F11/1461 , G06F16/184 , G06F16/1827 , G06F16/137 , G06F16/1787 , G06F16/1844 , G06F16/128 , G06F11/2097
摘要: A method includes generating at a source account of a database system user, a replication group object (RGO). The RGO includes a manifest identifying one or more data object types and one or more databases. A replication of data objects of the one or more data object types is performed from the one or more databases to a target account of the database system user. The replication of the data objects is performed as a unit. The RGO is replicated as a failover group object (FGO) within the target account of the database system user. A network failure is detected at the source account of the database system user. The target account of the database system user is promoted as a new source account based on the detecting of the network failure.
-
公开(公告)号:US11645232B1
公开(公告)日:2023-05-09
申请号:US17809829
申请日:2022-06-29
申请人: Snowflake Inc.
CPC分类号: G06F16/148 , G06F16/164
摘要: 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.
-
公开(公告)号:US20230134358A1
公开(公告)日:2023-05-04
申请号:US17457010
申请日:2021-11-30
申请人: Snowflake Inc.
发明人: Lin Chan , Tianyi Chen , Benoit Dageville , Yiming Kang , Jun Luo , Nithin Mahesh , Eric Robinson , Brian Smith
IPC分类号: G06F16/2453 , G06F21/62 , G06F16/23 , G06F16/22
摘要: As described herein, a N-Gram index may be created and the search may be conducted using the index, which will lead to faster search results. The N-Gram index may also include partial N-Gram components to capture more relevant data. Moreover, as described herein, the search may also take into account recent log data that has not yet been indexed. Techniques for building an index store using log data and efficiently searching the index store and log data to process search requests are described herein.
-
公开(公告)号:US11640412B2
公开(公告)日:2023-05-02
申请号:US17804753
申请日:2022-05-31
申请人: Snowflake Inc.
发明人: Pui Kei Johnston Chu , Shreyas Narendra Desai , German Alberto Gil Echeverri , Prasanna Krishnan , Nithin Mahesh , Subramanian Muralidhar , Eric Robinson , Sahaj Saini
IPC分类号: G06F16/00 , G06F16/27 , G06F16/23 , G06F16/22 , G06Q30/018 , G06Q30/0204
摘要: 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.
-
公开(公告)号:US11636110B1
公开(公告)日:2023-04-25
申请号:US17457010
申请日:2021-11-30
申请人: Snowflake Inc.
发明人: Lin Chan , Tianyi Chen , Benoit Dageville , Yiming Kang , Jun Luo , Nithin Mahesh , Eric Robinson , Brian Smith
IPC分类号: G06F16/00 , G06F16/2453 , G06F16/22 , G06F16/23 , G06F21/62
摘要: As described herein, a N-Gram index may be created and the search may be conducted using the index, which will lead to faster search results. The N-Gram index may also include partial N-Gram components to capture more relevant data. Moreover, as described herein, the search may also take into account recent log data that has not yet been indexed. Techniques for building an index store using log data and efficiently searching the index store and log data to process search requests are described herein.
-
公开(公告)号:US20210374159A1
公开(公告)日:2021-12-02
申请号:US17352044
申请日:2021-06-18
申请人: Snowflake Inc.
发明人: Pui Kei Johnston Chu , Shreyas Narendra Desai , German Alberto Gil Echeverri , Prasanna Krishnan , Nithin Mahesh , Subramanian Muralidhar , Eric Robinson , Sahaj Saini
摘要: 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.
-
公开(公告)号:US20210344655A1
公开(公告)日:2021-11-04
申请号:US17219700
申请日:2021-03-31
申请人: Snowflake Inc.
发明人: Damien Carru , Robert Bengt Benedikt Gernhardt , Martin Hentschel , Nithin Mahesh , Eric Robinson
摘要: 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.
-
-
-
-
-
-
-
-
-