- 专利标题: Actively managing resource bottlenecks in a database system
-
申请号: US12313252申请日: 2008-11-18
-
公开(公告)号: US08423534B2公开(公告)日: 2013-04-16
- 发明人: Louis M. Burger , Douglas P. Brown , Thomas Julien
- 申请人: Louis M. Burger , Douglas P. Brown , Thomas Julien
- 申请人地址: US OH Dayton
- 专利权人: Teradata US, Inc.
- 当前专利权人: Teradata US, Inc.
- 当前专利权人地址: US OH Dayton
- 代理机构: Gates & Cooper LLP
- 代理商 Ramin Mahboubian
- 主分类号: G06F7/00
- IPC分类号: G06F7/00 ; G06F17/30
摘要:
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.
公开/授权文献
信息查询