Apparatus and method for reducing size of intermediate...

Details Apparatus and method for reducing size of intermediate... Apparatus and method for reducing size of intermediate...

2011-04-12

2011-04-12

Rones, Charles (Department: 2164)

Data processing: database and file management or data structures

Database and file access

Query optimization

C707S715000

Reexamination Certificate

active

07925642

ABSTRACT:
A query processor includes a HAVING clause processing mechanism that processes the HAVING clause in a query when generating the intermediate results, instead of generating the intermediate results without regard to the HAVING clause, then applying the HAVING clause to the intermediate results. As a result, the size of the intermediate results may be significantly reduced, and effort is not wasted in placing data into the intermediate results in one step that would be removed were the HAVING clause processed separately.

REFERENCES:
patent: 5812840 (1998-09-01), Shwartz
patent: 5873098 (1999-02-01), Bamford et al.
patent: 6041344 (2000-03-01), Bodamer et al.
patent: 6338056 (2002-01-01), Dessloch et al.
patent: 6356888 (2002-03-01), Egan et al.
patent: 6424980 (2002-07-01), Iizuka et al.
patent: 6480836 (2002-11-01), Colby et al.
patent: 6785668 (2004-08-01), Polo et al.
patent: 7181450 (2007-02-01), Malloy et al.
patent: 2003/0055814 (2003-03-01), Chen et al.
patent: 2003/0195881 (2003-10-01), Koo et al.
patent: 2005/0210023 (2005-09-01), Barrera et al.
Research Disclosure, Feb. 2001, pp. 319-320, “Multiple-column sorting controls”.
IBM Technical Disclosure Bulletin, vol. 33, No. 3B, Aug. 1990, pp. 407-408, “Improved query understanding through the use of a group by window”.
IBM Technical Disclosure Bulletin, vol. 33, No. 3B, Aug. 1990, pp. 418-419, “Improved query understanding through the use of a having window”.
IBM Technical Disclosure Bulletin, vol. 35, No. 4A, Sep. 1992, pp. 314-317, “Optimization of like predicate in an SQL query”.

Affiliated with

Also associated with

Rating

Apparatus and method for reducing size of intermediate... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Apparatus and method for reducing size of intermediate..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Apparatus and method for reducing size of intermediate... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2712654