Patents by Inventor Mahendra Chavan
Mahendra Chavan 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: 20250045298Abstract: An application running on one or more edge devices for executing a plurality of transactions. A wrapper class captures the plurality of transactions executed by the application in form of a plurality of transaction logs. A remote directory includes one or more device directories corresponding to the one or more edge devices, wherein the one or more device directories store the plurality of transaction logs of one or more synced edge devices. A target database consolidator including a replicator to read the plurality of transactions, replicate each of the plurality of transaction logs of each of the one or more synced edge devices, generates a plurality of change log files for each of a plurality of command log files; a device scheduler manages scheduling of at least one of the one or more edge devices, the plurality of change log files for initiating data consolidation.Type: ApplicationFiled: December 5, 2022Publication date: February 6, 2025Inventor: Arati Mahendra Chavan
-
Patent number: 11216346Abstract: Disclosed herein are system, method, and computer program product embodiments for coordinated replication of heterogeneous database stores. An embodiment operates by determining a synchronization point based on a commit log of a primary data center. A current log position of each of a plurality of secondary slave servers associated with a secondary master server of a secondary data center is requested. It is determined that the current log position of at least one of the secondary slave servers does not correspond to the logged position of a corresponding primary slave server relative to the synchronization point. An update indicating that the current log position of each of the secondary slave servers corresponds to the logged position of each of the relative corresponding primary slave servers is received. A replay of each of the secondary slave servers up to the synchronization point is initiated.Type: GrantFiled: January 22, 2018Date of Patent: January 4, 2022Assignee: SAP SEInventors: Mahendra Chavan, Reiner Singer, Markus Behrens, John Smirnios, Anant Agarwal
-
Patent number: 11182405Abstract: Disclosed herein are system, method, and computer program product embodiments for providing a lock-free parallel log replay and synchronization scheme to support asynchronous table replication. By synchronizing a replica table with the server-side data and conducting subsequent updates using transaction logs via a replayer, locking of tables may be avoided. A consistent transactional state may be maintained by employing a replayer to mark the table as enabled instead of a synchronizer. The replayer may also deduce transitive closures among transactions and replay the transactions in parallel based on the deduced transitive closures to optimize playback. These techniques provide enhanced data availability and minimize database blocking and deadlocking while improving query performance.Type: GrantFiled: April 3, 2019Date of Patent: November 23, 2021Assignee: SAP SEInventors: Priya Sharma, Mahendra Chavan, Kunj Kothari
-
Patent number: 11061927Abstract: Disclosed herein are system, method, and computer program product embodiments for appropriately routing requests for data stored in multiple storage mediums. An embodiment operates by maintaining a first and second data stored on a first storage medium in communication with a second storage medium. Thereafter, a replicate of the first data stored in the first storage medium may be created for the second storage medium to store a replica data mirroring the first data. Subsequently, a request for retrieval of the first data may be received. Afterward, a previous update time of the second storage medium in receiving the replicate of the first data stored in the first storage medium may be determined. Lastly, based on the previous update time, the request may be forwarded to the first storage medium or second storage medium.Type: GrantFiled: April 3, 2019Date of Patent: July 13, 2021Assignee: SAP SEInventors: Yinghua Ouyang, Priya Sharma, Mahendra Chavan
-
Publication number: 20200320098Abstract: Disclosed herein are system, method, and computer program product embodiments for providing a lock-free parallel log replay and synchronization scheme to support asynchronous table replication. By synchronizing a replica table with the server-side data and conducting subsequent updates using transaction logs via a replayer, locking of tables may be avoided. A consistent transactional state may be maintained by employing a replayer to mark the table as enabled instead of a synchronizer. The replayer may also deduce transitive closures among transactions and replay the transactions in parallel based on the deduced transitive closures to optimize playback. These techniques provide enhanced data availability and minimize database blocking and deadlocking while improving query performance.Type: ApplicationFiled: April 3, 2019Publication date: October 8, 2020Inventors: Priya SHARMA, Mahendra Chavan, Kunj Kothari
-
Publication number: 20200320094Abstract: Disclosed herein are system, method, and computer program product embodiments for appropriately routing requests for data stored in multiple storage mediums. An embodiment operates by maintaining a first and second data stored on a first storage medium in communication with a second storage medium. Thereafter, a replicate of the first data stored in the first storage medium may be created for the second storage medium to store a replica data mirroring the first data. Subsequently, a request for retrieval of the first data may be received. Afterward, a previous update time of the second storage medium in receiving the replicate of the first data stored in the first storage medium may be determined. Lastly, based on the previous update time, the request may be forwarded to the first storage medium or second storage medium.Type: ApplicationFiled: April 3, 2019Publication date: October 8, 2020Inventors: Yinghua Ouyang, Priya Sharma, Mahendra Chavan
-
Publication number: 20190155705Abstract: Disclosed herein are system, method, and computer program product embodiments for coordinated replication of heterogeneous database stores. An embodiment operates by determining a synchronization point based on a commit log of a primary data center. A current log position of each of a plurality of secondary slave servers associated with a secondary master server of a secondary data center is requested. It is determined that the current log position of at least one of the secondary slave servers does not correspond to the logged position of a corresponding primary slave server relative to the synchronization point. An update indicating that the current log position of each of the secondary slave servers corresponds to the logged position of each of the relative corresponding primary slave servers is received. A replay of each of the secondary slave servers up to the synchronization point is initiated.Type: ApplicationFiled: January 22, 2018Publication date: May 23, 2019Inventors: Mahendra Chavan, Reiner Singer, Markus Behrens, John Smirnios, Anant Agarwal
-
Patent number: 10255139Abstract: Synchronized backup and recovery of heterogeneous DBMSs is described herein. An embodiment operates by receiving, by at least one processor, a request for a data backup process at a first server; creating, by at least one processor, a pipe between processes of the first sever and the data backup process; performing, by at least one processor, the data backup process according to an execution command sent from a second server; and sending, by at least one processor, a result of the data backup process from the second server to the first server when the data backup process has terminated.Type: GrantFiled: July 26, 2016Date of Patent: April 9, 2019Assignee: SAP SEInventors: Anant Agarwal, Mahendra Chavan, Nandan Marathe, Dipesh Pandit
-
Publication number: 20180032408Abstract: Synchronized backup and recovery of heterogeneous DBMSs is described herein. An embodiment operates by receiving, by at least one processor, a request for a data backup process at a first server; creating, by at least one processor, a pipe between processes of the first sever and the data backup process; performing, by at least one processor, the data backup process according to an execution command sent from a second server; and sending, by at least one processor, a result of the data backup process from the second server to the first server when the data backup process has terminated.Type: ApplicationFiled: July 26, 2016Publication date: February 1, 2018Inventors: Anant AGARWAL, Mahendra Chavan, Nandan Marathe, Dipesh Pandit
-
Patent number: 9575849Abstract: Disclosed herein are system, method, and computer program product embodiments for utilizing a backup catalog to perform synchronized backup and recovery of heterogeneous database systems. An embodiment operates by performing a global data backup of a heterogeneous database system comprising a first database management system (DBMS) at a first server and a second DBMS at a second server and recording a global data backup entry identifying the global data backup into a backup catalog. Upon receiving log backup notifications regarding asynchronous log backups on the first server and the second server, log backup entries identifying the asynchronous log backups are recorded into the backup catalog. To successfully perform a point-in-time recovery, the embodiment operates by using the backup catalog to identify data and log backups required for the recovery of the first and second servers to a recovery timestamp associated with the point-in-time recovery.Type: GrantFiled: November 25, 2014Date of Patent: February 21, 2017Assignee: SAP SEInventors: Kaushal Mittal, Mahendra Chavan, Blaine French, John Smirnios
-
Patent number: 9471634Abstract: Disclosed herein are system, method, and computer program product embodiments for accelerating database queries containing bitmap-based conditions. An embodiment operates by determining a bitmap, where the bitmap represents a set of rows that have satisfied a conjunct that precedes a negated condition in a query expression and restricting the evaluation of the negated condition to the set of rows represented by the bitmap.Type: GrantFiled: March 12, 2014Date of Patent: October 18, 2016Assignee: Sybase, Inc.Inventors: Kaushal Mittal, Mahendra Chavan
-
Publication number: 20160147614Abstract: Disclosed herein are system, method, and computer program product embodiments for utilizing a backup catalog to perform synchronized backup and recovery of heterogeneous database systems. An embodiment operates by performing a global data backup of a heterogeneous database system comprising a first database management system (DBMS) at a first server and a second DBMS at a second server and recording a global data backup entry identifying the global data backup into a backup catalog. Upon receiving log backup notifications regarding asynchronous log backups on the first server and the second server, log backup entries identifying the asynchronous log backups are recorded into the backup catalog. To successfully perform a point-in-time recovery, the embodiment operates by using the backup catalog to identify data and log backups required for the recovery of the first and second servers to a recovery timestamp associated with the point-in-time recovery.Type: ApplicationFiled: November 25, 2014Publication date: May 26, 2016Inventors: Kaushal MITTAL, Mahendra CHAVAN, Blaine FRENCH, John SMIRNIOS
-
Publication number: 20150261821Abstract: Disclosed herein are system, method, and computer program product embodiments for accelerating database queries containing bitmap-based conditions.Type: ApplicationFiled: March 12, 2014Publication date: September 17, 2015Inventors: Kaushal MITTAL, Mahendra Chavan
-
Publication number: 20150261860Abstract: Disclosed herein are methods for retrieving data from a database. Various embodiments operate by breaking a predicate tree into one or more predicate tree fragments and then executing the various fragments in parallel. The execution of each of the predicate tree fragments results in a bitmap fragment. The bitmap fragments from the execution of the predicate tree fragments can be then combined into a resulting bitmap.Type: ApplicationFiled: March 12, 2014Publication date: September 17, 2015Inventors: Kaushal MITTAL, Mahendra Chavan, Kurt Deschler, David Walrath
-
Publication number: 20150261862Abstract: Embodiments include systems, methods and computer-readable mediums for accelerating a database query containing multiple predicates connected conjunctively. The database system receives a database query on a table. The database query includes a first predicate and a second predicate connected conjunctively. The database system produces a search space that satisfies a pre-filter for the first predicate. The search space represents rows of the table that satisfy the first predicate. The database system then applies the search space to evaluation of the second predicate. In one embodiment, the first predicate is a LIKE predicate requesting rows matching a search string in a column, and the pre-filter is a word index representing rows of the table containing a token of the search string in the column.Type: ApplicationFiled: March 12, 2014Publication date: September 17, 2015Inventors: Kaushal MITTAL, Mahendra Chavan, Kurt Wihelm Deschler, Steven A. Kirk