# US 2015/0106407 A1 · Policy based automatic physical schema management

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

- Number: US 2015/0106407 A1
- Document ID: US20150106407A1
- Status: Published application
- Kind: A1
- Application number: 14/051,260
- Filed: 2013-10-10
- Published: 2015-04-16
- Earliest claimed: 2013-10-10
- Assignees: International Business Machines Corporation
- Applicants: International Business Machines Corporation
- Inventors: Lynette D. ADAYILAMURIYIL; Marco GRECO; John F. MILLER, III; Raghupathi K. MURTHY; Sitaram VEMULAPALLI
- Web page: https://patentgrep.com/patent/US20150106407A1

## CPC

- G06F 16/284: {Relational databases}
- G06F 16/211: {Schema design and management}
- G06F 16/2282: {Tablespace storage structures; Management thereof}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

Provided are techniques for cyclic based data partitioning policy with automatic physical schema management. A data partitioning policy for data is received, wherein the data partitioning policy identifies a condition for automatically implementing the data partitioning policy and criteria for modifying a set of partitions. In response to the condition occurring, the data partitioning policy is automatically applied to select at least one partition from the set of partitions based on the criteria. An operation is performed on the at least one partition to modify the set of partitions.

## Claims

### Claim at position 1

1-8. (canceled)

### Claim 9

A computer program product, the computer program product comprising a computer readable storage medium having program code embodied therewith, the program code executable by at least one processor to perform:
receiving a data partitioning policy for data, wherein the data partitioning policy identifies a condition for automatically implementing the data partitioning policy and criteria for modifying a set of partitions for a table;
in response to the condition occurring, automatically applying the data partitioning policy to select at least one partition from the set of partitions based on the criteria; and
performing an operation on the at least one partition to modify the set of partitions.

### Claim 10 (depends on 9)

The computer program product of claim 9, wherein the operation is at least one of creating the at least one partition, attaching the at least one partition to the set of partitions, detaching the at least one partition from the set of partitions, dropping the at least one partition from the set of partitions, discarding the at least one partition from the list of partitions, and modifying the at least one partition.

### Claim 11 (depends on 10)

The computer program product of claim 10, wherein the program code is executable by the at least one processor to perform:
in response to one of attaching the at least one partition to the set of partitions and detaching the at least one partition from the set of partitions, collecting statistics for data remaining in the table.

### Claim 12 (depends on 11)

The computer program product of claim 11, wherein attaching the at least one partition to the set of partitions and detaching the at least one partition from the set of partitions are performed while at least one other user is accessing the table.

### Claim 13 (depends on 9)

The computer program product of claim 9, wherein the criteria is based on determining one of (1) that a number of interval partitions exceeds a specified quantity and (2) that a total storage allocated to the table storing the data exceeds a specified size.

### Claim 14 (depends on 9)

The computer program product of claim 9, wherein the program code is executable at least in part by a Software as a Service (SaaS) offering.

### Claim 15

A computer system, comprising:
one or more processors, one or more computer-readable memories and one or more computer-readable, tangible storage devices; and
program instructions, stored on at least one of the one or more computer-readable, tangible storage devices for execution by at least one of the one or more processors via at least one of the one or more memories, to perform operations, wherein the operations comprise:
receiving a data partitioning policy for data, wherein the data partitioning policy identifies a condition for automatically implementing the data partitioning policy and criteria for modifying a set of partitions for a table;
in response to the condition occurring, automatically applying the data partitioning policy to select at least one partition from the set of partitions based on the criteria; and
performing an operation on the at least one partition to modify the set of partitions.

### Claim 16 (depends on 15)

The computer system of claim 15, wherein the operation is at least one of creating the at least one partition, attaching the at least one partition to the set of partitions, detaching the at least one partition from the set of partitions, dropping the at least one partition from the set of partitions, discarding the at least one partition from the list of partitions, and modifying the at least one partition.

### Claim 17 (depends on 16)

The computer system of claim 16, wherein the operations further comprise:
in response to one of attaching the at least one partition to the set of partitions and detaching the at least one partition from the set of partitions, collecting statistics for data remaining in the table.

### Claim 18 (depends on 17)

The computer system of claim 17, wherein attaching the at least one partition to the set of partitions and detaching the at least one partition from the set of partitions are performed while at least one other user is accessing the table.

### Claim 19 (depends on 15)

The computer system of claim 15, wherein the criteria is based on determining one of (1) that a number of interval partitions exceeds a specified quantity and (2) that a total storage allocated to a table storing the data exceeds a specified size.

### Claim 20 (depends on 15)

The computer system of claim 15, wherein the program instructions are executable at least in part by a Software as a Service (SaaS) offering.

### Claim 21 (depends on 15)

The computer system of claim 15, wherein the cyclic based data partitioning policy is defined by specifying at least one of: how many partitions to keep in the table, a maximum size of the table, whether any detached partitions are to be one of dropped and preserved, and where new partitions are to be stored.

### Claim 22 (depends on 15)

The computer system of claim 15, wherein the condition is one of an elapsed amount of time and a numerical value specifying a portion of data to be retained.

### Claim 23 (depends on 9)

The computer program product of claim 9, wherein the cyclic based data partitioning policy is defined by specifying at least one of: how many partitions to keep in the table, a maximum size of the table, whether any detached partitions are to be one of dropped and preserved, and where new partitions are to be stored.

### Claim 24 (depends on 9)

The computer program product of claim 9, wherein the condition is one of an elapsed amount of time and a numerical value specifying a portion of data to be retained.
