Elizabeth Belva Hamel

US Patent:

7203687, Apr 10, 2007

Filed:

Feb 26, 2004

Appl. No.:

10/789656

Inventors:

Nicolas G. Adiba - San Jose CA, US
Jaime F. Anaya - San Jose CA, US
Elizabeth B. Hamel - Morgan Hill CA, US
Yat On Lau - San Jose CA, US
Siqun Li - San Jose CA, US
Bruce G. Lindsay - San Jose CA, US

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 17/00
G06F 7/00

US Classification:

707100, 707202, 707204, 709201

Abstract:

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.

US Patent:

7240054, Jul 3, 2007

Filed:

Feb 27, 2004

Appl. No.:

10/788651

Inventors:

Nicolas G. Adiba - San Jose CA, US
Roberta J. Cochrane - Los Gatos CA, US
Elizabeth B. Hamel - Morgan Hill CA, US
Somil D. Kulkarni - San Jose CA, US
Bruce G. Lindsay - San Jose CA, US

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 17/30

US Classification:

707 4

Abstract:

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.

US Patent:

7330860, Feb 12, 2008

Filed:

Feb 26, 2004

Appl. No.:

10/789326

Inventors:

Nicolas G. Adiba - San Jose CA, US
Serge Bourbonnais - Palo Alto CA, US
Elizabeth B. Hamel - Morgan Hill CA, US
Somil Kulkarni - San Jose CA, US
Bruce G. Lindsay - San Jose CA, US

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 12/00
G06F 17/30

US Classification:

707204, 707202

Abstract:

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.

US Patent:

7418441, Aug 26, 2008

Filed:

Jul 24, 2001

Appl. No.:

09/912586

Inventors:

Elizabeth Belva Hamel - Morgan Hill CA, US
Michael T. Ho - Willowdale, CA
James C. Kleewein - San Jose CA, US
Mark Donald Leitch - Ajax, CA
Sam Sampson Lightstone - Toronto, CA
James Alan Ruddy - Gilroy CA, US

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 17/30

US Classification:

707 3, 707 4, 707 5, 707 10, 707100, 709200, 709201, 709203

Abstract:

A method, apparatus and article of manufacture is provided for loading data from a remote data source record by record, in a computer system network connecting a source site and a target site via a database connection communication line. The source site has at least one data source and a Distributed Relational Database Architecture (DRDA) software server having multi-database access to DBMSs. The target site requests data loading from the source site DRDA via a block of Structured Query Language (SQL) statements. Data are transported record by record via the database connection communication line according to the DRDA communication protocol, wherein the target site loads records concurrently with the unloading of records in the source site. The data loading may also be performed in a pipeline manner, loading data records in multiple partitions with a plurality of parallel streams, pointed to by a plurality of data source partition cursors.

US Patent:

7426559, Sep 16, 2008

Filed:

May 9, 2002

Appl. No.:

10/143317

Inventors:

Elizabeth B. Hamel - Morgan Hill CA, US
Bruce G. Lindsay - San Jose CA, US

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 7/00
G06F 17/30

US Classification:

709225, 707200, 700 2, 700 10, 700200

Abstract:

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.

US Patent:

7490083, Feb 10, 2009

Filed:

Feb 27, 2004

Appl. No.:

10/789775

Inventors:

Serge Bourbonnais - Palo Alto CA, US
Elizabeth B. Hamel - Morgan Hill CA, US
Bruce G. Lindsay - San Jose CA, US
Stephen J. Todd - Winchester, GB

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G07F 17/30
G06F 15/16

US Classification:

707 8, 718101, 719313

Abstract:

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.

US Patent:

7953707, May 31, 2011

Filed:

Apr 15, 2008

Appl. No.:

12/103538

Inventors:

Elizabeth B. Hamel - Morgan Hill CA, US
Bruce G. Lindsay - San Jose CA, US

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 7/00
G06F 17/00

US Classification:

707674, 707626, 707634, 707640, 707648, 707672

Abstract:

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.

US Patent:

7979546, Jul 12, 2011

Filed:

Apr 15, 2008

Appl. No.:

12/103548

Inventors:

Elizabeth B. Hamel - Morgan Hill CA, US
Bruce G. Lindsay - San Jose CA, US

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 17/30

US Classification:

709225, 709235, 709203, 709245, 709224, 709220, 709217, 709218, 709219, 370230, 370235, 370352, 370299, 714 15, 714 20, 714 13

Abstract:

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.