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:
Nov. 29, 2022
Filed:
Nov. 03, 2020
Tableau Software, Inc., Seattle, WA (US);
Sebastian Hofstetter, Munich, DE;
Moritz Kaufmann, Munich, DE;
Thomas Neumann, Munich, DE;
Viktor Leis, Munich, DE;
Alfons Kemper, Munich, DE;
Tobias Muehlbauer, Munich, DE;
Jan Finis, Munich, DE;
Manuel Then, Munich, DE;
TABLEAU SOFTWARE, INC., Seattle, WA (US);
Abstract
A method implements optimization of database queries by computing domain cardinality estimates. A client sends a database query to a server. The method parses the query to identify data columns. For each of the data columns, the method computes a lower bound and an upper bound of distinct data values using a pre-computed table size. The method also computes a patch factor by applying a pre-computed function to a ratio between a number of distinct data values that appear exactly once in a data sample and a number of distinct data values in the sample. Based on the patch factor, the lower bound, and the upper bound, the method computes an estimate of distinct values for each of the data columns. The method subsequently generates an execution plan for the query according to the computed estimates, executes the execution plan, and returns a result set to the client.