Invention Grant
- Patent Title: Data partitioning based on estimated growth
-
Application No.: US15970499Application Date: 2018-05-03
-
Publication No.: US10977212B2Publication Date: 2021-04-13
- Inventor: Peter Eberlein , Volker Driesen
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Fish & Richardson P.C.
- Main IPC: G06F16/13
- IPC: G06F16/13 ; G06F3/06 ; G06F17/10 ; G06F9/50 ; G06F11/34

Abstract:
During a first delta time period, monitoring a growth in a number of records and determining a highest-growth partition in the database. The highest-growth partition is divided into subranges. During a second delta time period, a growth is monitored for each subrange. For the subrange with a greatest growth, the subrange is subdivided into sub-subranges and a growth determined for each sub-subrange. The monitoring and the determining is repeated and further subdivisions made of divisions having the highest growths until growths have been recorded for N delta time periods. For each of the N delta time periods, weighted growths are determined for each subdivision. Expected record counts are determined for each of the divisions that are expected for a subsequent time period spanning the N delta time periods. Based on the expected record counts, a partition split point within the highest-growth partition is determined, and the highest-growth partition is split into two partitions.
Public/Granted literature
- US20190340260A1 DATA PARTITIONING BASED ON ESTIMATED GROWTH Public/Granted day:2019-11-07
Information query