Method of cardinality estimation using statistical soft...

Details Method of cardinality estimation using statistical soft... Method of cardinality estimation using statistical soft...

G - Physics

06

F

G06F 17/30 (2006.01)

Patent

CA 2359296

The present invention provides a method of estimating cardinalities using statistical soft constraints in a relational database management system. The statistical soft constraints are generated from statistical information gathered with respect to virtual columns. The virtual columns are the result of operations involving one or more columns in the database. When a query is received, the database management system determines whether any of the virtual columns are of interest because they involve expressions or relations that are also reflected in the query. The database management system then develops statistical soft constraints from the statistical characteristics of the virtual column and uses those statistical soft constraints to assist in estimating the cardinality of a step in the query plan. The virtual columns may or may not be actually materialized into a column of values.

Affiliated with

Also associated with

Rating

Method of cardinality estimation using statistical soft... 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 of cardinality estimation using statistical soft..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method of cardinality estimation using statistical soft... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFCA-PAI-O-1713046