Low-downtime and zero-downtime upgrades of database-centric applications
US8521706B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Oct 19, 2007 |
| Grant date | Aug 27, 2013 |
| Priority date | — |
| Expiry date | Nov 21, 2029 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/2365
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A database may facilitate zero-downtime upgrades by concurrently maintaining multiple editions of database objects for use by both pre-upgrade and post-upgrade clients of a database application. Operations performed within the database are associated with an edition based on, for example, an initiating client or transaction. When an operation references an object or data, the database automatically performs the operation using the object or data associated with the edition with which the operation is itself associated. The database may determine the associated edition without explicit identification of the associated edition in a query or in code. Thus, no client or stored procedure code changes are necessary to reflect a new edition added during an update. Data changes in one edition may be automatically and immediately propagated to the other edition through the use of cross-edition triggers, thereby allowing both pre-upgrade and post-upgrade clients to remain fully functional throughout an upgrade.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.