Invention Grant
- Patent Title: Methods and systems for estimating the number of points in two-dimensional data
-
Application No.: US14975086Application Date: 2015-12-18
-
Publication No.: US10482085B2Publication Date: 2019-11-19
- Inventor: Guido Moerkotte , Norman May , Alexander Boehm
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Buckley, Maschoff & Talwalkar LLC
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F16/2453 ; G06F16/174 ; G06F16/22 ; G06F16/28

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.
Public/Granted literature
- US20170177663A1 METHODS AND SYSTEMS FOR ESTIMATING THE NUMBER OF POINTS IN TWO-DIMENSIONAL DATA Public/Granted day:2017-06-22
Information query