Invention Grant
US07991744B2 Method and system for dynamically collecting data for checkpoint tuning and reduce recovery time
有权
用于动态收集检查点调整数据并减少恢复时间的方法和系统
- Patent Title: Method and system for dynamically collecting data for checkpoint tuning and reduce recovery time
- Patent Title (中): 用于动态收集检查点调整数据并减少恢复时间的方法和系统
-
Application No.: US12171110Application Date: 2008-07-10
-
Publication No.: US07991744B2Publication Date: 2011-08-02
- Inventor: Abhijit Saha , Sudip Bhowmik
- Applicant: Abhijit Saha , Sudip Bhowmik
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Cahn & Samuels, LLP
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/00

Abstract:
A system and method for checkpoint tuning in a computer environment comprising a processor coupled to a statistical database and at least one database or table manager and data log files. The data log files store data relating to the operations of the database or table manager. The processor executes a module that captures data comprising the number of operations, the time taken by the checkpoint process, folded journal entries, long running transactions, and the ratio of WRITE:READ operations. The processor then stores the captured data and processes the collected data, generating statistics therefrom. The statistical data is stored in the statistical database. The system selects checkpoint intervals based on the data statistics; and implements the checkpoint intervals.
Public/Granted literature
- US20100011026A1 METHOD AND SYSTEM FOR DYNAMICALLY COLLECTING DATA FOR CHECKPOINT TUNING AND REDUCE RECOVERY TIME Public/Granted day:2010-01-14
Information query