Zero Downtime Upgrade of Database Applications Using Triggers and Calculated Fields

摘要

An upgrade of a first version of a database application to a second version of a database application that both have a same data schema is initiated. The first database application has a first access schema such that at least one table in the data schema is linked to the first access schema. The second version of the database application has a second access schema such that at least one table in the data schema is linked to the second access schema. Subsequently, concurrent access is provided for each access schema to at least one database table in the data schema to the first and second versions of the database application. The concurrent access is enabled by a respective at least one table link object in each of the first access schema and the second access schema that is used by database views or stored procedures such access schema.

主权项

1. A method for implementation by one or more data processors forming part of at least one computing device, the method comprising:
initiating an upgrade of a first version of a database application to a second version of a database application that both have a same data schema, the first database application having a first access schema such that at least one table in the data schema is linked to the first access schema, the second version of the database application having a second access schema such that at least one database table in the data schema is linked to the second access schema, the first access schema differing from the second access schema; and providing, for each access schema, concurrent access to at least one database table in the data schema to both the first version of the database application and the second version of the database application, the concurrent access being enabled by a respective at least one table link object in each of the first access schema and the second access schema that is used by database views or stored procedures such access schema.