The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Dec. 07, 1999
Filed:
Jun. 30, 1997
Applicant:
Inventor:
Weipeng Yan, Redwood City, CA (US);
Assignee:
Informix Software, Inc., Menlo Park, CA (US);
Attorney:
Primary Examiner:
Assistant Examiner:
Int. Cl.
CPC ...
G06F / ;
U.S. Cl.
CPC ...
707-6 ; 707-2 ; 707-3 ; 707100 ;
Abstract
A method and apparatus for estimating the number of distinct values in a database table selects one of several numerical methods to solve a model of the number of distinct values in a database table based on a table size, a sample size, and the number of distinct values in the sample. The sample may be a sample previously collected for purposes other than to estimate the number of distinct values, and the number of records in the sample and the number of distinct values in the sample may be determined at the time the sample was collected.