Method and apparatus for database change management

• US 7,840,603 B2
• Filed: 11/14/2005
• Issued: 11/23/2010
• Est. Priority Date: 11/14/2005
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Ruggles, Jeffrey Ralph, Langworthy, Donald B., Ramachandran, Jayashree, Huang, Hsin-Liang
• Primary Examiner(s): Ehichioya; Fred I
• Application Number:
  US11/272,933
• Publication Number:
  US 20070112886A1
• Time in Patent Office: 1,835 Days
• Field of Search: 707/609, 707/705, 707/791, 707/802, 707/999.104, 707/999.203, 707/E17.005, 703/22
• US Class Current: 707/802
• CPC Class Codes: G06F 16/2379 Updates performed during online database operations; commit processing
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

A computer implemented method, apparatus, and computer usable program code to compare a base model to a desired model to identify changes needed to form the desired model. The changes are placed in a data structure containing a set of elements, wherein the set of elements identify a set of structural database entities and a set of changes to the set of structural database entities. Changes are made to a target model using the data structure to form a resulting model.

Claims

1. A computer implemented method for making changes to a database, the computer implemented method comprising steps performed by a computer of:

the computer comparing a base model to a desired model to identify changes needed to form the desired model;

the computer placing the changes in a data structure containing a set of elements, wherein the set of elements identify a set of structural database entities and a set of changes to the set of structural database entities; and

the computer making changes to a target model using the data structure and a rule to form a resulting model, wherein the target model is at least a portion of the database, and wherein the rule alters certain change operations specified by the data structure.

2. The computer implemented method of claim 1, wherein a change in the set of changes is selected from one of, modify a structural database entity, create the structural database entity, or drop the structural database entity, wherein the base model is a representation of at least a portion of a preexisting database and the desired model is a representation of at least another portion of the preexisting database.

3. The computer implemented method of claim 1, wherein the set of elements are in an order for processing and wherein the making step comprises:

selecting an unprocessed element from the set of elements using the order for processing;

locating a structural database entity identified by the unprocessed element in the target model to form a located structural database entity; and

applying a change to the located structural database entity.

4. The computer implemented method of claim 3, wherein the applying step comprises:

determining whether the rule applies to the located structural database entity; and

applying the identified change to the located structural database entity subject to the rule if the rule applies.

5. The computer implemented method of claim 1, wherein the making step comprises:

selecting an unprocessed element from the set of elements;

determining whether an identified change in the unprocessed element can be applied to an identified structural database entity; and

generating an error if the identified change cannot be applied to the identified structural database entity.

6. The computer implemented method of claim 5 further comprising:

presenting errors generated in forming the resulting model; and

providing options to correct the errors generated in forming the resulting model.

7. The computer implemented method of claim 1, wherein the comparing step comprises:

mapping a base structural database entity in the base model to a desired structural database entity in the desired model; and

identifying a change needed to form the desired structural database entity in the desired model.

8. The computer implemented method of claim 1, wherein the data structure is a delta definition structure, and wherein each element of the set of elements includes (i) a reference to a structural database entity within a database model, (ii) an operation identifier which identifies an operation to be performed on the structural database entity defined by the reference, and (iii) a new value to be applied to the structural database entity defined by the reference.

9. A computer program product comprising:

a computer readable storage medium having computer usable program code encoded therein for making changes to a database, the computer program product comprising;

computer usable program code for comparing a base model to a desired model to identify changes needed to form the desired model;

computer usable program code for placing the changes in a data structure containing a set of elements, wherein the set of elements identify a set of structural database entities and a set of changes to the set of structural database entities; and

computer usable program code for making changes to a target model using the data structure and a rule to form a resulting model, wherein the target model is at least a portion of the database, and wherein the rule alters certain change operations specified by the data structure.

10. The computer program product of claim 9, wherein a change in the set of changes is selected from one of, modify a structural database entity, create the structural database entity, or drop the structural database entity, wherein the base model is a representation of at least a portion of a preexisting database and the desired model is a representation of at least another portion of the preexisting database.

11. The computer program product of claim 9, wherein the set of elements are in an order for processing, and wherein the computer usable program code for making changes to a target model using the data structure to form a resulting model comprises:

computer usable program code for selecting an unprocessed element from the set of elements using the order for processing;

computer usable program code for locating a structural database entity identified by the unprocessed element in the target model to form a located structural database entity; and

computer usable program code for applying a change to the located structural database entity.

12. The computer program product of claim 11, wherein the computer usable program code for applying a change to the located structural database entity comprises:

computer usable program code for determining whether the rule applies to the located structural database entity; and

computer usable program code for applying the identified change to the located structural database entity subject to the rule if the rule applies.

13. The computer program product of claim 9, wherein the computer usable program code for making changes to a target model using the data structure to form a resulting model comprises:

computer usable program code for selecting an unprocessed element from the set of elements;

computer usable program code for determining whether an identified change in the unprocessed element can be applied to an identified structural database entity; and

computer usable program code for generating an error if the identified change cannot be applied to the identified structural database entity.

14. The computer program product of claim 13 further comprising:

computer usable program code for presenting errors generated in forming the resulting model; and

computer usable program code for providing options to correct the errors generated in forming the resulting model.

15. The computer program product of claim 9, wherein the computer usable program code for comparing a base model to a desired model to identify changes needed to form the desired model comprises:

computer usable program code for mapping a base structural database entity in the base model to a desired structural database entity in the desired model; and

computer usable program code for identifying a change needed to form the desired structural database entity in the desired model.

16. The computer program product of claim 9, wherein the data structure is a delta definition structure, and wherein each element of the set of elements includes (i) a reference to a structural database entity within a database model, (ii) an operation identifier which identifies an operation to be performed on the structural database entity defined by the reference, and (iii) a new value to be applied to the structural database entity defined by the reference.

17. A data processing system comprising:

a bus;

a communications unit connected to the bus;

a storage device connected to the bus, wherein the storage device includes computer usable program code; and

a processor unit connected to the bus, wherein the processor unit executes the computer usable program code to compare a base model to a desired model to identify changes needed to form the desired model;

place the changes in a data structure containing a set of elements, wherein the set of elements identify a set of structural database entities and a set of changes to the set of structural database entities; and

make changes to a target model using the data structure and a rule to form a resulting model, wherein the target model is at least a portion of the database, and wherein the rule alters certain change operations specified by the data structure.

18. The data processing system of claim 17, wherein a change in the set of changes is selected from one of, modify a structural database entity, create the structural database entity, or drop the structural database entity, wherein the base model is a representation of at least a portion of a preexisting database and the desired model is a representation of at least another portion of the preexisting database.

19. The data processing system of claim 17, wherein the elements are in an order for processing and wherein in executing the computer usable program code to make changes to a target model using the data structure to form a resulting model, the processor unit further executes the computer usable program code to select an unprocessed element from the set of elements using the order for processing;

locate a structural database entity identified by the unprocessed element in the target model to form a located structural database entity; and

apply a change to the located structural database entity.

20. The data processing system of claim 19, wherein in executing the computer usable program code to make changes to the located structural database entity, the processor unit further executes the computer usable program code to determine whether the rule applies to the located structural database entity;

and apply the identified change to the located structural database entity subject to the rule if the rule applies.

21. The data processing system of claim 17, wherein in executing the computer usable program code to make changes to a target model using the data structure to form a resulting model, the processor unit further executes the computer usable program code to select an unprocessed element from the set of elements;

determine whether an identified change in the unprocessed element can be applied to an identified structural database entity; and

generate an error if the identified change cannot be applied to the identified structural database entity.

22. The data processing system of claim 21, wherein the processor unit further executes the computer usable program code to present errors generated in forming the resulting model;

and provide options to correct the errors generated in forming the resulting model.

23. The data processing system of claim 17, wherein the processor unit further executes the computer usable program code to map a base structural database entity in the base model to a desired structural database entity in the desired model;

and identify a change needed to form the desired structural database entity in the desired model.

24. The data processing system of claim 17, wherein the data structure is a delta definition structure, and wherein each element of the set of elements includes (i) a reference to a structural database entity within a database model, (ii) an operation identifier which identifies an operation to be performed on the structural database entity defined by the reference, and (iii) a new value to be applied to the structural database entity defined by the reference.