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.

Date of Patent:
Nov. 19, 2019

Filed:

Dec. 18, 2015
Applicant:

Sap SE, Walldorf, DE;

Inventors:

Guido Moerkotte, Mannheim, DE;

Norman May, Karlsruhe, DE;

Alexander Boehm, Sandhausen, DE;

Assignee:

SAP SE, Walldorf, DE;

Attorney:
Primary Examiner:
Int. Cl.
CPC ...
G06F 7/00 (2006.01); G06F 16/2453 (2019.01); G06F 16/174 (2019.01); G06F 16/22 (2019.01); G06F 16/28 (2019.01);
U.S. Cl.
CPC ...
G06F 16/24534 (2019.01); G06F 16/1744 (2019.01); G06F 16/2246 (2019.01); G06F 16/283 (2019.01);
Abstract

A method, medium, and system to generate cardinality estimates for at least one query execution plan for a query by representing a given set of multidimensional data including a plurality of data points having a value by a hierarchical tree data structure including nodes, each node representing a distribution of a subset of the points in the data set and being partitioned into tiles; calculating a bounding rectangle of the data points in each node; entering all non-empty tiles into a queue; processing of the queue can continue until a computational memory space limit is reached or until a desired estimation resolution is met; and encoding the resulting tree structure.


Find Patent Forward Citations

Loading…