发明申请
- 专利标题: Database Table Look-up
- 专利标题(中): 数据库表查找
-
申请号: US12714617申请日: 2010-03-01
-
公开(公告)号: US20110213775A1公开(公告)日: 2011-09-01
- 发明人: Hubertus Franke , You-Chin Fuh , Hong Min , Terence P. Purcell , Yefim Shuf
- 申请人: Hubertus Franke , You-Chin Fuh , Hong Min , Terence P. Purcell , Yefim Shuf
- 申请人地址: US NY Armonk
- 专利权人: INTERNATIONAL BUSINESS MACHINES CORPORATION
- 当前专利权人: INTERNATIONAL BUSINESS MACHINES CORPORATION
- 当前专利权人地址: US NY Armonk
- 主分类号: G06F17/30
- IPC分类号: G06F17/30
摘要:
Techniques for database table look-up are provided. The techniques include storing one or more column attributes of a database table in a data structure, wherein the data structure also comprises a record identification (RID) column of a table, one or more predicate columns corresponding to the RID column, and a sequence number column that is associated with one or more updated records, generating a key using one or more portions from one or more of the one or more predicate columns, using the key to partition the data structure, wherein partitioning the data structure comprises partitioning the one or more predicate columns for evaluation, and evaluating the one or more predicate columns against the data structure for each matching predicate column-data structure partition.
公开/授权文献
- US08359316B2 Database table look-up 公开/授权日:2013-01-22
信息查询