High performance predicate push-down for non-matching...

Details High performance predicate push-down for non-matching... High performance predicate push-down for non-matching...

2007-11-20

2007-11-20

Wong, Don (Department: 2163)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

10304220

ABSTRACT:
A method, apparatus, and article of manufacture for improving the performance of evaluating predicates with non-matching operands by aggressively casting the input value to the data type of the target column before the data of the target column is accessed.

REFERENCES:
patent: 5386568 (1995-01-01), Wold et al.
patent: 6032143 (2000-02-01), Leung et al.
patent: 6088524 (2000-07-01), Levy et al.
patent: 6345266 (2002-02-01), Ganguly et al.
patent: 6381616 (2002-04-01), Larson et al.
patent: 6385603 (2002-05-01), Chen et al.
patent: 6438541 (2002-08-01), Witkowski
patent: 6578090 (2003-06-01), Motoyama et al.
patent: 6622138 (2003-09-01), Bellamkonda et al.
patent: 6748377 (2004-06-01), Attaluri
patent: 2001/0037322 (2001-11-01), Lindsay et al.
patent: 2001/0051949 (2001-12-01), Carey et al.
patent: 2002/0016907 (2002-02-01), Grochowski et al.
patent: 2002/0069193 (2002-06-01), Beavin et al.
patent: 2002/0078015 (2002-06-01), Ponnekanti
patent: 2002/0112148 (2002-08-01), Wang et al.
patent: 2002/0120620 (2002-08-01), Chan et al.
patent: 2003/0135758 (2003-07-01), Turner
patent: 2003/0187858 (2003-10-01), Kirk et al.
patent: 2004/0111713 (2004-06-01), Rioux
patent: 2004/0128657 (2004-07-01), Ghiya et al.
patent: 2004/0268309 (2004-12-01), Grover et al.
patent: 2005/0015673 (2005-01-01), Plesko et al.
patent: 2005/0039124 (2005-02-01), Chu et al.
patent: 2005/0097084 (2005-05-01), Balmin et al.
patent: 2005/0097523 (2005-05-01), Uchida
“Type-Checking OQL Queries in the ODMG Type Systems” by Suad Alagic, ACM transactions on Database Systems, vol. 24, No. 3, Sep. 1999, pp. 319-360.
“C How To Program” by H.M. Deitel/P.J. Deitel, 2ndedition, Prentice Hall 1994, 1992, pp. 61, 73-74, 122-125, 158, and 699-700.
“Coping With Type Casts in C” by Michael Siff, Satish Chandra, Thomas Ball, Krishna Kunchithapadam, and Thomas Reps, Mathematics Department, Sarah Lawrence Colleg, Bronxville, NY 10708-5999; Bell Laboratories, Lucent Technologies, Naperville, IL 60566.
“ORACLE7 The Complete Reference” by George Koch, Covers Versions 6 & 7, pp. 147, 150-151, 738, 762, and 896-897.
W. Zhang et al., “Speeding up Heterogeneous Data Access by Converting and Pushing down String Comparisons,” IEEE, 1999, 3 pages.

Affiliated with

Also associated with

Rating

High performance predicate push-down for non-matching... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with High performance predicate push-down for non-matching..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and High performance predicate push-down for non-matching... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3846655