REPLICATION GROUP PARTITIONING

• US 20140279891A1
• Filed: 03/13/2013
• Published: 09/18/2014
• Est. Priority Date: 03/13/2013
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Fuh, You-Chin, Jin, Yi, Min, Hong, Zheng, Miao, Li, Xiao, Bourbonnais, Serge
• Granted Patent: US 11,151,164 B2
• Time in Patent Office: Days
• US Class Current: 707/633
• CPC Class Codes: G06F 16/278 Data partitioning, e.g. horizontal or vertical partitioning

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

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.

2. 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.

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

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

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

6. 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.

7. 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.

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

9. 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.

10-19. -19. (canceled)

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.