Invention Grant
- Patent Title: Transparently upgrading derived database objects
-
Application No.: US14823849Application Date: 2015-08-11
-
Publication No.: US09665365B2Publication Date: 2017-05-30
- Inventor: George Buzsaki , Murali Krishna Kumanduri , Mark Warren
- Applicant: ORACLE INTERNATIONAL CORPORATION
- Applicant Address: US CA Redwood Shores
- Assignee: ORACLE INTERNATIONAL CORPORATION
- Current Assignee: ORACLE INTERNATIONAL CORPORATION
- Current Assignee Address: US CA Redwood Shores
- Agency: Vista IP Law Group, LLP
- Main IPC: G06F17/30
- IPC: G06F17/30 ; G06F9/445 ; G06F9/44 ; G06F11/20

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.
Public/Granted literature
- US20150347498A1 TRANSPARENTLY UPGRADING DERIVED DATABASE OBJECTS Public/Granted day:2015-12-03
Information query