Absolute bounds on set intersection and union sizes from distribution information
By: Neil C. Rowe
Contributors: Naval Postgraduate School (U.S.)
Publisher: Naval Postgraduate School
Published: 1985
Place of publication: Monterey, California
Language: eng
Number of pages: 46
Subjects: Databases; Microcomputers; Computer input-output equipment
Description: Estimation of set intersection and union sizes is important for access method selection for a database. Absolute bounds on sizes are often much easier to compute than size estimates, requiring no distributional or independence assumptions, and can answer many of the same needs. We present a large compendium of quick closed-form bounds on set intersection and union sizes, each applying to a different situation; they can be expressed as rules, and managed by rule-based or 'knowledge-base' architecture. These methods use general-purpose statistics precomputed on the data, and exploit homomorphisms (onto mappings) of the data items onto distributions that can be more easily analyzed. Our methods can be used anytime, but tend to work best when there are strong or complex correlations in the data. This circumstance is poorly addressed by the standard methods of independence-assumption and distributional-assumption estimates, and hence our methods fill a need.
Notes: Title from cover.

"Prepared for: Chief of Naval Research"--Cover.

"September 1985"--Cover.

"NPS52-85-014"--Cover.

DTIC Identifiers: Personal computers, PE61152N.

Author(s) key words: Databases, query processing, statistical computing, statistical inequalities, sets, Boolean algebra, estimation.

Includes bibliographical references (p. 35-36).

"Approved for public release; distribution unlimited"--Cover.

Technical report; 1985.