Techniques for combining statement level, procedural, and row level replication
US8589346B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Apr 26, 2011 |
| Grant date | Nov 19, 2013 |
| Priority date | — |
| Expiry date | Sep 27, 2031 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/273
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Techniques for replicating data in database systems are described. In an example embodiment, a set of changes is received at a destination database, where the set of changes has been applied at a source database and is being replicated from the source database to the destination database. The set of changes is analyzed and it is determined that the set of changes includes two or more of: a subset of row-level changes, a subset of statement-level changes, and a subset of procedure-level changes. A set of dependencies is determined at least between the changes that are included in the subsets of changes. The changes, in the subsets of changes, are assigned to two or more processing elements. The set of changes is applied to the destination database by executing the two or more processing elements in parallel to each other and based on the set of dependencies.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.