Inhibiting non-critical access based on measured performance...

Details Inhibiting non-critical access based on measured performance... Inhibiting non-critical access based on measured performance...

2011-07-05

2011-07-05

Breene, John (Department: 2162)

Data processing: database and file management or data structures

Data integrity

C707S690000, C707S692000, C707S694000, C707S703000

Reexamination Certificate

active

07974955

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.

REFERENCES:
patent: 5175849 (1992-12-01), Schneider
patent: 6282570 (2001-08-01), Leung et al.
patent: 7058622 (2006-06-01), Tedesco
patent: 7085786 (2006-08-01), Carlson et al.
patent: 2002/0133529 (2002-09-01), Schmidt
patent: 2003/0043213 (2003-03-01), Finley et al.
patent: 2004/0107219 (2004-06-01), Rosenberger

Affiliated with

Also associated with

Rating

Inhibiting non-critical access based on measured performance... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Inhibiting non-critical access based on measured performance..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Inhibiting non-critical access based on measured performance... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2684132