Patents by Inventor Elena Lora
Elena Lora 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: 11650889Abstract: A method for reliable data synchronization within a network is disclosed. The producer system stories data in a persistent data store and produces one or more data updates. The producer system simultaneously transmits the data updates to a consumer system and initiating storage of the data updates at the producer system. When storage of the data updates at the producer system is complete, the producer system transmits a first acknowledgment to the consumer system. The producer system determines whether a second acknowledgment has been received from the consumer system, wherein the second acknowledgment indicates that the consumer system has successfully stored the data updates at the consumer system. In accordance with a determination that the second acknowledgment has been received from the consumer system, the producer system changes the temporary status of the data updates stored at the producer system to a permanent status.Type: GrantFiled: August 20, 2019Date of Patent: May 16, 2023Assignee: SYBASE, INC.Inventors: Heping Shang, Ming-Chen Lo, Elena Lora-Gallardo, Xia-ge Dai
-
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: 20190391885Abstract: A method for reliable data synchronization within a network is disclosed. The producer system stories data in a persistent data store and produces one or more data updates. The producer system simultaneously transmits the data updates to a consumer system and initiating storage of the data updates at the producer system. When storage of the data updates at the producer system is complete, the producer system transmits a first acknowledgment to the consumer system. The producer system determines whether a second acknowledgment has been received from the consumer system, wherein the second acknowledgment indicates that the consumer system has successfully stored the data updates at the consumer system. In accordance with a determination that the second acknowledgment has been received from the consumer system, the producer system changes the temporary status of the data updates stored at the producer system to a permanent status.Type: ApplicationFiled: August 20, 2019Publication date: December 26, 2019Inventors: Heping Shang, Ming-Chen Lo, Elena Lora-Gallardo, Xia-ge Dai
-
Patent number: 10423498Abstract: A method for reliable data synchronization within a network is disclosed. The producer system stories data in a persistent data store and produces one or more data updates. The producer system simultaneously transmits the data updates to a consumer system and initiating storage of the data updates at the producer system. When storage of the data updates at the producer system is complete, the producer system transmits a first acknowledgment to the consumer system. The producer system determines whether a second acknowledgment has been received from the consumer system, wherein the second acknowledgment indicates that the consumer system has successfully stored the data updates at the consumer system. In accordance with a determination that the second acknowledgment has been received from the consumer system, the producer system changes the temporary status of the data updates stored at the producer system to a permanent status.Type: GrantFiled: July 29, 2014Date of Patent: September 24, 2019Assignee: SYBASE, INC.Inventors: Heping Shang, Ming-Chen Lo, Elena Lora-Gallardo, Xia-ge Dai
-
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: 20150378845Abstract: A method for reliable data synchronization within a network is disclosed. The producer system stories data in a persistent data store and produces one or more data updates. The producer system simultaneously transmits the data updates to a consumer system and initiating storage of the data updates at the producer system. When storage of the data updates at the producer system is complete, the producer system transmits a first acknowledgment to the consumer system. The producer system determines whether a second acknowledgment has been received from the consumer system, wherein the second acknowledgment indicates that the consumer system has successfully stored the data updates at the consumer system. In accordance with a determination that the second acknowledgment has been received from the consumer system, the producer system changes the temporary status of the data updates stored at the producer system to a permanent status.Type: ApplicationFiled: July 29, 2014Publication date: December 31, 2015Inventors: Heping Shang, Ming-Chen Lo, Elena Lora-Gallardo, Xia-ge Dai
-
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: 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: 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
-
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
-
Patent number: 8751441Abstract: A system, method, and computer program product are provided for replicating a table in a source database to a target database. In accordance with an embodiment of the present invention, a subscription to the table is defined and a query is executed on the source database. The query is then normalized, and it is determined whether the query would cause semantically appropriate changes to the target database. If so, the normalized query is sent to the target database for execution, in accordance with an additional embodiment of the present invention.Type: GrantFiled: July 31, 2008Date of Patent: June 10, 2014Assignee: Sybase, Inc.Inventors: Heping Shang, Elena Lora-Gallardo, Andrzej Sarapuk
-
Publication number: 20100030730Abstract: A system, method, and computer program product are provided for replicating a table in a source database to a target database. In accordance with an embodiment of the present invention, a subscription to the table is defined and a query is executed on the source database. The query is then normalized, and it is determined whether the query would cause semantically appropriate changes to the target database. If so, the normalized query is sent to the target database for execution, in accordance with an additional embodiment of the present invention.Type: ApplicationFiled: July 31, 2008Publication date: February 4, 2010Applicant: Sybase, Inc.Inventors: Heping Shang, Elena Lora-Gallardo, Andrzej Sarapuk
-
Publication number: 20070162421Abstract: A SQL language interface for a messaging system, such as IBM MQ, is described. In one embodiment, for example, in a database system, a method is described for providing real-time message support for improved database connectivity, the method comprises steps of: defining Structured Query Language (SQL) extensions having commands that provide message-based connectivity for databases; receiving an SQL statement including a command specifying that a message be sent for communicating particular database data; upon execution of the SQL statement by the database system, creating an outbound message for communicating the particular database data to a destination; and posting the outbound database to a message bus, whereupon the particular database data is communicated asynchronously to the destination.Type: ApplicationFiled: January 12, 2006Publication date: July 12, 2007Applicant: SYBASE, INC.Inventors: Francis Pang, Olwen Tam, Kannan Ananthanarayanan, Elena Lora-Gallardo