Using a correlation factor to derive join costing statistics

Details Using a correlation factor to derive join costing statistics Using a correlation factor to derive join costing statistics

2007-12-21

2010-06-29

Lewis, Cheryl (Department: 2167)

Data processing: database and file management or data structures

Database and file access

Query optimization

C707SE17132

Reexamination Certificate

active

07747609

ABSTRACT:
Deriving join cost demographics for a binary join, i.e., a join between two relations each having a join column, includes using a correlation factor related to the ratio of unique join column values stored in each of a plurality of units of storage to the total number of unique values in the join column.

REFERENCES:
patent: 5960428 (1999-09-01), Lindsay et al.
patent: 7127457 (2006-10-01), Ghazal
patent: 7260563 (2007-08-01), Priyadarshi et al.
patent: 7330848 (2008-02-01), Chaudhuri et al.
patent: 2007/0067262 (2007-03-01), Ramesh et al.

Affiliated with

Also associated with

Rating

Using a correlation factor to derive join costing statistics does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Using a correlation factor to derive join costing statistics, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Using a correlation factor to derive join costing statistics will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4229289