PHYSICAL TAPE DATABASE UPGRADE TOOL

• US 20170161317A1
• Filed: 12/07/2015
• Published: 06/08/2017
• Est. Priority Date: 12/07/2015
• Status: Abandoned Application

• Current Assignee: Bank of America Corp.
• Original Assignee: Bank of America Corp.
• Inventors: Glover, Stacy D., Zott, Jerome M.
• Application Number:
  US14/961,580
• Publication Number:
  US 20170161317A1
• Time in Patent Office: Days
• CPC Class Codes: G06F 11/004 Error avoidance G06F11/07 and subgroups take precedence
• CPC Class Codes: G06F 11/1433 during software upgrading
• CPC Class Codes: G06F 11/1464 for networked environments
• CPC Class Codes: G06F 16/219 Managing data history or versioning querying versioned data G06F16/2474; querying temporal data G06F16/2477
• CPC Class Codes: G06F 16/2379 Updates performed during online database operations; commit processing
• CPC Class Codes: G06F 2201/80 Database-specific techniques
• CPC Class Codes: G06F 8/65 Updates security arrangements therefor G06F21/57

Abstract

A data transformation apparatus includes a tape drive and a processor. The tape drive extracts a database from a physical tape. The processor determines a source version of the database and a final version of a database server. The processor further determines that the database server is incompatible with the extracted database and that the database cannot be upgraded directly from the source version to the final version and determines that the database should be upgraded from the source version to an intermediate version. The processor upgrades the database to the intermediate version to produce a second database. The processor also determines that the second database can be upgraded directly from the intermediate version to the final version and in response to that determination, upgrades the second database to the final version to produce a third database. The processor then loads the third database onto the database server.

Claims

1. A data transformation apparatus comprising:

a tape drive configured to extract a database from a physical tape; and

a processor communicatively coupled to the tape drive, the processor configured to;

determine a source version of the database extracted from the physical tape;

determine a final version of a database server;

determine, based on the source version and the final version, that the database server is incompatible with the extracted database and that the database cannot be upgraded directly from the source version to the final version;

in response to the determination that the database server is incompatible with the extracted database and that the database cannot be upgraded directly from the source version to the final version, determine that the database should be upgraded from the source version to an intermediate version, the intermediate version between the source version and the final version;

in response to the determination that the database should be upgraded from the source version to the intermediate version, upgrade the database to the intermediate version to produce a second database of the intermediate version;

determine, based on the intermediate and final versions, that the second database can be upgraded directly from the intermediate version to the final version;

in response to the determination that the second database can be upgraded directly from the intermediate version to the final version, upgrade the second database to the final version to produce a third database of the final version; and

load the third database onto the database server.

2. The data transformation apparatus of claim 1, wherein the processor is further configured to:

determine that the database server is compatible with databases of the intermediate version; and

in response to the determination that the database server is compatible with databases of the intermediate version, load the second database onto the database server.

3. The data transformation apparatus of claim 1, wherein the processor is further configured to store a backup copy of each of the database, the second database, and the third database.

4. The data transformation apparatus of claim 1, wherein the processor is further configured to:

determine that the second database cannot be directly upgraded to the final version;

in response to the determination that the second database cannot be directly upgraded to the final version, upgrade the second database to a second intermediate version to produce a fourth database, the second intermediate version between the intermediate version and the final version; and

upgrade the fourth database to the final version.

5. The data transformation apparatus of claim 1, wherein the database server is incompatible with databases of the source version.

6. The data transformation apparatus of claim 1, wherein upgrading the database from the source version to the intermediate version comprises:

loading the database onto a second database server compatible with both the source version and the intermediate version; and

upgrading, using the second database server, the database from the source version to the intermediate version.

7. The data transformation apparatus of claim 1, wherein the physical tape maintains a copy of the database after the database is extracted from the physical tape.

8. A method comprising:

extracting a database from a physical tape;

determining a source version of the database extracted from the physical tape;

determining a final version of a database server;

determining, based on the source version and the final version, that the database server is incompatible with the extracted database and that the database cannot be upgraded directly from the source version to the final version;

in response to the determination that the database server is incompatible with the extracted database and that the database cannot be upgraded directly from the source version to the final version, determining that the database should be upgraded from the source version to an intermediate version, the intermediate version between the source version and the final version;

in response to the determination that the database should be upgraded from the source version to the intermediate version, upgrading the database to the intermediate version to produce a second database of the intermediate version;

determining, based on the intermediate and final versions, that the second database can be upgraded directly from the intermediate version to the final version;

in response to the determination that the second database can be upgraded directly from the intermediate version to the final version, upgrading the second database to the final version to produce a third database of the final version; and

loading the third database onto the database server.

9. The method of claim 8, further comprising:

determining that the database server is compatible with databases of the intermediate version; and

in response to the determination that the database server is compatible with databases of the intermediate version, loading the second database onto the database server.

10. The method of claim 8, further comprising storing a backup copy of each of the database, the second database, and the third database.

11. The method of claim 8, further comprising determining a name and a time of creation of the database.

12. The method of claim 8, wherein the database server is incompatible with databases of the source version.

13. The method of claim 8, wherein upgrading the database from the source version to the intermediate version comprises:

loading the database onto a second database server compatible with both the source version and the intermediate version; and

upgrading, using the second database server, the database from the source version to the intermediate version.

14. The method of claim 8, wherein the physical tape maintains a copy of the database after the database is extracted from the physical tape.

15. One or more computer-readable non-transitory storage media embodying software that is operable when executed to:

extract a database from a physical tape;

determine a source version of the database extracted from the physical tape;

determine a final version of a database server;

determine, based on the source version and the final version, that the database server is incompatible with the extracted database and that the database cannot be upgraded directly from the source version to the final version;

in response to the determination that the database server is incompatible with the extracted database and that the database cannot be upgraded directly from the source version to the final version, determine that the database should be upgraded from the source version to an intermediate version, the intermediate version between the source version and the final version;

in response to the determination that the database should be upgraded from the source version to the intermediate version, upgrade the database to the intermediate version to produce a second database of the intermediate version;

determine, based on the intermediate and final versions, that the second database can be upgraded directly from the intermediate version to the final version;

in response to the determination that the second database can be upgraded directly from the intermediate version to the final version, upgrade the second database to the final version to produce a third database of the final version; and

load the third database onto the database server.

16. The media of claim 15, embodying software that is further operable when executed to:

determine that the database server is compatible with databases of the intermediate version; and

in response to the determination that the database server is compatible with databases of the intermediate version, load the second database onto the database server.

17. The media of claim 15, embodying software that is further operable when executed to store a backup copy of each of the database, the second database, and the third database.

18. The media of claim 15, embodying software that is further operable when executed to determine a name and a time of creation of the database.

19. The media of claim 15, wherein the database server is incompatible with databases of the source version.

20. The media of claim 15, wherein upgrading the database from the source version to the intermediate version comprises:

loading the database onto a second database server compatible with both the source version and the intermediate version; and

upgrading, using the second database server, the database from the source version to the intermediate version.

21. The media of claim 15, wherein the physical tape maintains a copy of the database after the database is extracted from the physical tape.