Conversion of an application database to minimize time in single-user access mode
US8165990B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Jun 15, 2009 |
| Grant date | Apr 24, 2012 |
| Priority date | — |
| Expiry date | Apr 5, 2030 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/213
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method and system for converting source tables of a database of the application to target tables of a new version of the database while reducing the amount of time that the database needs to be open in single-user access mode is provided. A conversion system divides the conversion into a multi-user phase and a single-user phase. During the multi-user phase, the conversion system can perform most of the conversions while the database is opened in multi-user access mode. The conversion system stores the converted data in auxiliary tables, rather than updating the source tables. During the single-user phase, the conversion system performs the remaining conversions and copies data from the source tables and the converted data from the auxiliary tables to the target tables.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.