- Patent Title: Selectivity estimation for query execution planning in a database
-
Application No.: US14694033Application Date: 2015-04-23
-
Publication No.: US10169412B2Publication Date: 2019-01-01
- Inventor: Lukasz Gaza , Artur M. Gruszecki , Tomasz Kazalski , Konrad K. Skibski , Tomasz Stradomski
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agent Peter J. Edwards
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
A computer-implemented method of estimating selectivity of a query may include generating, for data stored in a database in a memory, a one-dimensional value distribution for each of a plurality of attributes of the data. A multidimensional histogram may be generated, wherein the multidimensional histogram includes the one-dimensional value distributions for the plurality of attributes of the data. The multidimensional histogram may be converted to a one-dimensional histogram by assigning each bucket of the multidimensional histogram to corresponding buckets of the one-dimensional histogram and ordering the corresponding buckets according to a space-filling curve. One or more bucket ranges of the one-dimensional histogram may be determined by mapping the query conditions on the one-dimensional histogram. The selectivity of the query may be estimated by estimating how many data values in the one or more bucket ranges will meet the query conditions.
Public/Granted literature
- US20160110419A1 SELECTIVITY ESTIMATION FOR QUERY EXECUTION PLANNING IN A DATABASE Public/Granted day:2016-04-21
Information query