Methods and systems for estimating the number of points in two-dimensional data
AssigneeSap SE
InventorsGuido Moerkotte, Norman May, Alexander Boehm
Life of this patent
Estimating the term…
Loading patent…
AssigneeSap SE
InventorsGuido Moerkotte, Norman May, Alexander Boehm
Estimating the term…
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.
A computer-implemented method of optimizing execution of a query that accesses data by a computer, the method comprising:
A non-transitory, computer-readable medium storing program instructions thereon, the medium comprising:
A system, comprising:
Dependencies are inferred from the claim text.