Transparently upgrading derived database objects

• US 9,141,635 B2
• Filed: 03/14/2013
• Issued: 09/22/2015
• Est. Priority Date: 09/28/2012
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Buzaski, George, Kumanduri, Murali Krishna, Warren, Mark
• Primary Examiner(s): CHAVIS, JOHN Q
• Application Number:
  US13/802,780
• Publication Number:
  US 20140101650A1
• Time in Patent Office: 922 Days
• Field of Search: 717/170
• US Class Current: 1/1
• CPC Class Codes: G06F 11/2056 by mirroring
• CPC Class Codes: G06F 11/2058 using more than 2 mirrored copies
• CPC Class Codes: G06F 16/178 Techniques for file synchronisation in file systems
• CPC Class Codes: G06F 16/23 Updating
• CPC Class Codes: G06F 16/2358 Change logging, detection, and notification replication G06F16/27
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 16/2372 Updates performed during offline database operations
• CPC Class Codes: G06F 16/2393 Updating materialised views
• CPC Class Codes: G06F 16/245 Query processing
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: G06F 8/65 Updates security arrangements therefor G06F21/57
• CPC Class Codes: G06F 8/656 while running
• CPC Class Codes: G06F 8/658 Incremental updates; Differential updates
• CPC Class Codes: G06F 8/71 Version control security arrangements therefor G06F21/57; Configuration management

Abstract

A method for transparently upgrading derived database objects commences upon analysis of the data dictionary definition for an initial derived database object as compared to the data dictionary definition for a patched derived database object, then determining if a regenerated instance of the derived database object would be logically different from the initial derived database object. The determination is based on comparisons of the definitions of the initial derived database objects and patched definitions of respective database objects. The method produces a regenerated instance of the derived database object when a regenerated instance of the patched derived database object would be logically different from the initial derived database object. The method will suppress the production of a regenerated instance when a regenerated instance of the derived database object would not be logically different from the initial derived database object. Once regenerated or suppressed, a post-upgrade software application accesses the regenerated derived database object instance (if regenerated) or the initial derived database object if the regenerated instance was suppressed.

Claims

1. A computer implemented method for transparently upgrading derived database objects, the method comprising:

accessing, by a pre-upgrade software application, a set of one or more initial derived database objects, at least one of the initial derived database objects being derived from a database table to be upgraded;

determining if a regenerated instance of the derived database object would be logically different from the initial derived database objects; and

producing, in response to the determination, a regenerated instance of the derived database object when a regenerated instance of the derived database object would be logically different from the initial derived database object;

or

suppressing, in response to the determination, production of a regenerated instance of the derived database object when a regenerated instance of the derived database object would not be logically different from the initial derived database object;

then

accessing, by a post-upgrade software application, the regenerated instance or the initial derived database object.

2. The method of claim 1, further comprising applying a patch to a definition of the initial derived database object to create a patched definition of the derived database object, or applying a patch to the pre-upgrade software application to create a patched post-upgrade software application.

3. The method of claim 2, wherein, the determination applies heuristics that are based at least in part on the definition of the derived database object.

4. The method of claim 3, further comprising determining if the definition of the derived database object comprises only non-indexed fields.

5. The method of claim 1, wherein, the determination applies heuristics that are based at least in part on contents of the database table to be upgraded.

6. The method of claim 1, wherein the determination applies at least one of, a coarse-grained rule, a fine-grained rule, a Boolean test.

7. The method of claim 1, wherein the determination compares canonical representations.

8. A computer system for transparently upgrading derived database objects, comprising:

a computer processor to execute a set of program code instructions; and

a memory to hold the program code instructions, in which the program code instructions comprises program code to perform,

accessing, by a pre-upgrade software application, a set of one or more initial derived database objects, at least one of the initial derived database objects being derived from a database table to be upgraded;

determining if a regenerated instance of the derived database object would be logically different from the initial derived database object; and

producing, in response to the determination, a regenerated instance of the derived database object when a regenerated instance of the derived database object would be logically different from the initial derived database object;

or

suppressing, in response to the determination, production of a regenerated instance of the derived database object when a regenerated instance of the derived database object would not be logically different from the initial derived database object;

then

accessing, by a post-upgrade software application, the regenerated instance or the initial derived database object.

9. The computer system of claim 8, further comprising program code for applying a patch to a definition of the initial derived database object to create a patched definition of the derived database object, or applying a patch to the pre-upgrade software application to create a patched post-upgrade software application.

10. The computer system of claim 9, wherein, the determination applies heuristics that are based at least in part on the definition of the derived database object.

11. The computer system of claim 10, further comprising program code for determining if the definition of the derived database object comprises only non-indexed fields.

12. The computer system of claim 8, wherein, the determination applies heuristics that are based at least in part on contents of the database table to be upgraded.

13. The computer system of claim 8, wherein the determination applies at least one of, a coarse-grained rule, a fine-grained rule, a Boolean test.

14. The computer system of claim 8, wherein the determination compares canonical representations.

15. A computer program product embodied in a non-transitory computer readable medium, the computer readable medium having stored thereon a sequence of instructions which, when executed by a processor causes the processor to execute a process to implement transparently upgrading derived database objects, the process comprising:

accessing, by a pre-upgrade software application, a set of one or more initial derived database objects, at least one of the initial derived database objects being derived from a database table to be upgraded;

determining if a regenerated instance of the derived database object would be logically different from the initial derived database object; and

producing, in response to the determination, a regenerated instance of the derived database object when a regenerated instance of the derived database object would be logically different from the initial derived database object;

or

suppressing, in response to the determination, production of a regenerated instance of the derived database object when a regenerated instance of the derived database object would not be logically different from the initial derived database object;

then

accessing, by a post-upgrade software application, the regenerated instance or the initial derived database object.

16. The computer program product of claim 15, further comprising instructions for applying a patch to a definition of the initial derived database object to create a patched definition of the derived database object, or applying a patch to the pre-upgrade software application to create a patched post-upgrade software application.

17. The computer program product of claim 16, wherein, the determination applies heuristics that are based at least in part on the definition of the derived database object.

18. The computer program product of claim 17, further comprising instructions for determining if the definition of the derived database object comprises only non-indexed fields.

19. The computer program product of claim 15, wherein, the determination applies heuristics that are based at least in part on contents of the database table to be upgraded.

20. The computer program product of claim 15, wherein the determination compares canonical representations.