Invention Grant
- Patent Title: Non-homogenous synopsis for efficient partition pruning
-
Application No.: US15964631Application Date: 2018-04-27
-
Publication No.: US11226965B2Publication Date: 2022-01-18
- Inventor: William Zou , Reza Sherkat , John Smirnios , Mihnea Andrei
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Sterne, Kessler, Goldstein & Fox P.L.L.C.
- Main IPC: G06F16/2455
- IPC: G06F16/2455 ; G06F16/22

Abstract:
Disclosed herein are system, method, and computer program product embodiments for partition pruning via non-homogenous synopsis information. An embodiment operates by maintaining synopsis information for a data partition in accordance with a first synopsis strategy, monitoring performance of the synopsis information within a partition pruning system, determining that the performance of the synopsis information is insufficient, and updating the synopsis information in accordance with a second synopsis strategy better suited for the attributes of the data partition. In some embodiments, a first data partition of a partitioned data table may employ a first synopsis strategy and a second data partition of the partitioned data table may employ a second synopsis strategy.
Public/Granted literature
- US20190236192A1 NON-HOMOGENOUS SYNOPSIS FOR EFFICIENT PARTITION PRUNING Public/Granted day:2019-08-01
Information query