# US 2025/0165450 A1 · Self-maintained tablespace

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2025/0165450 A1
- Document ID: US20250165450A1
- Status: Published application
- Kind: A1
- Application number: 18/513,985
- Filed: 2023-11-20
- Published: 2025-05-22
- Earliest claimed: 2023-11-20
- Assignees: International Business Machines Corporation
- Applicants: International Business Machines Corporation
- Inventors: Sheng Yan Sun; Peng Hui Jiang; Jie Ling; Shan Jiang; Yu Huang; Yan Li Ma
- Web page: https://patentgrep.com/patent/US20250165450A1

## CPC

- G06F 16/2282: {Tablespace storage structures; Management thereof}
- G06F 16/278: {Data partitioning, e.g. horizontal or vertical partitioning}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A system, method, and computer program product are configured to: provide a tablespace comprising an original partition having a lower boundary L, an upper boundary U, a split percentage P, and a split ratio R; and in response to the original partition reaching a fullness of P, automatically split the original partition to a first progeny partition and a second progeny partition, wherein the first progeny partition has a lower boundary L1 that is the same as the lower boundary L of the original partition and an upper boundary U1 that is determined based on whether the insert is a sequential or random insert, and wherein the second progeny partition has an upper boundaries U2 that is the same as the upper boundary U of the original partition and a lower boundary L2 that is determined based on whether the insert is a sequential or random insert.

## Claims

### Claim 1

A computer-implemented method, comprising
training, by a processor set, a machine learning model using a machine learning classification algorithm which uses an existing predicted split percentage and an existing predicted split ratio of a tablespace, wherein the machine learning model is continuously trained after every split to determine a predicted split percentage and a predicated split ratio for a next split event;
providing, by the processor set, the tablespace comprising an original partition, the original partition having a lower boundary L, an upper boundary U, a split percentage P, and a split ratio R using the trained machine learning model; and
in response to the original partition reaching a fullness of P, automatically splitting, by the processor set, the original partition to a first progeny partition and a second progeny partition, wherein the first progeny partition has a lower boundary L1 that is the same as the lower boundary L of the original partition and an upper boundary U1 that is determined based on whether an insert is a sequential insert or a random insert, and
wherein the second progeny partition has an upper boundary U2 that is the same as the upper boundary U of the original partition and a lower boundary L2 that is determined based on whether the insert is the sequential insert or the random insert.

### Claim 2 (depends on 1)

The computer-implemented method of claim 1, further comprising collecting, by the processor set, data history of the tablespace, wherein the data history comprises historical input values for queries, previous workload, previous tablespace extension data, and previous split data, wherein the split percentage P and the split ratio R are determined by the trained machine learning model.

### Claim 3 (depends on 2)

The computer-implemented method of claim 2, wherein the trained machine learning model considers partition size, history of insert volume, frequency of insert on the original partition, and history of elapsed time of a split to determine the split percentage P, and the trained machine learning model further comprises an artificial neural network.

### Claim 4 (depends on 2)

The computer-implemented method of claim 2, wherein the trained machine learning model considers history of insert distribution and current key distribution of the original partition to determine the split ratio R.

### Claim 5 (depends on 2)

The computer-implemented method of claim 2, wherein the first progeny partition and the second progeny partition retain the split percentage P and the split ratio R.

### Claim 6 (depends on 1)

The computer-implemented method of claim 1, wherein in response to the insert being the random insert, the upper boundary U1 of the first progeny partition is (U−1)/2−1, and the lower boundary L2 of the second progeny partition is (U−1)/2.

### Claim 7 (depends on 1)

The computer-implemented method of claim 1, wherein in response to the insert being the sequential insert and the original partition being a middle partition, the upper boundary U1 of the first progeny partition is R*U, and the lower boundary L2 of the second progeny partition is R*U+1.

### Claim 8 (depends on 1)

The computer-implemented method of claim 1, wherein in response to the insert being an ascending sequential insert and the original partition being a first partition or last partition, the upper boundary U1 of the first progeny partition is an index i of a last insert recorded in the original partition, and the lower boundary L2 of the second progeny partition is i+1.

### Claim 9 (depends on 1)

The computer-implemented method of claim 1, wherein in response to the insert being a descending sequential insert and the original partition being a first partition or last partition, the lower boundary L2 of the second progeny partition is an index i of a last insert recorded in the original partition, and upper boundary U1 of the first progeny partition is i−1.

### Claim 10

A computer program product comprising one or more computer readable storage media having program instructions collectively stored on the one or more computer readable storage media, the program instructions executable to:
train a machine learning model using a machine learning classification algorithm which uses an existing predicted split percentage and an existing predicted split ratio of a tablespace, wherein the machine learning model is trained after a split to determine a predicted split percentage and a predicated split ratio for a next split event;
provide the tablespace comprising an original partition, the original partition having a lower boundary L, an upper boundary U, a split percentage P, and a split ratio R using the trained machine learning model; and
in response to the original partition reaching a fullness of P, automatically split the original partition to a first progeny partition and a second progeny partition,
wherein the first progeny partition has a lower boundary L1 that is the same as the lower boundary L of the original partition and an upper boundary U1 that is determined based on whether an insert is a sequential insert or a random insert, and
wherein the second progeny partition has an upper boundaries U2 that is the same as the upper boundary U of the original partition and a lower boundary L2 that is determined based on whether the insert is the sequential insert or the random insert.

### Claim 11 (depends on 10)

The computer program product of claim 10, further comprising further comprising collecting, by the processor set, data history of the tablespace, and the data history comprises historical input values for queries, previous workload, previous tablespace extension data, and previous split data, wherein in response to the insert being the random insert, the upper boundary U1 of the first progeny partition is (U−1)/2−1, and the lower boundary L2 of the second progeny partition is (U−1)/2.

### Claim 12 (depends on 10)

The computer program product of claim 10, wherein in response to the insert being the sequential insert and the original partition being a middle partition, the upper boundary U1 of the first progeny partition is R*U, and the lower boundary L2 of the second progeny partition is R*U+1, and the trained machine learning model further comprises an artificial neural network.

### Claim 13 (depends on 10)

The computer program product of claim 10, wherein in response to the insert being an ascending sequential insert and the original partition being a first partition or last partition, the upper boundary U1 of the first progeny partition is an index i of a last insert recorded in the original partition, and the lower boundary L2 of the second progeny partition is i+1.

### Claim 14 (depends on 10)

The computer program product of claim 10, wherein in response to the insert being a descending sequential insert and the original partition being a first partition or last partition, the lower boundary L2 of the second progeny partition is an index i of a last insert recorded in the original partition, and upper boundary U1 of the first progeny partition is i−1.

### Claim 15

A system comprising a processor set, one or more computer readable storage media, and program instructions collectively stored on the one or more computer readable storage media, the program instructions executable to:
train a machine learning model using a machine learning classification algorithm which uses an existing predicted split percentage and an existing predicted split ratio of a tablespace, wherein the machine learning model is continuously trained after every split to determine a predicted split percentage and a predicated split ratio for a next split event;
provide the tablespace comprising an original partition, the original partition having a lower boundary L, an upper boundary U, a split percentage P, and a split ratio R using the trained machine learning model; and
in response to the original partition reaching a fullness of P, automatically split the original partition to a first progeny partition and a second progeny partition.

### Claim 16 (depends on 15)

The system of claim 15, further comprising collecting, by the processor set, data history of the tablespace, and the data history comprises historical input values for queries, previous workload, previous tablespace extension data, and previous split data,
wherein the first progeny partition has a lower boundary L1 that is the same as the lower boundary L of the original partition and an upper boundary U1 that is determined based on whether an insert is a sequential insert or a random insert,
wherein the second progeny partition has an upper boundaries U2 that is the same as the upper boundary U of the original partition and a lower boundary L2 that is determined based on whether the insert is the sequential insert or the random insert, and
wherein when the insert is a random insert, the upper boundary U1 of the first progeny partition is (U−1)/2−1, and the lower boundary L2 of the second progeny partition is (U−1)/2.

### Claim 17 (depends on 15)

The system of claim 15, wherein the first progeny partition has a lower boundary L1 that is the same as the lower boundary L of the original partition and an upper boundary U1 that is determined based on whether an insert is a sequential insert or a random insert,
wherein the second progeny partition has an upper boundaries U2 that is the same as the upper boundary U of the original partition and a lower boundary L2 that is determined based on whether the insert is the sequential insert or the random insert, and
wherein in response to the insert being a sequential insert and the original partition being a middle partition, the upper boundary U1 of the first progeny partition is R*U, and the lower boundary L2 of the second progeny partition is R*U+1.

### Claim 18 (depends on 15)

The system of claim 15, wherein the first progeny partition has a lower boundary L1 that is the same as the lower boundary L of the original partition and an upper boundary U1 that is determined based on whether an insert is a sequential insert or a random insert,
wherein the second progeny partition has an upper boundaries U2 that is the same as the upper boundary U of the original partition and a lower boundary L2 that is determined based on whether the insert is the sequential insert or the random insert, and
wherein in response to the insert being an ascending sequential insert and the original partition being a first partition or last partition, the upper boundary U1 of the first progeny partition is an index i of a last insert recorded in the original partition, and the lower boundary L2 of the second progeny partition is i+1.

### Claim 19 (depends on 15)

The system of claim 15, wherein the first progeny partition has a lower boundary L1 that is the same as the lower boundary L of the original partition and an upper boundary U1 that is determined based on whether an insert is a sequential insert or a random insert,
wherein the second progeny partition has an upper boundaries U2 that is the same as the upper boundary U of the original partition and a lower boundary L2 that is determined based on whether the insert is the sequential insert or the random insert, and
wherein in response to the insert being an descending sequential insert and the original partition being a first partition or last partition, the lower boundary L2 of the second progeny partition is an index i of a last insert recorded in the original partition, and upper boundary U1 of the first progeny partition is i−1.

### Claim 20 (depends on 15)

The system of claim 15, wherein the split percentage P and the split ratio R are determined by the trained machine learning model, and the trained machine learning model further comprises an artificial neural network.
