Michael R Cross

US Patent:

20050149582, Jul 7, 2005

Filed:

Dec 29, 2003

Appl. No.:

10/748127

Inventors:

Joseph Wissmann - Chelmsford MA, US
Michael Cross - Portsmouth NH, US

International Classification:

G06F017/30

US Classification:

707201000

Abstract:

Disclosed is a lightweight database migration framework that allows schema definitions and incremental migrations to be pushed out to target local computers. The framework facilitates complex migrations by using either SQL script or programmatic migration methods to target local computers. Developers can download migration scripts from messages that are pushed to them, by electronic mail or otherwise, to synchronize their local database without the need to visit a central server. A base schema may be maintained via a set of incremental migration scripts, which generally correspond to milestone releases. In some embodiments, the scripts are specified via an XML document. The framework deduces a target database's schema version and automatically applies the necessary migration path to reach a target schema version. There is no need to visit a central server. Thus, there is no need to manage and maintain centralized server. Also, the migration scripts can be SQL scripts or code that executes complex data manipulation. The system encodes version histories by storing the migration scripts in a history folder, and facilitates the creation and migration to an earlier arbitrary schema version by reversing the operations performed using migration scripts executed after the arbitrary schema was created.

US Patent:

20080162427, Jul 3, 2008

Filed:

Dec 28, 2006

Appl. No.:

11/617558

Inventors:

Colleen S. Connearney - Arlington MA, US
Michael W. Cross - Portsmouth NH, US
John R. McGarvey - Apex NC, US
Christopher R. Seekamp - Boca Raton FL, US
Ajamu Wesley - Marlborough MA, US

Assignee:

INTERNATIONAL BUSINESS MACHINES CORPORATION - Armonk NY

International Classification:

G06F 17/30
G06F 7/00

US Classification:

707 3, 707 2, 707E17045

Abstract:

A method of data storage and retrieval using a relational database can include defining a first table in a relational database including a plurality of entries having a first value for a first field. A second table in the relational database including a plurality of entries can be defined. Each of the plurality of entries in the second table can specify an additional value for the first field of a corresponding entry in the first table. Responsive to a query, a data item selected from at least one of the plurality of entries in the first table can be presented.