Minimizing downtime for application changes in database systems

• US 20050251523A1
• Filed: 05/07/2004
• Published: 11/10/2005
• Est. Priority Date: 05/07/2004
• Status: Abandoned Application

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Iyer, Chandrasekharan, Li, Warren, Rajamani, Kumar, Viswanathan, Guhan
• Application Number:
  US10/841,377
• Publication Number:
  US 20050251523A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/23 Updating
• CPC Class Codes: G06F 8/656 while running

Abstract

A method and apparatus for updating applications in the database are disclosed. A schema of an original database system is generated and updated while the original database system is online. Upon updating the original database system, synonyms are repainted to an original data storage after successful testing of the schema.

Claims

1. A method comprising:

generating a schema of an original database system;

updating the schema while the original database system is online; and

repainting at least one synonym to an original data storage upon updating the original database system after successful testing of the schema.

2. The method of claim 1 wherein the schema includes at least one duplicate synonym and a duplicate data storage layout and wherein the original database system includes at least one original synonym and at least one original database.

3. The method of claim 1 wherein the generating the schema of the original database system includes generating a copy of original application code objects.

4. The method of claim 1 wherein the generating the schema of the original database system includes generating a copy of original package specifications and bodies, functions, procedures, triggers object types, object and system privileges.

5. The method of claim 1 wherein the generating the schema database system includes generating the schema upon initialization of the original database system.

6. The method of claim 1 wherein the generating the schema comprises generating the schema when the original database needs to be updated.

7. A method comprising:

generating a schema of an original database system and updating the schema while the original database system is online; and

integrating changes into the original database system upon successful testing of the schema.

8. The method of claim 7 wherein the integrating changes into the original database system includes replacing original synonyms with a copy of updated synonyms.

9. The method of claim 7 wherein the integrating changes into the original database system includes replacing original application code objects with a copy of updated code objects.

10. The method of claim 7 wherein the integrating changes into the original database system includes modifying portions of the original database system corresponding to updated portions of the schema.

11. An apparatus comprising:

means for generating a schema of an original database system in an update storage location, wherein the schema includes at least one synonym and a data storage layout and wherein the original database system includes at least one synonym and at least one data storage;

means for updating the schema while the original database system is online; and

means for repainting the at least one synonym to the original data storage upon updating the original database system after successful testing of the schema.

12. The apparatus of claim 11 wherein the generating the schema of the original database system includes generating a copy of application code objects.

13. An apparatus comprising:

means for generating a schema of an original database system and updating the schema while the original database system is online;

means for updating the schema; and

means for integrating changes into the original database system upon successful testing of the schema.

14. The apparatus of claim 13 wherein the means for integrating changes into the original database system include means for replacing original synonyms with a copy of updated synonyms.

15. The apparatus of claim 13 wherein the means for integrating changes into the original database system include means for replacing original application code objects with a copy of updated code objects.

16. The apparatus of claim 13 wherein the means for integrating changes into the original database system include means for modifying portions of the original database system corresponding to the updated portions of the schema.

17. An article of manufacture comprising:

a computer-readable medium having stored therein instructions which, when executed by a processor, cause a processing system to perform a method comprising;

generating a schema of an original database system in an update storage location;

updating schema while the original database system is online; and

repointing the at least one synonym to an original data storage upon updating the original database system after successful testing of the schema.

18. The article of manufacture of claim 17 wherein the instructions, which when executed by the processor, cause the processing system to perform the method wherein the duplicate database system includes at least one synonym and a data storage and wherein the original database system includes at least one original synonym and at least one original data storage.

19. An article of manufacture comprising:

a computer-readable medium having stored therein instructions which, when

executed by a processor, cause a processing system to perform a method comprising;

generating a schema of an original database system and updating the schema while the original database system is online; and

integrating changes into the original database system upon successful testing of the updated schema.

20. The article of manufacture of claim 19 wherein the instructions, which when executed by the processor, cause the processing system to perform the method wherein the integrating changes into the original database system includes replacing original synonyms with a copy of updated synonyms.

21. The article of manufacture of claim 19 wherein the instructions, which when executed by the processor, cause the processing system to perform the method wherein the integrating changes into the original database system includes modifying portions of the original database system corresponding to the updated portions of the schema.