Method and apparatus for upgrading a database in a redundant environment by release chaining

• US 7,617,175 B1
• Filed: 04/21/1999
• Issued: 11/10/2009
• Est. Priority Date: 04/21/1999
• Status: Active Grant

• Current Assignee: Cisco Technology, Inc. (Cisco Systems, Inc.)
• Original Assignee: Cisco Technology, Inc. (Cisco Systems, Inc.)
• Inventors: Mouton, Jerome A. Jr., Truong, Alex Van, Buckley, William P.
• Primary Examiner(s): Fleurantin; Jean B
• Application Number:
  US09/295,690
• Time in Patent Office: 3,856 Days
• Field of Search: 707 1- 10, 707200-206, 707100-1041, 717/11, 717/100, 717/168, 717/170, 717/122, 709/206, 715/511, 715/229, 711/142, 711/143, 711/155
• US Class Current: 1/1
• CPC Class Codes: G06F 11/1433 during software upgrading
• CPC Class Codes: G06F 16/213 with details for schema evolution support
• CPC Class Codes: G06F 16/214 Database migration support
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99953 Recoverability

Abstract

What is disclosed is a method of updating a message from a first version to an upgraded version by chaining through intermediate versions, including the steps of receiving an update message having a first version format, and repeatedly generating a revised update message having a next most recent version format based on the update message until a final update message having an upgraded version format is generated. An apparatus for performing the method is also disclosed.

Claims

1. A computer-implemented method for upgrading the schema of a database, comprising:

updating, by the computer, a database update message from a first version to an upgraded version by chaining through one or more intermediate upgraded versions, wherein updating comprises

receiving an update message having a first version format, and

repeatedly generating a revised update message having a next most recent version format based on the update message until a final revised update message having the upgraded version format is generated, wherein generating a revised update message having a next most recent version format includes receiving a first update message and calling a next most recent version mapping function to map contents of the first update message to generate a second update message; and

applying, by the computer, the final revised update message to the database to write an upgraded version of the schema of the database.

2. The method of claim 1, wherein the update message includes a set of records for a database in the first version.

3. The method of claim 2, wherein the set of records for the database in the first version is a complete set of records for the database.

4. A computer readable storage medium having instructions stored thereon, which when executed by a computer, cause the computer to perform a method for upgrading the schema of a database, comprising:

updating a database update message from a first version to an upgraded version by chaining through one or more intermediate upgraded versions, wherein updating comprises

receiving an update message having a first version format, and

generating repeatedly a revised update message having a next most recent version format based on the update message until a final revised update message having the upgraded version format is generated, wherein generating a revised update message having a next most recent version format includes receiving a first update message and calling a next most recent version mapping function to map contents of the first update message to generate a second update message; and

applying the final revised update message to the database to write an upgraded version of the schema of the database.

5. The computer readable storage medium of claim 4, wherein the update message includes a set of records for a database in the first version.

6. The computer readable storage medium of claim 5, wherein the set of records for the database in the first version is complete set of records for the database.

7. An apparatus comprising:

a processor; and

a memory coupled with the processor and storing instructions which, when executed by the processor, cause the processor to update a database update message from a first version to an upgraded version by chaining through one or more intermediate upgraded versions, wherein updating comprises

receiving an update message having a first version format, and

repeatedly generating a revised update message having a next most recent format based on the update message until a final revised update message having the upgraded version format is generated, wherein generating a revised update message having a next most recent version format includes receiving a first update message and calling a next most recent version mapping function to map contents of the first update message to generate a second update message and

apply the final revised update message to a database to write an upgraded version of a schema of the database.

8. The apparatus of claim 7, wherein the update message includes a set of records for a database in the first version.

9. The apparatus of claim 8 wherein the set of records for the database in the first version is a complete set of records for the database.

10. An apparatus for upgrading the schema of a database, comprising:

a network switching device to receive an update message having a first version format, wherein the network switching device receives a first update message;

a mapper to call a next most recent version mapping function to map contents of the first update message to generate a second update message; and

a controller card to update a message from a first version to an upgraded version by chaining through intermediate upgraded versions, the controller card to repeatedly generating a revised update message having a next most recent version format based on the update message until a final revised update message having the upgraded version format is generated and apply the final upgraded version of the update message to the database to write an upgraded version of the schema of the database.

11. The apparatus of claim 10, wherein the update message includes a set of records for a database in the first version.

12. The apparatus of claim 11, wherein the set of records for the database in the first version is a complete set of records for the database.