Patents by Inventor Rene QUAKKELAAR
Rene QUAKKELAAR 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).
-
Patent number: 11762861Abstract: Disclosed herein are system, method, and computer program product embodiments for generating a single transaction data stream from multiple database logs. An embodiment operates by assigning a first unique identifier to a first log entry associated with a disk store, a second unique identifier to a second log entry associated with in an in memory row store, and a third unique identifier to a third log entry based on the second unique identifier. The embodiment further operates by determining a first stream package based on the first log entry, a second stream package based on the third log entry, and a replay order for the first stream package and the second stream package based on the unique identifiers. In some embodiments, the operation further includes sending the first stream package and the second stream package to a replicant server in accordance with the replay order.Type: GrantFiled: June 21, 2021Date of Patent: September 19, 2023Assignee: SAP SEInventor: Rene Quakkelaar
-
Publication number: 20210311950Abstract: Disclosed herein are system, method, and computer program product embodiments for generating a single transaction data stream from multiple database logs. An embodiment operates by assigning a first unique identifier to a first log entry associated with a disk store, a second unique identifier to a second log entry associated with in an in memory row store, and a third unique identifier to a third log entry based on the second unique identifier. The embodiment further operates by determining a first stream package based on the first log entry, a second stream package based on the third log entry, and a replay order for the first stream package and the second stream package based on the unique identifiers. In some embodiments, the operation further includes sending the first stream package and the second stream package to a replicant server in accordance with the replay order.Type: ApplicationFiled: June 21, 2021Publication date: October 7, 2021Inventor: Rene Quakkelaar
-
Patent number: 11061909Abstract: Disclosed herein are system, method, and computer program product embodiments for generating a single transaction data stream from multiple database logs. An embodiment operates by assigning a first unique identifier to a first log entry associated with a disk store, a second unique identifier to a second log entry associated with in an in memory row store, and a third unique identifier to a third log entry based on the second unique identifier. The embodiment further operates by determining a first stream package based on the first log entry, a second stream package based on the third log entry, and a replay order for the first stream package and the second stream package based on the unique identifiers. In some embodiments, the operation further includes sending the first stream package and the second stream package to a replicant server in accordance with the replay order.Type: GrantFiled: July 19, 2018Date of Patent: July 13, 2021Assignee: SAP SEInventor: Rene Quakkelaar
-
Patent number: 10650026Abstract: Disclosed in some examples is a method of database replication, the method including at a Relational Database Management System (RDMS), determining a first replication mode; identifying a triggering event; determining that the triggering event indicates a change in the first replication mode; responsive to determining that the triggering event indicates a change in the first replication mode, determining a second replication mode, the second replication mode being a different replication mode than the first replication mode; identifying a database change made by one or more database tasks; and replicating the database change to an external replication component according to the second replication mode.Type: GrantFiled: September 29, 2017Date of Patent: May 12, 2020Assignee: SYBASE, INC.Inventors: Christopher H. Rank, Rene Quakkelaar, Elena Lora-Gallardo
-
Publication number: 20200026789Abstract: Disclosed herein are system, method, and computer program product embodiments for generating a single transaction data stream from multiple database logs. An embodiment operates by assigning a first unique identifier to a first log entry associated with a disk store, a second unique identifier to a second log entry associated with in an in memory row store, and a third unique identifier to a third log entry based on the second unique identifier. The embodiment further operates by determining a first stream package based on the first log entry, a second stream package based on the third log entry, and a replay order for the first stream package and the second stream package based on the unique identifiers. In some embodiments, the operation further includes sending the first stream package and the second stream package to a replicant server in accordance with the replay order.Type: ApplicationFiled: July 19, 2018Publication date: January 23, 2020Inventor: Rene QUAKKELAAR
-
Patent number: 10255341Abstract: Various embodiments of systems, computer program products, and methods to provide mode switching in high availability disaster recovery (HADR) systems are described herein. In an aspect, an average commit wait time associated with replicating data from a primary database to a replication database is determined based on a previous average commit wait time and a current commit wait time. A counter is incremented when the average commit wait time is greater than or equal to the predefined maximum commit wait time. Further, a check is made to determine whether the counter is greater than or equal to a predefined threshold and whether a predefined timer associated with the counter is expired. When the counter is greater than or equal to the predefined threshold and the predefined timer is running, the primary database is switched from a synchronous mode to an asynchronous mode for replicating the data.Type: GrantFiled: September 19, 2016Date of Patent: April 9, 2019Assignee: SAP SEInventors: Rene Quakkelaar, Elena I. Lora Gallardo
-
Publication number: 20180081931Abstract: Various embodiments of systems, computer program products, and methods to provide mode switching in high availability disaster recovery (HADR) systems are described herein. In an aspect, an average commit wait time associated with replicating data from a primary database to a replication database is determined based on a previous average commit wait time and a current commit wait time. A counter is incremented when the average commit wait time is greater than or equal to the predefined maximum commit wait time. Further, a check is made to determine whether the counter is greater than or equal to a predefined threshold and whether a predefined timer associated with the counter is expired. When the counter is greater than or equal to the predefined threshold and the predefined timer is running, the primary database is switched from a synchronous mode to an asynchronous mode for replicating the data.Type: ApplicationFiled: September 19, 2016Publication date: March 22, 2018Inventors: Rene Quakkelaar, Elena I. Lora Gallardo
-
Patent number: 9910733Abstract: Systems and methods are presented for completing transactions in a synchronous replication environment. In some embodiments, a computer-implemented method can include generating in a database server, an identifier to identify a database transaction. The method can also include transmitting the identifier to a replication server; receiving acknowledgement that the identifier is acknowledged by the replication server; storing the transaction in the database server; and executing the transaction after receiving acknowledgement from the replication server and after determining the transaction is stored in the database server; wherein transmitting the identifier to the replication server occurs in parallel with storing the transaction in the database server.Type: GrantFiled: July 28, 2014Date of Patent: March 6, 2018Assignee: SYBASE, INC.Inventors: Rene Quakkelaar, Elena Lora-Gallardo, Christopher H. Rank
-
Publication number: 20180025068Abstract: Disclosed in some examples is a method of database replication, the method including at a Relational Database Management System (RDMS), determining a first replication mode; identifying a triggering event; determining that the triggering event indicates a change in the first replication mode; responsive to determining that the triggering event indicates a change in the first replication mode, determining a second replication mode, the second replication mode being a different replication mode than the first replication mode; identifying a database change made by one or more database tasks; and replicating the database change to an external replication component according to the second replication mode.Type: ApplicationFiled: September 29, 2017Publication date: January 25, 2018Inventors: Christopher H. Rank, Rene Quakkelaar, Elena Lora-Gallardo
-
Patent number: 9836516Abstract: Log based replication using parallel scanners is described. An example method includes establishing replication paths from a primary database to a plurality of destination servers. A plurality of scanner threads are spawned to scan a transaction log of the primary database. Specifically, one scanner thread is assigned to each replication path corresponding to each destination server. For each scanner thread, data bound to a replication path associated with the scanner thread is selected from a subset of the transaction log. Accordingly, the data is distributed to a destination server associated with the replication path.Type: GrantFiled: February 3, 2014Date of Patent: December 5, 2017Assignee: SAP SEInventors: Rene Quakkelaar, Rene Siles, Elena Lora
-
Patent number: 9792346Abstract: Disclosed in some examples is a method of database replication, the method including at a Relational Database Management System (RDMS), determining a first replication mode; identifying a triggering event; determining that the triggering event indicates a change in the first replication mode; responsive to determining that the triggering event indicates a change in the first replication mode, determining a second replication mode, the second replication mode being a different replication mode than the first replication mode; identifying a database change made by one or more database tasks; and replicating the database change to an external replication component according to the second replication mode.Type: GrantFiled: August 19, 2014Date of Patent: October 17, 2017Assignee: SYBASE, INC.Inventors: Christopher H. Rank, Rene Quakkelaar, Elena Lora-Gallardo
-
Patent number: 9607068Abstract: Disclosed herein are system, method, and computer program product embodiments for replicating data in a distributed database system. Data containing a replicated truncation point associated with a replicating system is received via a data path. It can then be determined that the truncation point represents the point at which all data in a transaction log has been replicated (e.g., successfully or safely) and the transaction log can then be truncated at the truncation point (i.e., the data up to the truncation point deflected). Data containing an additional replicated truncation point associated with an additional replicating system via an additional data path may be received. It can then be determined that the additional replicated truncation point represents the point at which all data in the transaction log has been replicated and the transaction log can be then truncated at the additional replicated truncation point.Type: GrantFiled: December 11, 2013Date of Patent: March 28, 2017Assignee: SYBASE, INC.Inventors: Rene Quakkelaar, Martin Pieczonka, Elena Lora
-
Publication number: 20150379107Abstract: Disclosed in some examples is a method of database replication, the method including at a Relational Database Management System (RDMS), determining a first replication mode; identifying a triggering event; determining that the triggering event indicates a change in the first replication mode; responsive to determining that the triggering event indicates a change in the first replication mode, determining a second replication mode, the second replication mode being a different replication mode than the first replication mode; identifying a database change made by one or more database tasks; and replicating the database change to an external replication component according to the second replication mode.Type: ApplicationFiled: August 19, 2014Publication date: December 31, 2015Inventors: Christopher H. Rank, Rene Quakkelaar, Elena Lora-Gallardo
-
Publication number: 20150379105Abstract: Systems and methods are presented for completing transactions in a synchronous replication environment. In some embodiments, a computer-implemented method can include generating in a database server, an identifier to identify a database transaction. The method can also include transmitting the identifier to a replication server; receiving acknowledgement that the identifier is acknowledged by the replication server; storing the transaction in the database server; and executing the transaction after receiving acknowledgement from the replication server and after determining the transaction is stored in the database server; wherein transmitting the identifier to the replication server occurs in parallel with storing the transaction in the database server.Type: ApplicationFiled: July 28, 2014Publication date: December 31, 2015Inventors: Rene Quakkelaar, Elena Lora-GalIardo, Christopher H. Rank
-
Publication number: 20150112934Abstract: Log based replication using parallel scanners is described. An example method includes establishing replication paths from a primary database to a plurality of destination servers. A plurality of scanner threads are spawned to scan a transaction log of the primary database. Specifically, one scanner thread is assigned to each replication path corresponding to each destination server. For each scanner thread, data bound to a replication path associated with the scanner thread is selected from a subset of the transaction log. Accordingly, the data is distributed to a destination server associated with the replication path.Type: ApplicationFiled: February 3, 2014Publication date: April 23, 2015Inventors: Rene Quakkelaar, Rene Siles, Elena Lora
-
Publication number: 20150112929Abstract: Disclosed herein are system, method, and computer program product embodiments for replicating data in a distributed database system. Data containing a replicated truncation point associated with a replicating system is received via a data path. It can then be determined that the truncation point represents the point at which all data in a transaction log has been replicated (e.g., successfully or safely) and the transaction log can then be truncated at the truncation point (i.e., the data up to the truncation point deflected). Data containing an additional replicated truncation point associated with an additional replicating system via an additional data path may be received. It can then be determined that the additional replicated truncation point represents the point at which all data in the transaction log has been replicated and the transaction log can be then truncated at the additional replicated truncation point.Type: ApplicationFiled: December 11, 2013Publication date: April 23, 2015Inventors: Rene QUAKKELAAR, Martin Pieczonka, Elena Lora