Patents by Inventor Nithin Mahesh
Nithin Mahesh has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).
-
Publication number: 20240054147Abstract: 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.Type: ApplicationFiled: October 25, 2023Publication date: February 15, 2024Inventors: Pui Kei Johnston Chu, Shreyas Narendra Desai, German Alberto Gil Echeverri, Prasanna Krishnan, Nithin Mahesh, Subramanian Muralidhar, Eric Robinson, Sahaj Saini
-
Publication number: 20240004901Abstract: 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 parsing a replication request to obtain a data object and identification information identifying a set of databases at a first deployment of a data provider. A dependency of the data object to one or more additional data objects stored in the set of databases is detected. A sequential replication of the data object and the one or more additional data object from the first deployment to a second deployment of the data provider is performed. The second deployment is identified by the replication request. A sequence of the sequential replication is based on the detected dependency.Type: ApplicationFiled: September 15, 2023Publication date: January 4, 2024Inventors: Robert Bengt Benedikt Gernhardt, Chao-Yang Lo, Nithin Mahesh, Subramanian Muralidhar, Sahaj Saini
-
Patent number: 11860896Abstract: 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.Type: GrantFiled: September 27, 2022Date of Patent: January 2, 2024Assignee: Snowflake Inc.Inventors: Robert Bengt Benedikt Gernhardt, Chao-Yang Lo, Nithin Mahesh, Subramanian Muralidhar, Sahaj Saini
-
Publication number: 20230418711Abstract: This disclosure provides methods and techniques of data replication involving cross replication group (RG) references. Example methods, systems, and techniques are disclosed regarding batch database replication (e.g., backup) and failover (e.g., automatic transition to a backup) between multiple database deployments or database providers. For example, a system causes database data to be stored in a primary deployment and replicated in one or more secondary deployments. In the event that data in the primary deployment is unavailable, transactions may be executed on one or more of the secondary deployments. When the original primary deployment becomes available again, any transactions executed on secondary deployments may be propagated to the primary deployment. The system may be configured such that queries on the database data are executed on the primary deployment at any time when the primary deployment is available.Type: ApplicationFiled: September 12, 2023Publication date: December 28, 2023Inventors: Hitesh Madan, Nithin Mahesh, Matthew Uhlar
-
Publication number: 20230409431Abstract: 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.Type: ApplicationFiled: July 10, 2023Publication date: December 21, 2023Inventors: Robert Bengt Benedikt Gernhardt, Nithin Mahesh, Sahaj Saini, Matthew Uhlar
-
Publication number: 20230401229Abstract: The distributed database can implement unstructured data replication using an internal or external storage location. Metadata, such as a directory table that lists the unstructured files, can be replicated across different deployments, followed by replication of the staged data. Replicating the staged data can be implemented by replication of only the stage metadata or replication of the database files between the deployments.Type: ApplicationFiled: November 1, 2022Publication date: December 14, 2023Inventors: Robert Bengt Benedikt Gernhardt, Chong Han, Nithin Mahesh, Aravind Ramarathinam, Saurin Shah, Yanrui Zhang
-
Patent number: 11841877Abstract: 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.Type: GrantFiled: June 21, 2022Date of Patent: December 12, 2023Assignee: Snowflake Inc.Inventors: Pui Kei Johnston Chu, Shreyas Narendra Desai, German Alberto Gil Echeverri, Prasanna Krishnan, Nithin Mahesh, Subramanian Muralidhar, Eric Robinson, Sahaj Saini
-
Publication number: 20230376391Abstract: 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.Type: ApplicationFiled: January 24, 2023Publication date: November 23, 2023Inventors: Abdullah Al Mahmood, Ruta Dhaneshwar, Xin Huang, Ganeshan Ramachandran Iyer, Jiaxing Liang, Nithin Mahesh, Raghav Ramachandran, Purav B. Saraiya, Yanyi Zhang
-
Publication number: 20230344796Abstract: Different database deployments, or other data system deployments, may want to communicate with each other without sacrificing security or control. To this end, embodiments of the present disclosure may provide secure message exchange techniques for a source and/or target deployment. Configurable rule sets may be stored in the deployments; the rule sets may define what messages may be communicated between deployments. The deployments may implement a selective filtering scheme in one or more stages based on the rule sets to filter outgoing and/or incoming messages.Type: ApplicationFiled: June 27, 2023Publication date: October 26, 2023Inventors: Robert Bengt Benedikt Gernhardt, Mikhail Kazhamiaka, Nithin Mahesh, Eric Robinson
-
Publication number: 20230297591Abstract: Various embodiments provide for replicating a share across deployments of a data platform, where the share can be on a source deployment and the share can be replicated on one or more target deployments, and where the share is replicated with one or more database objects of the source deployment associated with the share. Some embodiments analyze the share to be replicated and, based on the analysis, determine one or more database objects that would be replicated to the one or more target deployments to enable a replica of the share on the one or more target deployments.Type: ApplicationFiled: May 26, 2023Publication date: September 21, 2023Inventors: Pui Kei Johnston Chu, Benoit Dageville, Shreyas Narendra Desai, Nithin Mahesh, Subramanian Muralidhar, Vishnu Dutt Paladugu, Sahaj Saini, Chieh-Sheng Wang, Di Wu
-
Publication number: 20230297590Abstract: 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.Type: ApplicationFiled: May 24, 2023Publication date: September 21, 2023Inventors: Robert Bengt Benedikt Gernhardt, Mikhail Kazhamiaka, Nithin Mahesh, Laxman Mamidi, Subramanian Muralidhar, Vishnu Dutt Paladugu, Sahaj Saini
-
Patent number: 11748374Abstract: Provided herein are systems and methods for configuring replication group objects. A system includes at least one hardware processor coupled to memory and configured to decode a replication request received from a client device of a data provider. The replication request indicates a plurality of account objects for replication. The plurality of account objects associated with a corresponding plurality of account object types. A replication group object is generated based on the replication request. The replication group object includes a manifest. The manifest lists the plurality of account objects. The replication of the plurality of account objects is performed from a source account of the data provider into at least one target account. The replication is based on the manifest of the replication group object.Type: GrantFiled: December 6, 2021Date of Patent: September 5, 2023Assignee: Snowflake Inc.Inventors: Robert Bengt Benedikt Gernhardt, Mikhail Kazhamiaka, Nithin Mahesh, Laxman Mamidi, Subramanian Muralidhar, Vishnu Dutt Paladugu, Sahaj Saini
-
Patent number: 11736438Abstract: Different database deployments, or other data system deployments, may want to communicate with each other without sacrificing security or control. To this end, embodiments of the present disclosure may provide secure message exchange techniques for a source and/or target deployment. Configurable rule sets may be stored in the deployments; the rule sets may define what messages may be communicated between deployments. The deployments may implement a selective filtering scheme in one or more stages based on the rule sets to filter outgoing and/or incoming messages.Type: GrantFiled: January 22, 2021Date of Patent: August 22, 2023Assignee: Snowflake Inc.Inventors: Robert Bengt Benedikt Gernhardt, Mikhail Kazhamiaka, Nithin Mahesh, Eric Robinson
-
Publication number: 20230244695Abstract: 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.Type: ApplicationFiled: April 5, 2023Publication date: August 3, 2023Inventors: Pui Kei Johnston Chu, Shreyas Narendra Desai, German Alberto Gil Echeverri, Prasanna Krishnan, Nithin Mahesh, Subramanian Muralidhar, Eric Robinson, Sahaj Saini
-
Patent number: 11704338Abstract: Various embodiments provide for replicating a share across deployments of a data platform, where the share can be on a source deployment and the share can be replicated on one or more target deployments, and where the share is replicated with one or more database objects of the source deployment associated with the share. Some embodiments analyze the share to be replicated and, based on the analysis, determine one or more database objects that would be replicated to the one or more target deployments to enable a replica of the share on the one or more target deployments.Type: GrantFiled: February 28, 2022Date of Patent: July 18, 2023Assignee: Snowflake Inc.Inventors: Pui Kei Johnston Chu, Benoit Dageville, Shreyas Narendra Desai, Nithin Mahesh, Subramanian Muralidhar, Vishnu Dutt Paladugu, Sahaj Saini, Chieh-Sheng Wang, Di Wu
-
Patent number: 11704199Abstract: 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.Type: GrantFiled: August 31, 2022Date of Patent: July 18, 2023Assignee: Snowflake Inc.Inventors: Robert Bengt Benedikt Gernhardt, Nithin Mahesh, Sahaj Saini, Matthew Uhlar
-
Publication number: 20230214391Abstract: 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.Type: ApplicationFiled: March 14, 2023Publication date: July 6, 2023Inventors: Lin Chan, Tianyi Chen, Benoit Dageville, Yiming Kang, Jun Luo, Nithin Mahesh, Eric Robinson, Brian Smith
-
Publication number: 20230205735Abstract: 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.Type: ApplicationFiled: March 7, 2023Publication date: June 29, 2023Inventors: Lin Chan, Tianyi Chen, Robert Bengt Benedikt Gernhardt, Nithin Mahesh, Eric Robinson
-
Publication number: 20230185825Abstract: 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.Type: ApplicationFiled: September 27, 2022Publication date: June 15, 2023Inventors: Robert Bengt Benedikt Gernhardt, Chao-Yang LO, Nithin Mahesh, Subramanian Muralidhar, Sahaj Saini
-
Publication number: 20230169090Abstract: Provided herein are systems and methods for configuring replication group objects. A system includes at least one hardware processor coupled to memory and configured to decode a replication request received from a client device of a data provider. The replication request indicates a plurality of account objects for replication. The plurality of account objects associated with a corresponding plurality of account object types. A replication group object is generated based on the replication request. The replication group object includes a manifest. The manifest lists the plurality of account objects. The replication of the plurality of account objects is performed from a source account of the data provider into at least one target account. The replication is based on the manifest of the replication group object.Type: ApplicationFiled: December 6, 2021Publication date: June 1, 2023Inventors: Robert Bengt Benedikt Gernhardt, Mikhail Kazhamiaka, Nithin Mahesh, Laxman Mamidi, Subramanian Muralidhar, Vishnu Dutt Paladugu, Sahaj Saini