Invention Grant
- Patent Title: Selectivity estimation of conjunctive predicates
-
Application No.: US16924455Application Date: 2020-07-09
-
Publication No.: US12105768B2Publication Date: 2024-10-01
- Inventor: Peter Lysakovski , Guido Moerkotte , Norman May , Diego Havenstein , Gabriele Steidl
- 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: G06F17/16
- IPC: G06F17/16 ; G06F16/242 ; G06F16/2453 ; G06F17/11

Abstract:
A system includes determination of a query comprising z predicates, determination of known selectivities of each of a set of conjuncts of the z predicates, and estimation of selectivities of all conjuncts of the z predicates based on the known selectivities and a recursive determination of Cx, where x represents selectivities of all complete conjuncts of the z predicates and C is a complete design matrix complete design matrix (ci,j)=1 if i⊆j, else 0, having indices [0, 2z−1].
Public/Granted literature
- US20220012302A1 SELECTIVITY ESTIMATION OF CONJUNCTIVE PREDICATES Public/Granted day:2022-01-13
Information query