公开(公告)号：US20150032694A1

公开(公告)日：2015-01-29

申请号：US13950207

申请日：2013-07-24

Applicant: Oracle International Corporation

Inventor： Vasanth Rajamani ,  Lik Wong ,  Nimar S. Arora ,  Sean Lehouillier

IPC: G06F17/30

CPC classification number: G06F17/30581 ,  G06F17/30368

Abstract: Parallel logical replication involves multiple apply threads running on a destination database server applying, in parallel, changes made by source transactions, where the changes of a single source transaction may be applied in parallel by multiple apply threads. An apply transaction for a source transaction may be committed by an apply thread independently of the commitment of any other apply transaction of the source transaction, that is, without coordinating the committing of another apply transaction executed by another apply thread for the source transaction. A configuration language is used to configure parallel logical replication. The language facilitates the configuration of various aspects of parallel logical replication, including the number of apply threads, partitioning schemes for the apply threads for partitioning change records between the apply threads, and various other aspects of parallel logical replication.

Abstract translation: 并行逻辑复制涉及在目标数据库服务器上运行的多个应用线程，并行地应用源事务所做的更改，其中单个源事务的更改可以由多个应用线程并行应用。 源事务的应用事务可以由应用线程提交，独立于源事务的任何其他应用事务的承诺，即，不协调由源事务的另一应用线程执行的另一应用事务的提交。 配置语言用于配置并行逻辑复制。 该语言有助于并行逻辑复制的各个方面的配置，包括应用线程的数量，应用线程的分区方案，用于分区应用线程之间的更改记录以及并行逻辑复制的各种其他方面。

公开(公告)号：US09830372B2

公开(公告)日：2017-11-28

申请号：US13950207

申请日：2013-07-24

Applicant: Oracle International Corporation

Inventor： Vasanth Rajamani ,  Lik Wong ,  Nimar S. Arora ,  Sean Lehouillier

IPC: G06F17/30

CPC classification number: G06F17/30581 ,  G06F17/30368

Abstract: Parallel logical replication involves multiple apply threads running on a destination database server applying, in parallel, changes made by source transactions, where the changes of a single source transaction may be applied in parallel by multiple apply threads. An apply transaction for a source transaction may be committed by an apply thread independently of the commitment of any other apply transaction of the source transaction, that is, without coordinating the committing of another apply transaction executed by another apply thread for the source transaction. A configuration language is used to configure parallel logical replication. The language facilitates the configuration of various aspects of parallel logical replication, including the number of apply threads, partitioning schemes for the apply threads for partitioning change records between the apply threads, and various other aspects of parallel logical replication.

公开(公告)号：US10191932B2

公开(公告)日：2019-01-29

申请号：US14222373

申请日：2014-03-21

Applicant: Oracle International Corporation

Inventor： Sean Lehouillier ,  Hung V. Tran ,  Vasanth Rajamani ,  Nimar S. Arora ,  Lik Wong

IPC: G06F9/46 ,  G06F17/30

Abstract: Techniques are provided for dependency-aware transaction batching for data replication. A plurality of change records corresponding to a plurality of transactions is read. Inter-transaction dependency data is generated, the inter-transaction dependency data including at least one inter-transaction dependency relationship between a plurality of pending transactions. Each inter-transaction dependency relationship indicates that a first transaction is dependent on a second transaction. A batch transaction is generated based on the inter-transaction dependency data. The batch transaction includes at least one pending transaction of the plurality of pending transactions. The batch transaction is assigned to an apply process of a plurality of apply processes configured to apply batch transactions in parallel.

公开(公告)号：US20150269215A1

公开(公告)日：2015-09-24

申请号：US14222373

申请日：2014-03-21

Applicant: Oracle International Corporation

Inventor： Sean Lehouillier ,  Hung V. Tran ,  Vasanth Rajamani ,  Nimar S. Arora ,  Lik Wong

IPC: G06F17/30

CPC classification number: G06F17/30368 ,  G06F17/3038 ,  G06F17/3053 ,  G06F17/30575 ,  G06F17/30581 ,  G06F17/30864

Abstract: Techniques are provided for dependency-aware transaction batching for data replication. A plurality of change records corresponding to a plurality of transactions is read. Inter-transaction dependency data is generated, the inter-transaction dependency data including at least one inter-transaction dependency relationship between a plurality of pending transactions. Each inter-transaction dependency relationship indicates that a first transaction is dependent on a second transaction. A batch transaction is generated based on the inter-transaction dependency data. The batch transaction includes at least one pending transaction of the plurality of pending transactions. The batch transaction is assigned to an apply process of a plurality of apply processes configured to apply batch transactions in parallel.

Abstract translation: 为依赖关系感知事务批处理提供数据复制技术。 读取与多个事务对应的多个变更记录。 生成交易间依赖关系数据，交易间依赖数据包括多个待处理事务之间的至少一个交易间依赖关系。 每个交易间依赖关系表示第一个事务依赖于第二个事务。 基于事务间依赖关系数据生成批处理。 批处理交易包括多个待处理事务中的至少一个待处理事务。 批处理事务被分配给被配置为并行应用批处理事务的多个应用进程的应用进程。