Invention Grant
US07974955B2 Inhibiting non-critical access based on measured performance in a database system
有权
根据数据库系统中的测量性能抑制非关键访问
- Patent Title: Inhibiting non-critical access based on measured performance in a database system
- Patent Title (中): 根据数据库系统中的测量性能抑制非关键访问
-
Application No.: US10948774Application Date: 2004-09-23
-
Publication No.: US07974955B2Publication Date: 2011-07-05
- Inventor: Eric Lawrence Barsness , Mahdad Majd , John Matthew Santosuosso
- Applicant: Eric Lawrence Barsness , Mahdad Majd , John Matthew Santosuosso
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Martin & Associates, LLC
- Agent Bret J. Petersen
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/00

Abstract:
A database system has a contention monitor which determines when the level of contention for accessing or inserting records in the database rises above a threshold, and inhibits non-critical access to the database to reduce the level of contention. In a preferred embodiment, the level of contention is determined by periodically measuring the time for an INSERT operation on the database, and comparing the time to a threshold derived from a baseline time measurement for the operation during a time of normal database activity. Thus the contention level is inferred from the time to do the operation, in this case the INSERT query. In one embodiment, the contention monitor notifies a system administrator to take action to reduce the contention. In another embodiment, the contention monitor informs the system to take action automatically according to predetermined selections by the system administrator.
Public/Granted literature
Information query