# US 2014/0279891 A1 · Replication group partitioning

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

- Number: US 2014/0279891 A1
- Document ID: US20140279891A1
- Status: Published application
- Kind: A1
- Application number: 13/800,139
- Filed: 2013-03-13
- Published: 2014-09-18
- Earliest claimed: 2013-03-13
- Assignees: International Business Machines Corporation
- Inventors: Serge Bourbonnais; You-Chin Fuh; Yi Jin; Xiao Li; Hong Min; Miao Zheng
- Web page: https://patentgrep.com/patent/US20140279891A1

## CPC

- 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

Methods and systems for replication group partitioning include analyzing historical workload data for a plurality of data elements to generate one or more transaction patterns and generating a recommended partitioning of the plurality of data elements into one or more replication groups, based on the one or more transaction patterns, that are optimized toward a partitioning goal.

## Claims

### Claim 1

A method for replication group partitioning, comprising:
analyzing historical workload data for a plurality of data elements with a processor to identify and categorize one or more transaction patterns; and
generating a recommended partitioning of the plurality of data elements into one or more replication groups, based on the one or more transaction patterns, that are optimized toward a partitioning goal.

### Claim 2 (depends on 1)

The method of claim 1, further comprising receiving revisions to the recommended partitioning of the plurality of data elements from a user's input and generating a new recommended partitioning based on the received revisions.

### Claim 3 (depends on 1)

The method of claim 1, wherein the plurality of data elements are tables of tablespaces in a database.

### Claim 4 (depends on 1)

The method of claim 1, wherein the transaction patterns correspond to a group of transactions that updates a given set of data elements.

### Claim 5 (depends on 1)

The method of claim 1, wherein the partitioning goal comprises maintaining a predetermined affinity or separation between specific data elements.

### Claim 6 (depends on 1)

The method of claim 1, further comprising:
monitoring online workload changes; and
generating a new recommended partitioning based on said online workload changes to maintain an optimized partitioning goal.

### Claim 7 (depends on 1)

The method of claim 1, wherein generating a recommended partitioning comprises iteratively creating partition groups by selecting data elements according to one or more selection criteria.

### Claim 8 (depends on 1)

The method of claim 1, wherein generating a recommended partitioning comprises exhaustively evaluating every possible partitioning of the plurality of data elements.

### Claim 9 (depends on 1)

The method of claim 1, further comprising:
logging transactions that involve the plurality of data elements in a first data center; and
replicating the logged transactions in a second data center, where the replicated transactions are grouped according to the recommended partitioning.

### Claim at position 10

10-19. (canceled)

### Claim 20

A method for grouped data replication, comprising:
analyzing historical workload data for a plurality of data elements with a processor to identify and categorize one or more transaction patterns;
generating a recommended partitioning of the plurality of data elements into one or more replication groups, based on the one or more transaction patterns, that are optimized toward a partitioning goal;
logging transactions that involve the plurality of data elements in a first data center;
replicating the logged transactions in a second data center, where the replicated transactions are grouped according to the recommended partitioning;
monitoring online workload changes; and
generating a new recommended partitioning based on said online workload changes to maintain an optimized partitioning goal.