Invention Grant
- Patent Title: Managing database recovery time
- Patent Title (中): 管理数据库恢复时间
-
Application No.: US13041091Application Date: 2011-03-04
-
Publication No.: US08370310B2Publication Date: 2013-02-05
- Inventor: Robin Dhananjay Dhamankar , Hanumantha Rao Kodavalla
- Applicant: Robin Dhananjay Dhamankar , Hanumantha Rao Kodavalla
- Applicant Address: US WA Redmond
- Assignee: Microsoft Corporation
- Current Assignee: Microsoft Corporation
- Current Assignee Address: US WA Redmond
- Agency: Workman Nydegger
- Main IPC: G06F15/16
- IPC: G06F15/16 ; G06F17/20

Abstract:
Managing database recovery time. A method includes receiving user input specifying a target recovery time for a database. The method further includes determining an amount of time to read a data page of the database from persistent storage. The method further includes determining an amount of time to process a log record of the database to apply changes specified in the log record to a data page. The method further includes determining a number of dirty pages that presently would be read in recovery if a database failure occurred. The method further includes determining a number of log records that would be processed in recovery if a database failure occurred. The method further includes adjusting at least one of the number of dirty pages that presently would be read in recovery or the number of log records that would be processed in recovery to meet the specified target recovery time.
Public/Granted literature
- US20120226668A1 MANAGING DATABASE RECOVERY TIME Public/Granted day:2012-09-06
Information query