Optimizing a database query that fetches N rows

Details Optimizing a database query that fetches N rows Optimizing a database query that fetches N rows

2007-09-29

2010-06-08

Vital, Pierre M (Department: 2156)

Data processing: database and file management or data structures

Database and file access

Query optimization

C707SE17017

Reexamination Certificate

active

07734620

ABSTRACT:
An apparatus and method to optimize a query access plan in a computer database system. In preferred embodiments, the query optimizer determines the query can be optimized and generates for the query an optimized access plan that eliminates records defined by a Where clause and one or more ordering criteria prior to ordering the records (sorting or grouping) and then returning a first n rows.

REFERENCES:
patent: 4829427 (1989-05-01), Green
patent: 5598559 (1997-01-01), Chaudhuri
patent: 5864840 (1999-01-01), Leung et al.
patent: 5950188 (1999-09-01), Wildermuth
patent: 6032143 (2000-02-01), Leung et al.
patent: 6341281 (2002-01-01), MacNicol et al.
patent: 6598041 (2003-07-01), Bernal et al.
patent: 6606626 (2003-08-01), Ponnekanti
patent: 6643637 (2003-11-01), Chen et al.
patent: 6654039 (2003-11-01), Hollines et al.
patent: 7007009 (2006-02-01), Bestgen et al.
patent: 2003/0055813 (2003-03-01), Chaudhuri et al.
patent: 2003/0093408 (2003-05-01), Brown et al.
patent: 2003/0187858 (2003-10-01), Kirk et al.
patent: 2005/0033730 (2005-02-01), Chaudhuri et al.
patent: 2006/0095440 (2006-05-01), Dettinger et al.
patent: 2006/0224563 (2006-10-01), Hanson et al.
patent: 2007/0038618 (2007-02-01), Kosciusko et al.
patent: 2007/0083490 (2007-04-01), Au et al.
patent: 2007/0130115 (2007-06-01), Au et al.
patent: 2008/0021868 (2008-01-01), Muras et al.
patent: 2008/0021869 (2008-01-01), Muras et al.
patent: 965928 (1999-12-01), None
“Treating Data Transformations as Objects”, Sep. 1992, IBM Technical Disclosure Bulletin, vol. 35, Issue 4A, pp. 200-205.

Affiliated with

Also associated with

Rating

Optimizing a database query that fetches N rows does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Optimizing a database query that fetches N rows, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Optimizing a database query that fetches N rows will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4250413