Method for estimating cardinalities for query processing in...

Details Method for estimating cardinalities for query processing in... Method for estimating cardinalities for query processing in...

G - Physics

06

F

G06F 17/30 (2006.01)

Patent

CA 2146171

A method for estimating key cardinalities for a grouping of columns for use by a query optimizer in a relational database management system (RDBMS). The grouping of columns or key results from a grouping operation or duplicate removal operation in a query. The method accounts for the effects of local predicates on the columns and also the effects of local predicates on columns not belonging to the grouping. The method also utilizes selected index key cardinalities which are available in the catalog of the RDBMS for estimating the cardinalities of columns groupings and accounts for the effects of local predicates on the index key cardinalities. The method also includes a number of additional operations which utilize other attributes in order to produce an accurate estimate of the key cardinality.

Affiliated with

Also associated with

Rating

Method for estimating cardinalities for query processing in... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method for estimating cardinalities for query processing in..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method for estimating cardinalities for query processing in... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFCA-PAI-O-2066351