Invention Grant
- Patent Title: Actively managing resource bottlenecks in a database system
- Patent Title (中): 积极管理数据库系统中的资源瓶颈
-
Application No.: US13852278Application Date: 2013-03-28
-
Publication No.: US09213741B2Publication Date: 2015-12-15
- Inventor: Louis Burger , Douglas P. Brown , Thomas Patrick Julien
- Applicant: Teradata US, Inc.
- Applicant Address: US OH Dayton
- Assignee: Teradata US, Inc.
- Current Assignee: Teradata US, Inc.
- Current Assignee Address: US OH Dayton
- Agent Ramin Mahboubian
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
A computer-implemented method, apparatus and article of manufacture for optimizing a database query. Resource usage of one or more resources of the computer system are monitored. A condition code representative of the monitored resource usage is stored. A cost model is modified using the stored condition code. A query execution plan is generated for the database query using the modified cost model. The query execution plan is then executed in order to retrieve data from a database stored on the computer system, wherein the retrieved data is presented to a user for subsequent use and analysis.
Public/Granted literature
- US20130212086A1 ACTIVELY MANAGING RESOURCE BOTTLENECKS IN A DATABASE SYSTEM Public/Granted day:2013-08-15
Information query