发明授权
- 专利标题： Deciding whether to cache a generic plan for executing a request based on a system performance metric
- 专利标题（中）： 决定是否缓存基于系统性能指标执行请求的通用计划
-
申请号： US12205380申请日： 2008-09-05
-
公开(公告)号： US08621482B1公开(公告)日： 2013-12-31
- 发明人: Bhashyam Ramesh , Donald Pederson , Manjula Koppuravuri
- 申请人： Bhashyam Ramesh , Donald Pederson , Manjula Koppuravuri
- 申请人地址： US OH Dayton
- 专利权人： Teradata US, Inc.
- 当前专利权人： Teradata US, Inc.
- 当前专利权人地址： US OH Dayton
- 代理商 Howard Speight; Ramin Mahboubian
- 主分类号： G06F9/46
- IPC分类号： G06F9/46 ; G06F7/00
摘要：
A method, computer program, and database system are disclosed. A plurality of instances of a request to a database system are received. All instances of the request have a same set of variables to use in executing the request. The values of the variables are supplied by data in a data source. A specific plan for executing one instance of the request is generated. Generating the specific plan includes taking into account data in the data source. The specific plan is executed on the database system. A system run-time metric and a parsing time for executing the specific plan are captured and saved. A generic plan is generated and cached based on a comparison of the system run-time metric and the parsing time for executing the specific plan.
信息查询
