Information retrieval systems for optimization of queries...

Details Information retrieval systems for optimization of queries... Information retrieval systems for optimization of queries...

G - Physics

06

F

G06F 17/30 (2006.01) G06F 7/00 (2006.01) G06F 9/44 (2006.01)

Patent

CA 2427228

In an information retrieval system, a query optimization method for transforming maximum or minimum function aggregation predicates on a non-indexed column into a single sort function. The method first evaluates the query to identify a table and a predicate equating a column of the table to a sub-query that applies a maximum or minimum aggregation function to the column to return an aggregate value for the column. The aggregate value is used for selecting rows from the table to produce a query result. A determination is then made as to whether an index has not been created using the column of the table. And, in response to these steps of evaluating and determining, the method reforms the query as a sort function on the column. The sort function scans the table once to provide the query result.

Affiliated with

Also associated with

Rating

Information retrieval systems for optimization of queries... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Information retrieval systems for optimization of queries..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Information retrieval systems for optimization of queries... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFCA-PAI-O-1917873