Patents by Inventor Elena Isabel LORA-GALLARDO
Elena Isabel LORA-GALLARDO 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: 9047354Abstract: Systems, methods and computer program products for statement categorization and normalization are described herein. An embodiment includes a statement categorizer and a statement normalizer. The statement categorizer categorizes statements to reduce or even eliminate inconsistencies that may arise between primary and replicate databases as a result of executing certain statements. Categorized statements are normalized by the statement normalizer to generate normalized statements, which are provided to a replication server. Normalized statements assist replication server to regenerate a statement to be executed on a replicate database.Type: GrantFiled: July 31, 2008Date of Patent: June 2, 2015Assignee: Sybase, Inc.Inventors: Heping Shang, Andrzej Sarapuk, Elena Isabel Lora-Gallardo
-
Publication number: 20150046400Abstract: Systems, methods and computer program products for multi-path replication in databases are described herein. A non-limiting embodiment includes instantiating a plurality of replicate connections to a replicate database, providing transactions to the replicate database through a plurality of transaction streams, where the transaction streams associated with respective instantiated replicate connections. Transactions occurring in distinct transaction streams are applied, in parallel, at the replicate database. Another non-limiting embodiment includes instantiating a plurality of replication sender threads, where the replication sender threads communicate in parallel with respective replication servers over respective replication paths. Data sharing one or more attributes can be bound to a replication path in communication with the respective replication servers.Type: ApplicationFiled: October 24, 2014Publication date: February 12, 2015Inventors: Christopher Hugh RANK, Martin Stanley Pieczonka, Shuying Yu, Rene Eduard Alexander Quakkelaar, Elena Isabel Lora Gallardo
-
Patent number: 8892514Abstract: Systems, methods and computer program products for multi-path replication in databases are described herein. A non-limiting embodiment includes instantiating a plurality of replicate connections to a replicate database, providing transactions to the replicate database through a plurality of transaction streams, where the transaction streams associated with respective instantiated replicate connections. Transactions occurring in distinct transaction streams are applied, in parallel, at the replicate database. Another non-limiting embodiment includes instantiating a plurality of replication sender threads, where the replication sender threads communicate in parallel with respective replication servers over respective replication paths. Data sharing one or more attributes can be bound to a replication path in communication with the respective replication servers.Type: GrantFiled: September 14, 2012Date of Patent: November 18, 2014Assignee: Sybase, Inc.Inventors: Christopher Hugh Rank, Martin Stanley Pieczonka, Shuying Yu, Rene Eduard Alexander Quakkelaar, Elena Isabel Lora Gallardo
-
Patent number: 8676749Abstract: System, method, computer program product embodiments and combinations and sub-combinations thereof for logging of data manipulation language (DML) statements are described herein. An embodiment includes a database engine, a replication agent and a replication server which replicates data from the database engine to one or more replicate databases. The database engine writes parsed query information into a transaction log so that a process of replication agent may read the parsed query information and forward it to the replication server. The database engine writes all log records associated with a statement in a manner that allows the replication server to distinguish if those log records belong to same statement. In another embodiment, replication agent selectively sends SQL statement information to the replication server based on the replication server architecture.Type: GrantFiled: July 31, 2008Date of Patent: March 18, 2014Assignee: Sybase, Inc.Inventors: Heping Shang, Elena Isabel Lora-Gallardo, Andrzej Sarapuk
-
Publication number: 20130124464Abstract: Systems, methods and computer program products for multi-path replication in databases are described herein. A non-limiting embodiment includes instantiating a plurality of replicate connections to a replicate database, providing transactions to the replicate database through a plurality of transaction streams, where the transaction streams associated with respective instantiated replicate connections. Transactions occurring in distinct transaction streams are applied, in parallel, at the replicate database. Another non-limiting embodiment includes instantiating a plurality of replication sender threads, where the replication sender threads communicate in parallel with respective replication servers over respective replication paths. Data sharing one or more attributes can be bound to a replication path in communication with the respective replication servers.Type: ApplicationFiled: September 14, 2012Publication date: May 16, 2013Applicant: Sybase, Inc.Inventors: Christopher Hugh Rank, Martin Stanley Pieczonka, Shuying Yu, Rene Eduard Alexander Quakkelaar, Elena Isabel Lora Gallardo
-
Publication number: 20100030824Abstract: System, method, computer program product embodiments and combinations and sub-combinations thereof for logging of data manipulation language (DML) statements are described herein. An embodiment includes a database engine, a replication agent and a replication server which replicates data from the database engine to one or more replicate databases. The database engine writes parsed query information into a transaction log so that a process of replication agent may read the parsed query information and forward it to the replication server. The database engine writes all log records associated with a statement in a manner that allows the replication server to distinguish if those log records belong to same statement. In another embodiment, replication agent selectively sends SQL statement information to the replication server based on the replication server architecture.Type: ApplicationFiled: July 31, 2008Publication date: February 4, 2010Applicant: Sybase, Inc.Inventors: Heping SHANG, Elena Isabel LORA-GALLARDO, Andrzej SARAPUK
-
Publication number: 20100030817Abstract: Systems, methods and computer program products for statement categorization and normalization are described herein. An embodiment includes a statement categorizer and a statement normalizer. The statement categorizer categorizes statements to reduce or even eliminate inconsistencies that may arise between primary and replicate databases as a result of executing certain statements. Categorized statements are normalized by the statement normalizer to generate normalized statements, which are provided to a replication server. Normalized statements assist replication server to regenerate a statement to be executed on a replicate database.Type: ApplicationFiled: July 31, 2008Publication date: February 4, 2010Applicant: Sybase, IncInventors: Heping SHANG, Andrzej SARAPUK, Elena Isabel LORA-GALLARDO