发明授权
- 专利标题: Maintained symbol table only index
- 专利标题(中): 维护符号表仅索引
-
申请号: US12839803申请日: 2010-07-20
-
公开(公告)号: US07921102B2公开(公告)日: 2011-04-05
- 发明人: Michael W. Cain , Michael S. Faunce , Wei Hu , Shantan Kethireddy , Andrew Peter Passe , Ulrich Thiemann
- 申请人: Michael W. Cain , Michael S. Faunce , Wei Hu , Shantan Kethireddy , Andrew Peter Passe , Ulrich Thiemann
- 申请人地址: US NY Armonk
- 专利权人: International Business Machines Corporation
- 当前专利权人: International Business Machines Corporation
- 当前专利权人地址: US NY Armonk
- 代理机构: Wood, Herron & Evans, LLP
- 主分类号: G06F17/30
- IPC分类号: G06F17/30
摘要:
A method, apparatus and program product is provided for optimizing a database query. A query syntax, system generated predicates, and requisite statistics of the database query are analyzed to determine if a predicate structure is a good candidate for a symbol table only data structure. The predicate structure is analyzed to determine if the predicate structure is already encompassed by an encoded vector index. The symbol table only data structure is generated for at least one column in a database table without generating a corresponding vector data structure from an encoded vector index if the predicate structure is a good candidate and not encompassed by an encoded vector index. The symbol table only data structure is maintained by detecting a change in data associated with the symbol table only data structure and updating the symbol table only data structure to reflect the change in the data.
公开/授权文献
- US20100287206A1 MAINTAINED SYMBOL TABLE ONLY INDEX 公开/授权日:2010-11-11
信息查询