Redundant join elimination and sub-query elimination using...

Details Redundant join elimination and sub-query elimination using... Redundant join elimination and sub-query elimination using...

G - Physics

06

F

G06F 17/30 (2006.01)

Patent

CA 2374271

A query rewrite optimization method for eliminating a redundant join and equivalent subquery in an SQL query before generation and selection of the optimal query execution plan. The method evaluates a query for a particular join of a first and second quantifier each ranging over the same table. A determination is made whether the row set produced relative to the second quantifier subsumes the row set produced relative to the first quantifier. The query may be reformed to eliminate the join and the second quantifier. A further determination of the removability of the second quantifier may be required such as by evaluating a of a cardinality constraint when query output cardinality is material.

Affiliated with

Also associated with

Rating

Redundant join elimination and sub-query elimination using... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Redundant join elimination and sub-query elimination using..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Redundant join elimination and sub-query elimination using... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFCA-PAI-O-1851317