System and method for replication log branching avoidance using post-failover rejoin
US-9489434-B1 · Nov 8, 2016 · US
US11151164B2 · US · B2
| Field | Value |
|---|---|
| Publication number | US-11151164-B2 |
| Application number | US-201313800139-A |
| Country | US |
| Kind code | B2 |
| Filing date | Mar 13, 2013 |
| Priority date | Mar 13, 2013 |
| Publication date | Oct 19, 2021 |
| Grant date | Oct 19, 2021 |
A practical reading order for non-experts. Skip the full description unless you need deep technical detail.
What the patent document calls the invention.
A short plain-language summary of the technical disclosure.
Who owns or filed the patent and who is credited as inventor.
Filing, priority, publication, and grant dates set the timeline.
The legal scope of protection — read this for what is actually claimed.
Technology tags used to group this patent with similar filings.
Prior art links and similar publications in this corpus.
Official abstract text for this publication.
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.
Opening claim text (preview).
What is claimed is: 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, each transaction pattern corresponding to a particular group of transactions that updates the same data elements and having a corresponding peak throughput; generating a recommended partitioning of the plurality of data elements into one or more replication groups, based on the peak throughputs of the one or more transaction patterns, that are optimized toward a partitioning goal; and 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. 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 or 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. 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, each having a respective peak throughput; generating a recommended partitioning of the plurality of data elements into one or more replication groups, based on the peak throughputs of the one or more transaction patterns, that are optimized toward a partitioning goal, each transaction pattern corresponding to a particular group of transactions that updates the same data elements; 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.
Data partitioning, e.g. horizontal or vertical partitioning · CPC title
Related publications grouped by family.
Answers are generated from the same data shown on this page.