Optimization of queries on views defined by conditional...

Details Optimization of queries on views defined by conditional... Optimization of queries on views defined by conditional...

G - Physics

06

F

G06F 17/30 (2006.01)

Patent

CA 2427209

For an information retrieval system, a query rewrite optimization method for eliminating condition predicates of conditional expressions defining the values of a column that is referenced in the predicate of an SQL query on a view. The method evaluates the query to identify a view and a predicate referencing a column of the view. The column has values selected by a conditional expression having condition predicates defining respective mutually exclusive ranges of values. The predicate defines a first range of values. A determination is made as to whether one of the condition predicates defines a mutually exclusive range of values that includes the first range of values. And, in response, the query is rewritten to eliminate the condition predicates other than the one condition predicate. The predicate is thus applied directly to the base tables without evaluating the conditional expression.

Affiliated with

Also associated with

Rating

Optimization of queries on views defined by conditional... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Optimization of queries on views defined by conditional..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Optimization of queries on views defined by conditional... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFCA-PAI-O-1863533