Invention Grant
US07974955B2 Inhibiting non-critical access based on measured performance in a database system 有权
根据数据库系统中的测量性能抑制非关键访问

Inhibiting non-critical access based on measured performance in a database system
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.
Information query
Patent Agency Ranking
0/0