Patents by Inventor Elizabeth B. Hamel
Elizabeth B. Hamel 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: 9652519Abstract: A mechanism is provided for handling transaction messages in asynchronous data replication in a database system, in which the database system includes a source node and a target node, and each transaction message has information concerning a row change to a table copy at the source node. The mechanism determines whether a first transaction message has a dependency on a preceding non-completed transaction message. Responsive to the first transaction message having a dependency on the preceding non-completed transaction, the mechanism holds the first transaction message, completes the preceding non-completed transaction message including applying the row change associated with the preceding non-completed transaction message to the table copy at the target node, and responsive to completing the preceding non-completed transaction message, and releases the first transaction message and applying the row change associated with the first transaction message to the table copy at the target node.Type: GrantFiled: December 22, 2015Date of Patent: May 16, 2017Assignee: International Business Machines CorporationInventors: Serge Bourbonnais, Elizabeth B. Hamel, Bruce G. Lindsay, Stephen J. Todd
-
Publication number: 20160210344Abstract: A mechanism is provided for handling transaction messages in asynchronous data replication in a database system, in which the database system includes a source node and a target node, and each transaction message has information concerning a row change to a table copy at the source node. The mechanism determines whether a first transaction message has a dependency on a preceding non-completed transaction message. Responsive to the first transaction message having a dependency on the preceding non-completed transaction, the mechanism holds the first transaction message, completes the preceding non-completed transaction message including applying the row change associated with the preceding non-completed transaction message to the table copy at the target node, and responsive to completing the preceding non-completed transaction message, and releases the first transaction message and applying the row change associated with the first transaction message to the table copy at the target node.Type: ApplicationFiled: December 22, 2015Publication date: July 21, 2016Inventors: Serge Bourbonnais, Elizabeth B. Hamel, Bruce G. Lindsay, Stephen J. Todd
-
Patent number: 9244996Abstract: A mechanism for handling transaction messages in asynchronous data replication in a database system, in which the database system includes a source node and a target node, and each transaction message has information concerning a row change to a table copy at the source node. The mechanism determines whether a first transaction message has a dependency on a preceding non-completed transaction message. Responsive to the first transaction message having a dependency on the preceding non-completed transaction, the mechanism holds the first transaction message, completes the preceding non-completed transaction message including applying the row change associated with the preceding non-completed transaction message to the table copy at the target node, and responsive to completing the preceding non-completed transaction message, releases the first transaction message and applying the row change associated with the first transaction message to the table copy at the target node.Type: GrantFiled: June 29, 2007Date of Patent: January 26, 2016Assignee: International Business Machines CorporationInventors: Serge Bourbonnais, Elizabeth B. Hamel, Bruce G. Lindsay, Stephen J. Todd
-
Patent number: 8688634Abstract: A method and system for providing convergence of data copies in asynchronous data replication in a database system, includes: labeling rows, a copy of identification and propagation controls. In applying communicated changes, conflicting changes are identified and resolved. In this manner, convergence of data copies in asynchronous data replication is provided, and processing and storage costs are significantly reduced.Type: GrantFiled: February 27, 2004Date of Patent: April 1, 2014Assignee: International Business Machines CorporationInventors: Kevin S. Beyer, Elizabeth B. Hamel, Bruce G. Lindsay, Clarence M. Pruet, III
-
Patent number: 8352425Abstract: A computer readable medium encoded with a computer program for handling transaction messages in asynchronous data replication in a database system is disclosed. The computer program provides a high speed parallel apply of transactional changes to a target node such that the parallel nature of the application of changes does not compromise the integrity of the data. The computer program detects, tracks, and handles dependencies between transaction messages to be applied to the target node. If a transaction message has a dependency on one or more preceding transaction messages whose applications have not yet completed, that transaction message is held until the application completes. In addition, the computer program requires significantly less overhead than conventional approaches.Type: GrantFiled: March 14, 2008Date of Patent: January 8, 2013Assignee: International Business Machines CorporationInventors: Serge Bourbonnais, Elizabeth B. Hamel, Bruce G. Lindsay, Stephen J. Todd
-
Patent number: 7979546Abstract: Database management systems, methods, and program products that exploit time dependent sequential database management system processes to ensure presentation of the same data or view to one or a plurality of users through sequencing asynchronous database management operations such as recovery and replication. Sequencing is accomplished through the use of entries in sequential logs, including transaction logs, recovery logs, and other data recovery tools and applications. Uses include managing data migration and data replication.Type: GrantFiled: April 15, 2008Date of Patent: July 12, 2011Assignee: International Business Machines CorporationInventors: Elizabeth B. Hamel, Bruce G. Lindsay
-
Patent number: 7953707Abstract: Database management systems and program products that exploit time dependent sequential database management system processes to ensure presentation of the same data or view to one or a plurality of users through sequencing asynchronous database management operations such as recovery and replication. Sequencing is accomplished through the use of entries in sequential logs, including transaction logs, recovery logs, and other data recovery tools and applications. Uses include managing data migration and data replication.Type: GrantFiled: April 15, 2008Date of Patent: May 31, 2011Assignee: International Business Machines CorporationInventors: Elizabeth B. Hamel, Bruce G. Lindsay
-
Patent number: 7490083Abstract: An improved method for providing parallel apply in asynchronous data replication in a database system is disclosed. The improved method and system provides a high speed parallel apply of transactional changes to a target node such that the parallel nature of the application of changes does not compromise the integrity of the data. The method and system detects, tracks, and handles dependencies between transaction messages to be applied to the target node. If a transaction message has a dependency on one or more preceding transaction messages whose applications have not yet completed, that transaction message is held until the application completes. In addition, the method and system requires significantly less overhead than conventional approaches.Type: GrantFiled: February 27, 2004Date of Patent: February 10, 2009Assignee: International Business Machines CorporationInventors: Serge Bourbonnais, Elizabeth B. Hamel, Bruce G. Lindsay, Stephen J. Todd
-
Patent number: 7426559Abstract: Database management methods that exploit time dependent sequential database management system processes to ensure presentation of the same data or view to one or a plurality of users through sequencing asynchronous database management operations such as recovery and replication. Sequencing is accomplished through the use of entries in sequential logs, including transaction logs, recovery logs, and other data recovery tools and applications. Uses include managing data migration and data replication.Type: GrantFiled: May 9, 2002Date of Patent: September 16, 2008Assignee: International Business Machines CorporationInventors: Elizabeth B. Hamel, Bruce G. Lindsay
-
Publication number: 20080195673Abstract: Database management systems, methods, and program products that exploit time dependent sequential database management system processes to ensure presentation of the same data or view to one or a plurality of users through sequencing asynchronous database management operations such as recovery and replication. Sequencing is accomplished through the use of entries in sequential logs, including transaction logs, recovery logs, and other data recovery tools and applications. Uses include managing data migration and data replication.Type: ApplicationFiled: April 15, 2008Publication date: August 14, 2008Applicant: International Business Machines CorporationInventors: Elizabeth B. Hamel, Bruce G. Lindsay
-
Publication number: 20080195672Abstract: Database management systems and program products that exploit time dependent sequential database management system processes to ensure presentation of the same data or view to one or a plurality of users through sequencing asynchronous database management operations such as recovery and replication. Sequencing is accomplished through the use of entries in sequential logs, including transaction logs, recovery logs, and other data recovery tools and applications. Uses include managing data migration and data replication.Type: ApplicationFiled: April 15, 2008Publication date: August 14, 2008Applicant: International Business Machines CorporationInventors: Elizabeth B. Hamel, Bruce G. Lindsay
-
Publication number: 20080163222Abstract: A computer readable medium encoded with a computer program for handling transaction messages in asynchronous data replication in a database system is disclosed. The computer program provides a high speed parallel apply of transactional changes to a target node such that the parallel nature of the application of changes does not compromise the integrity of the data. The computer program detects, tracks, and handles dependencies between transaction messages to be applied to the target node. If a transaction message has a dependency on one or more preceding transaction messages whose applications have not yet completed, that transaction message is held until the application completes. In addition, the computer program requires significantly less overhead than conventional approaches.Type: ApplicationFiled: March 14, 2008Publication date: July 3, 2008Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Serge BOURBONNAIS, Elizabeth B . Hamel, Bruce G. Lindsay, Stephen J. Todd
-
Patent number: 7330860Abstract: An automatic initial data load to a new table copy concurrently with active replication to existing table copies in an asynchronous replication group includes: initiating a data load of the new table copy; creating spill queue(s) at the new table copy; loading the data from a source table copy to the new table copy, where changes for the active table copies are applied during the loading, but changes to the new table copy are stored in a spill storage area; applying the changes in the spill storage area to the new table copy after the loading of the data is done; and removing the spill storage area after the changes have been applied to the new table copy. Thus, a new table copy is initialized into the replication group without requiring that replication be suspended at the source or any of the existing table copies during the initializing process.Type: GrantFiled: February 26, 2004Date of Patent: February 12, 2008Assignee: International Business Machines CorporationInventors: Nicolas G. Adiba, Serge Bourbonnais, Elizabeth B. Hamel, Somil Kulkarni, Bruce G. Lindsay
-
Patent number: 7240054Abstract: An improved method and system for preserving data constraints during parallel apply in asynchronous transaction replication in a database system have been disclosed. The method and system preserves secondary unique constraints and referential integrity constraints, while also allowing a high degree of parallelism in the application of asynchronous replication transactions. The method and system also detects and resolves ordering problems introduced by referential integrity cascade deletes, and allows the parallel initial loading of parent and child tables of a referential integrity constraint.Type: GrantFiled: February 27, 2004Date of Patent: July 3, 2007Assignee: International Business Machines CorporationInventors: Nicolas G. Adiba, Roberta J. Cochrane, Elizabeth B. Hamel, Somil D. Kulkarni, Bruce G. Lindsay
-
Patent number: 7203687Abstract: A method and system for member initialization to and deactivation from an asynchronous data replication group in a database system is disclosed. The method and system allows new members to be added to the replication group or existing members to be removed from the replication group, without requiring the halting of the asynchronous replication of data. The performance advantages of asynchronous replication are still realized during member initialization or deactivation.Type: GrantFiled: February 26, 2004Date of Patent: April 10, 2007Assignee: International Business Machines CorporationInventors: Nicolas G. Adiba, Jaime F. Anaya, Elizabeth B. Hamel, Yat On Lau, Siqun Li, Bruce G. Lindsay
-
Publication number: 20030212789Abstract: Database management systems, methods, and program products that exploit time dependent sequential database management system processes to insure presentation of the same data or view to one or a plurality of users through sequencing asynchronous database management operations such as recovery and replication. Sequencing is accomplished through the use of entries in sequential logs, including transaction logs, recovery logs, and other data recovery tools and applications. Uses include managing data migration and data replication.Type: ApplicationFiled: May 9, 2002Publication date: November 13, 2003Applicant: International Business Machines CorporationInventors: Elizabeth B. Hamel, Bruce G. Lindsay