Method, system, and product for maintaining software objects during database upgrade

• US 7,310,653 B2
• Filed: 03/28/2002
• Issued: 12/18/2007
• Est. Priority Date: 04/02/2001
• Status: Expired due to Term

• Current Assignee: Siebel Systems Inc. (Oracle Corporation)
• Original Assignee: Siebel Systems Inc. (Oracle Corporation)
• Inventors: Coyle, Mark, Lim, Peter, Huang, Shuang
• Primary Examiner(s): Le, Debbie M
• Application Number:
  US10/113,848
• Publication Number:
  US 20070220065A1
• Time in Patent Office: 2,091 Days
• Field of Search: 707200-205, 707/8, 717/170, 717/168
• US Class Current: 1/1
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: Y10S 707/99954 Version management

Abstract

Techniques to support modification of certain data in a database during an upgrade to a new version. In one method, objects in an original database are marked as either modifiable or read-only, with changes being allowed for modifiable objects during the upgrade. An upgraded database of objects is generated based on objects in the original database (e.g., by copying objects in the original database and upgrading the copied objects to new schema and binaries). Changes to modifiable objects in the original database (e.g., after these objects have been copied) are logged. After the upgraded database has been created, objects in this database may be updated (e.g., individually or all at once) by identifying modifiable objects in the original database having changes not yet incorporated into the upgraded database and updating objects in the upgraded database based on the modified objects in the original database.

Claims

1. A computer program product for upgrading a database of objects, comprising a computer-usable medium having embodied therein computer-readable program codes for

marking objects in a first database as either modifiable or read-only using a corresponding field in the respective objects, wherein modifiable objects are allowed to be changed during upgrade of the first database, and wherein read-only objects are not allowed to be changed during upgrade of the first database;

creating a corresponding integration object for each modifiable object in the first database, wherein each integration object comprises at least those object fields that are allowed to be modified in the corresponding modifiable object, and wherein each integration object is independent of a software vendor-supplied type of the corresponding modifiable object;

generating a second database of objects based on objects in the first database;

sending a copy of each modifiable object in the first database to the second database;

creating in said first database a first snapshot of a first integration object whose corresponding first modifiable object in said first database is to be modified after generation of said second database;

sending said first snapshot to said second database;

creating in said first database a second snapshot of said first integration object after said first modifiable object has been changed from a version used to generate the second database;

sending said second snapshot to said second database;

determining a first delta snapshot at said second database identifying differences between said first and said second snapshots; and

updating the copy of said first modifiable object in the second database based on the first delta snapshot.

2. The computer program product of claim 1, wherein the computer-usable medium is further embodied with computer-readable program codes for maintaining a first table containing snapshots of integration objects corresponding to those modifiable objects that have been used to generate corresponding objects in the second database.

3. The computer program product of claim 2, wherein the computer-usable medium is further embodied with computer-readable program codes for maintaining a second table for snapshots of integration objects corresponding to modified objects in the first database not yet sent to the second database.

4. The computer program product of claim 1, wherein each of the first and the second snapshots is an XML document.

5. The computer program product of claim 1, wherein the computer-usable medium is further embodied with computer-readable program codes for

receiving a request for a latest version of a particular modifiable object in the first database;

and

sending the latest version of the requested object to the second database using a third snapshot of a second integration object corresponding to said requested object.

6. The computer program product of claim 5, wherein the third snapshot includes only changes to the requested object since an immediately prior version of the requested object sent to the second database.

7. The computer program product of claim 5, wherein the latest version of the requested modifiable object is sent only if there has been changes since a prior sent version.

8. The computer program product of claim 5, wherein the computer-usable medium is further embodied with computer-readable program codes for updating an object in the second database corresponding to the requested object based on the third snapshot.

9. The computer program product of claim 8, wherein the computer-usable medium is further embodied with computer-readable program codes for

determining a second delta snapshot as a difference between the third snapshot and a fourth snapshot of a most current version of the requested object in the second database, and

wherein the object in the second database corresponding to the requested object is updated based on the second delta snapshot.

10. The computer program product of claim 5, wherein the computer-usable medium is further embodied with computer-readable program codes for:

storing said third snapshot in the first database.

11. The computer program product of claim 1, wherein the computer-readable program codes for updating further include program codes for

identifying modifiable objects in the first database having changes not yet sent to the second database,

sending changes in the modifiable objects in the first database to the second database using snapshots of corresponding integration objects, and

updating objects in the second database based on the snapshots of the corresponding modifiable objects in the first database.

12. The computer program product of claim 1, wherein the computer-readable program codes for generating the second database include program codes for

copying objects in the first database, and

upgrading the copied objects to generate the objects in the second database.

17. The computer program product of claim 1, wherein the computer-usable medium is further embodied with computer-readable program codes for maintaining a first table to identify modifiable objects in the first database.

18. The computer program product of claim 1, wherein the computer-usable medium is further embodied with computer-readable program codes for replicating changes made to said first modifiable object to said first integration object, so as to make said first integration object a copy of said first modifiable object.

19. The computer program product of claim 1, wherein the computer-usable medium is further embodied with computer-readable program codes for identifying whether each object in the second database corresponds to a modifiable object or a read-only object in the first database.

20. The computer program product of claim 4, wherein the computer-usable medium is further embodied with computer-readable program codes for converting, at said second database, said XML representations of said first and said second snapshots into a hierarchical data representation prior to determining said first delta snapshot.

21. The computer program product of claim 1, wherein said first database and said second database are part of a single computer system.

13. In a computer system, a method for upgrading a database of objects, comprising:

marking objects in a first database as either modifiable or read-only using a corresponding field in the respective object, wherein modifiable objects are allowed to be changed during upgrade of the first database, and wherein read-only objects are not allowed to be changed during upgrade of the first database;

creating a corresponding integration object for each modifiable object in the first database, wherein each integration object includes at least those object fields that are allowed to be modified in the corresponding modifiable object, and wherein each integration object is independent of a software vendor-supplied type of the corresponding modifiable object;

generating a second database of objects based on objects in the first database and sending a copy of each modifiable object in the first database to the second database;

creating in said first database a first snapshot of a first integration object whose corresponding first modifiable object in said first database is to be modified after generation of said second database;

sending said first snapshot to said second database;

creating in said first database a second snapshot of said first integration object after said first modifiable object has been changed from a version used to generate the second database;

sending said second snapshot to said second database;

determining a first delta snapshot at said second database identifying differences between said first and said second snapshots; and

updating the copy of said first modifiable object in the second database based on the first delta snapshot.

14. In a computer system, a method for upgrading a database of objects, comprising:

marking objects in a first database as either modifiable or read-only using a corresponding field in the respective object, wherein modifiable objects are allowed to be changed during upgrade of the first database, and wherein read-only objects are not allowed to be changed during upgrade of the first database;

creating a corresponding integration object for each modifiable object in the first database, wherein each integration object includes at least those object fields that are allowed to be modified in the corresponding modifiable object, and wherein each integration object is independent of a software vendor-supplied type of the corresponding modifiable object;

receiving an indication to start logging changes to a first modifiable object;

creating in said first database a first snapshot representing a first set of changes in a first integration object corresponding to the first modifiable object;

creating in said first database a second snapshot representing a second set of changes in the first integration object, wherein said second set of changes occurs after said first set of changes;

determining a delta snapshot identifying differences between said first and said second snapshots; and

receiving a request for a latest version of the first modifiable object in the first database; and

sending the first snapshot and the delta snapshot as representing the latest version of the first modifiable object.

15. The method of claim 14, wherein the first snapshot, the second snapshot, and the delta snapshot are XML documents.

16. A computer program product for upgrading a repository of objects, comprising:

code for marking objects in a first database as either modifiable or read-only using a corresponding field in the respective object, wherein modifiable objects are allowed to be changed during upgrade of the first database, and wherein read-only objects are not allowed to be changed during upgrade of the first database;

code for creating a corresponding integration object for each modifiable object in the first database, wherein each integration object includes at least those object fields that are allowed to be modified in the corresponding modifiable object, and wherein each integration object is independent of a software vendor-supplied type of the corresponding modifiable object;

code for generating a second database of objects based on objects in the first database;

code for sending a copy of each modifiable object in the first database to the second database;

code for creating in said first database a first snapshot of a first integration object whose corresponding first modifiable object in said first database is to be modified after generation of said second database;

code for sending said first snapshot to said second database;

code for creating in said first database a second snapshot of said first integration object after said first modifiable object has been changed from a version used to generate the second database;

code for sending said second snapshot to said second database;

code for determining a first delta snapshot at said second database identifying differences between said first and said second snapshots;

code for updating the copy of the first modifiable object in the second database based on the first delta snapshot; and

a data storage medium configured to store the codes.

22. In a computer system, a method for upgrading a database of objects, comprising:

marking objects in a first database as either modifiable or read-only using a corresponding field in the respective object, wherein modifiable objects are allowed to be changed during upgrade of the first database, and wherein read-only objects are not allowed to be changed during upgrade of the first database;

creating a corresponding integration object for each modifiable object in the first database, wherein each integration object includes at least those object fields that are allowed to be modified in the corresponding modifiable object, and wherein each integration object is independent of a software vendor-supplied type of the corresponding modifiable object;

generating a second database of objects based on objects in the first database and sending a copy of each modifiable object in the first database to the second database;

replicating changes made to a first modifiable object in the first database to a first integration object corresponding thereto, so as to make said first integration object a copy of said first modifiable object;

creating in said first database a first snapshot of a latest version of said first integration object;

sending said first snapshot to said second database; and

updating the copy of said first modifiable object in the second database based on the first snapshot.