The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Jul. 01, 2008
Filed:
Dec. 08, 2003
Douglas P. Brown, Rancho Santa Fe, CA (US);
Anita Richards, San Juan Capistrano, CA (US);
Bhashyam Ramesh, San Diego, CA (US);
Caroline M. Ballinger, Culver City, CA (US);
Richard D. Glick, Valley Center, CA (US);
Douglas P. Brown, Rancho Santa Fe, CA (US);
Anita Richards, San Juan Capistrano, CA (US);
Bhashyam Ramesh, San Diego, CA (US);
Caroline M. Ballinger, Culver City, CA (US);
Richard D. Glick, Valley Center, CA (US);
Teradata, US Inc., Miamisburg, OH (US);
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.