发明授权
- 专利标题: Index selection in a database system
- 专利标题(中): 数据库系统中的索引选择
-
申请号: US09977038申请日: 2001-10-12
-
公开(公告)号: US07499907B2公开(公告)日: 2009-03-03
- 发明人: Douglas P. Brown , Jeetendra Chaware , Manjula Koppuravuri
- 申请人: Douglas P. Brown , Jeetendra Chaware , Manjula Koppuravuri
- 申请人地址: US OH Miamisburg
- 专利权人: Teradata US, Inc.
- 当前专利权人: Teradata US, Inc.
- 当前专利权人地址: US OH Miamisburg
- 代理机构: Trop, Pruner & Hu, P.C.
- 主分类号: G06F17/30
- IPC分类号: G06F17/30
摘要:
An index selection mechanism allows for efficient generation of index recommendations for a given workload of a database system. The workload includes a set of queries that are used to access tables in a database system. The index recommendations are validated to verify improved performance, followed by application of the indexes. Graphical user interface screens are provided to receive user input as well as to present reports to the user.
公开/授权文献
- US20030093408A1 Index selection in a database system 公开/授权日:2003-05-15