Invention Grant
- Patent Title: Database table look-up
- Patent Title (中): 数据库表查找
-
Application No.: US12714617Application Date: 2010-03-01
-
Publication No.: US08359316B2Publication Date: 2013-01-22
- Inventor: Hubertus Franke , You-Chin Fuh , Hong Min , Terence P. Purcell , Yefim Shuf
- Applicant: Hubertus Franke , You-Chin Fuh , Hong Min , Terence P. Purcell , Yefim Shuf
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Ryan, Mason & Lewis, LLP
- Main IPC: G06F7/00
- IPC: G06F7/00

Abstract:
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.
Public/Granted literature
- US20110213775A1 Database Table Look-up Public/Granted day:2011-09-01
Information query