Method and apparatus for database change management

• US 20070112886A1
• Filed: 11/14/2005
• Published: 05/17/2007
• Est. Priority Date: 11/14/2005
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Ramachandran, Jayashree, Huang, Hsin-Liang, Langworthy, Donald, Ruggles, Jeffrey
• Granted Patent: US 7,840,603 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• 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:

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

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

making changes to a target model using the data structure to form a resulting model.

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.

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 a 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.

9. The computer implemented method of claim 1, wherein the element further identifies a new value for the structural database entity.

10. The computer implemented method of claim 1, wherein the target model is at least a portion of a database.

11. A computer program product comprising:

a computer usable medium having computer usable program code 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 to form a resulting model.

12. The computer program product of claim 11, 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.

13. The computer program product of claim 11, 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.

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

computer usable program code for determining whether a 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.

15. The computer program product of claim 11, 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.

16. The computer program product of claim 15 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.

17. The computer program product of claim 11, 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.

18. The computer program product of claim 11, wherein the data structure is a delta definition structure.

19. The computer program product of claim 11, wherein the element further identifies a new value for the structural database entity.

20. The computer program product of claim 11, wherein the target model is at least a portion of a database.

21. 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 to form a resulting model.

22. The data processing system of claim 21, 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.

23. The data processing system of claim 21, 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.

24. The data processing system of claim 23, 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 a 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.

25. The data processing system of claim 21, 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.

26. The data processing system of claim 25, 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.

27. The data processing system of claim 21, 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.

28. The data processing system of claim 21, wherein the data structure is a delta definition structure.

29. The data processing system of claim 21, wherein the element further identifies a new value for the structural database entity.

30. The data processing system of claim 21, wherein the target model is at least a portion of a database.