Invention Grant
- Patent Title: Regulating the workload of a database system
- Patent Title (中): 调节数据库系统的工作量
-
Application No.: US10915609Application Date: 2004-08-10
-
Publication No.: US07657501B1Publication Date: 2010-02-02
- Inventor: Douglas P. Brown , Anita Richards , Bhashyam Ramesh
- Applicant: Douglas P. Brown , Anita Richards , Bhashyam Ramesh
- Applicant Address: US OH Miamisburg
- Assignee: Teradata US, Inc.
- Current Assignee: Teradata US, Inc.
- Current Assignee Address: US OH Miamisburg
- Agent Howard Speight
- Main IPC: G06F7/00
- IPC: G06F7/00

Abstract:
A method, computer program and system for regulating the workload of a database system as it processes one or more requests are disclosed. The requests are grouped into workload groups and are processed by one or more of a plurality of subsystems within the database system. Each subsystem has resources. The system has resources. The subsystem resources and the system resources are allocated across the workload groups. The method, computer program and system include monitoring, at a subsystem level, the processing of the requests and adjusting the allocation of subsystem resources to workload groups to achieve a subsystem goal and monitoring, at a system level, the processing of the requests and adjusting the allocation of system resources to workload groups to achieve a system goal. The subsystems are arranged in a hierarchical network. The method includes each subsystem reporting through the hierarchy of the network the consumption level of its resources and each subsystem reporting through the hierarchy of the network the consumption level of the resources of other subsystems reporting to it according to the hierarchy.
Information query