Optimizing a database query that returns a predetermined...

Details Optimizing a database query that returns a predetermined... Optimizing a database query that returns a predetermined...

2008-03-11

2008-03-11

Vital, Pierre (Department: 2169)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

11128053

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: 5089985 (1992-02-01), Chang et al.
patent: 5091852 (1992-02-01), Tsuchida et al.
patent: 5926807 (1999-07-01), Peltonen et al.
patent: 6654039 (2003-11-01), Hollines, III et al.
patent: 7007009 (2006-02-01), Bestgen et al.
patent: 2006/0095440 (2006-05-01), Dettinger et al.
patent: 2006/0167845 (2006-07-01), Xia 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.
Matthias Jarke, Jurgen Koch; Query Optimization in Database Systems; Jun. 1984 ACM Computing Surveys (CSUR), vol. 16 Issue 2 pp. 111-152□□Publisher: ACM Press □□.
David Simmen, Eugene Shekita, Timothy Malkemus; Fundamental techniques for order optimization; Jun. 1996 ACM SIGMOD Record, Proceedings of the 1996 ACM SIGMOD international conference on Management of data SIGMOD '96, vol. 25 Issue 2 pp. 57-67 Publisher: ACM Press.

Affiliated with

Also associated with

Rating

Optimizing a database query that returns a predetermined... 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 returns a predetermined..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Optimizing a database query that returns a predetermined... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3905090