USING A DATA DICTIONARY TO DETERMINE AN UPGRADE EDITION OF A RELATIONAL DATABASE TABLE

• US 20140101644A1
• Filed: 03/14/2013
• Published: 04/10/2014
• 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, HUDSON, Kevin, BASTIDAS, Santiago Xavier, DUJMOVIC, Ivo, ARDERIUS, Maximiliano
• Granted Patent: US 10,496,399 B2
• Time in Patent Office: Days
• US Class Current: 717/168
• 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, system, and computer program product using a data dictionary to automatically determine an upgrade edition of relational database table in a database installation. The editioning method commences upon receiving a data dictionary of the database comprising at least entries corresponding to a first edition of the relational database table, then reading entries of the data dictionary to identify at least one relational database table column of the relational database table that has a revision identifier. The revision identifiers are used to determine a first edition (e.g., a run edition) and a second edition (e.g., an upgrade edition). Then, the method proceeds by creating at least a first relational database table view corresponding to the first edition of the relational database table; and creating at least a second relational database table view corresponding to the upgrade edition of the relational database table using the identified relational database table column.

Claims

1. A computer implemented method for using a data dictionary to automatically determine an upgrade edition of relational database table, the method comprising:

receiving a data dictionary comprising at least entries corresponding to a first edition of the relational database table;

reading entries of the data dictionary to identify at least one relational database table column of the relational database table that has a revision identifier;

creating at least a first relational database table view corresponding to the first edition of the relational database table using the identified relational database table column; and

creating at least a second relational database table view corresponding to the upgrade edition of the relational database table using the identified relational database table column.

2. The method of claim 1, further comprising configuring a synonym in a first configuration to access a first one of the relational database table views.

3. The method of claim 2, further comprising configuring the synonym in a second configuration to access a second one of the relational database table views.

4. The method of claim 3, further comprising identifying a set of software applications to be upgraded, then enabling access by at least one of the set of software applications to the first relational database table view using the first configuration, and providing access to the second relational database table view using the second configuration.

5. The method of claim 1, wherein creating at least a second relational database table view creates an editioned view using the table columns corresponding to a highest revision identifier.

6. The method of claim 5, further comprising removing constraints on columns that appeared in a first view that do not appear in the editioned view.

7. The method of claim 5, further comprising deallocating storage space corresponding to columns that appeared in a first view that do not appear in the editioned view.

8. A computer system for using a data dictionary to automatically determine an upgrade edition of a relational database table, 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, receiving a data dictionary comprising at least entries corresponding to a first edition of the relational database table;

reading entries of the data dictionary to identify at least one relational database table column of the relational database table that has a revision identifier;

creating at least a first relational database table view corresponding to the first edition of the relational database table using the identified relational database table column; and

creating at least a second relational database table view corresponding to the upgrade edition of the relational database table using the identified relational database table column.

9. The computer system of claim 8, further comprising program code for configuring a synonym in a first configuration to access a first one of the relational database table views.

10. The computer system of claim 9, further comprising program code for configuring the synonym in a second configuration to access a second one of the relational database table views.

11. The computer system of claim 10, further comprising program code for identifying a set of software applications to be upgraded, then enabling access by at least one of the set of software applications to the first relational database table view using the first configuration, and providing access to the second relational database table view using the second configuration.

12. The computer system of claim 8, wherein creating at least a second relational database table view creates an editioned view using the table columns corresponding to a highest revision identifier.

13. The computer system of claim 12, further comprising program code for removing constraints on columns that appeared in a first view that do not appear in the editioned view.

14. The computer system of claim 12, further comprising program code for deallocating storage space corresponding to columns that appeared in a first view that do not appear in the editioned view.

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 using a data dictionary to automatically determine an upgrade edition of a relational database table, the process comprising:

receiving a data dictionary comprising at least entries corresponding to a first edition of the relational database table;

reading entries of the data dictionary to identify at least one relational database table column of the relational database table that has a revision identifier;

creating at least a first relational database table view corresponding to the first edition of the relational database table using the identified relational database table column; and

creating at least a second relational database table view corresponding to the upgrade edition of the relational database table using the identified relational database table column.

16. The computer program product of claim 15, further comprising instructions for configuring a synonym in a first configuration to access a first one of the relational database table views.

17. The computer program product of claim 16, further comprising instructions for configuring the synonym in a second configuration to access a second one of the relational database table views.

18. The computer program product of claim 15, wherein creating at least a second relational database table view creates an editioned view using the table columns corresponding to a highest revision identifier.

19. The computer program product of claim 18, further comprising program code for removing constraints on columns that appeared in a first view that do not appear in the editioned view.

20. The computer program product of claim 18, further comprising program code for deallocating storage space corresponding to columns that appeared in a first view that do not appear in the editioned view.