Invention Grant
- Patent Title: Efficient predicate evaluation via in-list
- Patent Title (中): 通过列表中的有效谓词评估
-
Application No.: US12195035Application Date: 2008-08-20
-
Publication No.: US08135738B2Publication Date: 2012-03-13
- Inventor: Lin Qiao , Vijayshankar Raman , Frederick Ralph Reiss , Richard S. Sidle , Garret Frederick Swart , F. Ryan Johnson
- Applicant: Lin Qiao , Vijayshankar Raman , Frederick Ralph Reiss , Richard S. Sidle , Garret Frederick Swart , F. Ryan Johnson
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: IP Authority, LLC
- Agent Ramraj Soundararajan
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/30

Abstract:
A predicate over a single column of a table is converted into at least one IN-list, wherein the IN-list is generated for a set of tuples of the column, and the generation is done over a data structure representing a set of distinct values of the column where the predicate applies and having a smaller cardinality than the table. The generated IN-list is evaluated over the set of tuples and the results of the evaluation are outputted as an evaluation of the predicate.
Public/Granted literature
- US20100049730A1 EFFICIENT PREDICATE EVALUATION VIA IN-LIST Public/Granted day:2010-02-25
Information query