Invention Grant
US08165990B2 Conversion of an application database to minimize time in single-user access mode
有权
转换应用程序数据库以最小化单用户访问模式下的时间
- Patent Title: Conversion of an application database to minimize time in single-user access mode
- Patent Title (中): 转换应用程序数据库以最小化单用户访问模式下的时间
-
Application No.: US12485002Application Date: 2009-06-15
-
Publication No.: US08165990B2Publication Date: 2012-04-24
- Inventor: Kyrylo Val , Tao Wang , David Reinhold , Deepak Kumar , Satish J. Thomas , Sridhar Srinivasan
- Applicant: Kyrylo Val , Tao Wang , David Reinhold , Deepak Kumar , Satish J. Thomas , Sridhar Srinivasan
- Applicant Address: US WA Redmond
- Assignee: Microsoft Corporation
- Current Assignee: Microsoft Corporation
- Current Assignee Address: US WA Redmond
- Agency: Perkins Coie LLP
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/00
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.
Public/Granted literature
- US20100318494A1 CONVERSION OF AN APPLICATION DATABASE TO MINIMIZE TIME IN SINGLE-USER ACCESS MODE Public/Granted day:2010-12-16
Information query
