公开(公告)号：US20140040203A1

公开(公告)日：2014-02-06

申请号：US14052531

申请日：2013-10-11

Applicant: Oracle International Corporation

Inventor： Edwina M. Lu ,  James W. Stamos ,  Nimar S. Arora ,  Lik Wong ,  Haobo Xu ,  Thuvan Hoang ,  Byron Wang ,  Lakshminarayanan Chidambaran

IPC: G06F17/30

CPC classification number: G06F17/30575 ,  G06F17/30578

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.

Abstract translation: 描述了在数据库系统中复制数据的技术。 在示例实施例中，在目的地数据库处接收一组改变，其中该变更集合已经在源数据库处应用并且正在从源数据库复制到目的地数据库。 分析一组变化，并且确定该组更改包括以下两个或多个：行级更改的子集，语句级更改的子集以及过程级更改的子集。 至少在更改子集中包含的更改之间确定一组依赖关系。 更改子集中的更改分配给两个或多个处理元素。 通过相互并行并基于一组依赖关系执行两个或多个处理元件，将该组更改应用于目的地数据库。

公开(公告)号：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: 为依赖关系感知事务批处理提供数据复制技术。 读取与多个事务对应的多个变更记录。 生成交易间依赖关系数据，交易间依赖数据包括多个待处理事务之间的至少一个交易间依赖关系。 每个交易间依赖关系表示第一个事务依赖于第二个事务。 基于事务间依赖关系数据生成批处理。 批处理交易包括多个待处理事务中的至少一个待处理事务。 批处理事务被分配给被配置为并行应用批处理事务的多个应用进程的应用进程。

公开(公告)号：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.

公开(公告)号：US09569514B2

公开(公告)日：2017-02-14

申请号：US14052531

申请日：2013-10-11

Applicant: Oracle International Corporation

Inventor： Edwina M. Lu ,  James W. Stamos ,  Nimar S. Arora ,  Lik Wong ,  Haobo Xu ,  Thuvan Hoang ,  Byron Wang ,  Lakshminarayanan Chidambaran

IPC: G06F17/30

CPC classification number: G06F17/30575 ,  G06F17/30578

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.

Abstract translation: 描述了在数据库系统中复制数据的技术。 在示例实施例中，在目的地数据库处接收一组改变，其中该变更集合已经在源数据库处应用并且正在从源数据库复制到目的地数据库。 分析一组变化，并且确定该组更改包括以下两个或多个：行级更改的子集，语句级更改的子集以及过程级更改的子集。 至少在更改子集中包含的更改之间确定一组依赖关系。 更改子集中的更改分配给两个或多个处理元素。 通过相互并行并基于一组依赖关系执行两个或多个处理元件，将该组更改应用于目的地数据库。