Information retrieval system and method using index ANDing...

Details Information retrieval system and method using index ANDing... Information retrieval system and method using index ANDing...

2006-09-19

2006-09-19

Ali, Mohammad (Department: 2166)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000

Reexamination Certificate

active

07111025

ABSTRACT:
An information retrieval system is adapted to process a query having an associated plan that includes applying predicates comprising local predicates and a join predicate, to at least two tables. Index ANDing is used to construct a filter for filtering a first of the tables in accordance with the local predicates. The join predicate is applied to the tables for determining row identifiers of rows satisfying the join predicate. The row identifiers are used to probe the filter for determining whether the rows satisfying the join predicate also satisfy the local predicates. The rows that satisfy both the join and local predicates are fetched and the join predicate is completed. Results of the join predicate are then returned.

REFERENCES:
patent: 5241648 (1993-08-01), Cheng et al.
patent: 5548755 (1996-08-01), Leung et al.
patent: 5848408 (1998-12-01), Jakobsson et al.
patent: 5937401 (1999-08-01), Hillegas
patent: 5963933 (1999-10-01), Cheng et al.
patent: 5987453 (1999-11-01), Krishna et al.
patent: 6105020 (2000-08-01), Lindsay et al.
patent: 6253197 (2001-06-01), Lindsay et al.
patent: 6272487 (2001-08-01), Beavin et al.
patent: 6341281 (2002-01-01), MacNicol et al.
patent: 6345266 (2002-02-01), Ganguly et al.
patent: 6385603 (2002-05-01), Chen et al.
patent: 6397204 (2002-05-01), Liu et al.
patent: 6493701 (2002-12-01), Ponnekanti
patent: 2002/0069193 (2002-06-01), Beavin et al.
patent: 2002/0078015 (2002-06-01), Ponnekanti
Robert Marek & Erhard Rahm, TID Hash Joins, Nov. 1994.
“Space and Time Efficient Evaluation of Indexable Conjunctive Predicates,” IBM Technical Disclosure Bulletin, vol. 30, No. 3, pp. 1132-1133, Aug. 1987.
J. Cheng, et al., “An Efficient Hybrid Join Algorithm:A DB2 Prototype,” Proceedings Seventh International Conference on Data Engineering, Apr. 8-12, 1991, Kobe, Japan.

Affiliated with

Also associated with

Rating

Information retrieval system and method using index ANDing... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Information retrieval system and method using index ANDing..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Information retrieval system and method using index ANDing... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3619872