US 2006/0136471 A1 · Differential management of database schema changes

Abstract

A data processing system-implemented method, system and article of manufacture for differential schema migration. A differential schema migration system can include a schema extractor configured both to extract a contemporary schema and corresponding contemporary data from a first connected database and also to generate an intermediately formatted form of the contemporary schema and corresponding contemporary data. The system also can include a schema update user interface configured to facilitate applying changes to the intermediately formatted form of the contemporary schema and corresponding contemporary data. Finally, the system can include a schema differential migrator configured to apply changes to a second connected database based upon a comparison of an extracted schema and corresponding data from the second connected database, and a changed version of the intermediately formatted form of the contemporary schema and corresponding contemporary data.

Claims20

Dependent claims

A data processing system for differential schema migration, the data processing system comprising:

a schema extractor configured both to extract a contemporary schema and corresponding contemporary data from a first connected database and also to generate an intermediately formatted form of said contemporary schema and corresponding contemporary data;
a schema update user interface configured to facilitate applying changes to said intermediately formatted form of said contemporary schema and corresponding contemporary data;
and,
a schema differential migrator configured to apply changes to a second connected database based upon a comparison of an extracted schema and corresponding data from said second connected database, and a changed version of said intermediately formatted form of said contemporary schema and corresponding contemporary data.

1 more element

A data processing system implemented method for performing differential schema migration, the data processing system implemented method comprising:

comparing an intermediately formatted schema and corresponding data to a contemporary schema and corresponding contemporary data in a database to determine differences between both said intermediately formatted schema and said contemporary schema in said database, and also said intermediately formatted corresponding data and said contemporary data in said database;
and,
applying said differences to said database.

An article of manufacture for directing a data processing system to perform differential schema migration, the article of manufacture comprising:

a computer usable medium embodying one or more instructions executable by the data processing system, the one or more instructions comprising:
data processing system executable instructions for comparing an intermediately formatted schema and corresponding data to a contemporary schema and corresponding contemporary data in a database to determine differences between both said intermediately formatted schema and said contemporary schema in said database, and also said intermediately formatted corresponding data and said contemporary data in said database;
and,
data processing system executable instructions for applying said differences to said database.

1 more element

Dependencies are inferred from the claim text.

Differential management of database schema changes

Life of this patent

Differential management of database schema changes

Life of this patent

Abstract

Claims20