- 专利标题: Non-homogenous synopsis for efficient partition pruning
-
申请号: US15964631申请日: 2018-04-27
-
公开(公告)号: US11226965B2公开(公告)日: 2022-01-18
- 发明人: William Zou , Reza Sherkat , John Smirnios , Mihnea Andrei
- 申请人: SAP SE
- 申请人地址: DE Walldorf
- 专利权人: SAP SE
- 当前专利权人: SAP SE
- 当前专利权人地址: DE Walldorf
- 代理机构: Sterne, Kessler, Goldstein & Fox P.L.L.C.
- 主分类号: G06F16/2455
- IPC分类号: G06F16/2455 ; G06F16/22
摘要:
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 NON-HOMOGENOUS SYNOPSIS FOR EFFICIENT PARTITION PRUNING 公开/授权日:2019-08-01
信息查询