Efficient processing of multi-column and function-based...

Details Efficient processing of multi-column and function-based... Efficient processing of multi-column and function-based...

2007-05-01

2007-05-01

Mizrahi, Diane D. (Department: 2165)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

10118762

ABSTRACT:
Described herein are approaches for generating execution plans for database commands that include an in-list predicate. The approaches can be used to generate execution plans that exploit the power of in-list iterators in ways and under circumstances not previously supported by conventional DBMSs. An in-list iterator may be used with execution subplans for processing multi-column in-list queries. An in-list iterator is used with execution subplans that scan function-based indexes. The execution plans for a multi-column in-list query limit table scans to only table partitions that contain data that satisfy the query.

REFERENCES:
patent: 5598559 (1997-01-01), Chaudhuri
patent: 5732258 (1998-03-01), Jakobsson et al.
patent: 5995957 (1999-11-01), Beavin et al.
patent: 6272487 (2001-08-01), Beavin et al.
patent: 6289334 (2001-09-01), Reiner et al.
patent: 6353826 (2002-03-01), Seputis
patent: 6397204 (2002-05-01), Liu et al.
patent: 6446063 (2002-09-01), Chen et al.
patent: 6513028 (2003-01-01), Lee et al.
patent: 6529896 (2003-03-01), Leung et al.
patent: 6665663 (2003-12-01), Lindsay et al.
patent: 6757671 (2004-06-01), Galindo-Legaria et al.
patent: 6792420 (2004-09-01), Stephen Chen et al.
patent: 6947934 (2005-09-01), Chen et al.

Affiliated with

Also associated with

Rating

Efficient processing of multi-column and function-based... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Efficient processing of multi-column and function-based..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Efficient processing of multi-column and function-based... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3773331