公开(公告)号：US11226965B2

公开(公告)日：2022-01-18

申请号：US15964631

申请日：2018-04-27

Applicant: SAP SE

Inventor： William Zou ,  Reza Sherkat ,  John Smirnios ,  Mihnea Andrei

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.

公开(公告)号：US20190236192A1

公开(公告)日：2019-08-01

申请号：US15964631

申请日：2018-04-27

Applicant: SAP SE

Inventor： William Zou ,  Reza Sherkat ,  John Smirnios ,  Mihnea Andrei

IPC: G06F17/30

CPC classification number: G06F16/24554 ,  G06F16/2282 ,  G06F16/24556

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.