Administering the workload of a database system using feedback

Electrical computers and digital processing systems: virtual mac – Task management or control – Process scheduling

Reexamination Certificate

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

C718S105000, C718S106000, C707S793000, C707S793000, C709S200000, C709S201000, C709S202000, C709S203000

Reexamination Certificate

active

07395537

ABSTRACT:
In a method, computer program and process for administering the workload of a database system as it executes one or more requests the one or more requests are sorted into one or more workload groups. Each workload group has an associated level of service desired from the database system. The one or more requests are executed in an order intended to achieve the levels of service associated with each of the workload groups. The system resources are assigned to the one or more workload groups as necessary to provide the level of service associated with each workload group. The execution of requests is monitored on a short-term basis to detect a deviation from the level of service greater than a short-term threshold. If such a deviation is detected, the assignment of system resources to workload groups is adjusted to reduce the deviation. Monitoring is also performed on a long-term basis to detect deviations from the expected level of service greater than a long-term threshold. If such a deviation is detected, the execution of requests is adjusted to better provide the expected level of service.

REFERENCES:
patent: 5473773 (1995-12-01), Aman et al.
patent: 5537542 (1996-07-01), Eilert et al.
patent: 5675797 (1997-10-01), Chung et al.
patent: 6718358 (2004-04-01), Bigus et al.
patent: 6950848 (2005-09-01), Yousefi'zadeh
patent: 7146353 (2006-12-01), Garg et al.
patent: 7228546 (2007-06-01), McCarthy et al.
patent: 2003/0002649 (2003-01-01), Hettish
patent: 2003/0005028 (2003-01-01), Dritschler et al.
patent: 2003/0233391 (2003-12-01), Crawford et al.
patent: 2004/0021678 (2004-02-01), Ullah et al.
patent: 2004/0225631 (2004-11-01), Elnaffar et al.
patent: 2004/0243692 (2004-12-01), Arnold et al.
patent: 2005/0038789 (2005-02-01), Chidambaran et al.
patent: 2005/0039183 (2005-02-01), Romero et al.
patent: 2005/0066326 (2005-03-01), Herbeck et al.
patent: 2005/0262183 (2005-11-01), Colrain et al.
Beyer et al., “Protecting the Quality of Service of Existing Information Systems”, Computer Sciences Department, University of Wisconsin, 2003, pp. 1-10.
Nikolaou et al., “Transaction Routing for Distributed OLTP Systems: Survey and Recent Results”, Department of Computer Science, University of Crete and Institute of Computer Science, 2002, pp. 1-26.
Sinnwell et al., “Managing Distributed Memory to Meet Multiclass Workload Response Time Goals”, Department of Computer Science, University of the Saarland, 2002, pp. 1-8.
Oracle, “Orcale9l Database Resoruce Manager”, Technical Whitepaper, 2001, pp. 1-11.

LandOfFree

Say what you really think

Search LandOfFree.com for the USA inventors and patents. Rate them and share your experience with other people.

Rating

Administering the workload of a database system using feedback does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Administering the workload of a database system using feedback, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Administering the workload of a database system using feedback will most certainly appreciate the feedback.

Rate now

     

Profile ID: LFUS-PAI-O-2764777

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.