专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明申请

US20140040203A1 STATEMENT-LEVEL AND PROCEDURAL-LEVEL REPLICATION 有权
标题翻译：声明级和程序级别的复制
公开(公告)号：US20140040203A1
公开(公告)日：2014-02-06
申请号：US14052531
申请日：2013-10-11
申请人： Oracle International Corporation
发明人： Edwina M. Lu , James W. Stamos , Nimar S. Arora , Lik Wong , Haobo Xu , Thuvan Hoang , Byron Wang , Lakshminarayanan Chidambaran
IPC分类号： G06F17/30
CPC分类号： G06F17/30575 , G06F17/30578
摘要： 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.
摘要翻译：描述了在数据库系统中复制数据的技术。在示例实施例中，在目的地数据库处接收一组改变，其中该变更集合已经在源数据库处应用并且正在从源数据库复制到目的地数据库。分析一组变化，并且确定该组更改包括以下两个或多个：行级更改的子集，语句级更改的子集以及过程级更改的子集。至少在更改子集中包含的更改之间确定一组依赖关系。更改子集中的更改分配给两个或多个处理元素。通过相互并行并基于一组依赖关系执行两个或多个处理元件，将该组更改应用于目的地数据库。

2. 发明授权

US10191932B2 Dependency-aware transaction batching for data replication 有权
公开(公告)号：US10191932B2
公开(公告)日：2019-01-29
申请号：US14222373
申请日：2014-03-21
申请人： Oracle International Corporation
发明人： Sean Lehouillier , Hung V. Tran , Vasanth Rajamani , Nimar S. Arora , Lik Wong
IPC分类号： G06F9/46 , G06F17/30
摘要： 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.

3. 发明申请

US20150269215A1 DEPENDENCY-AWARE TRANSACTION BATCHING FOR DATA REPLICATION 审中-公开
标题翻译：用于数据复制的独立交易批处理
公开(公告)号：US20150269215A1
公开(公告)日：2015-09-24
申请号：US14222373
申请日：2014-03-21
申请人： Oracle International Corporation
发明人： Sean Lehouillier , Hung V. Tran , Vasanth Rajamani , Nimar S. Arora , Lik Wong
IPC分类号： G06F17/30
CPC分类号： G06F17/30368 , G06F17/3038 , G06F17/3053 , G06F17/30575 , G06F17/30581 , G06F17/30864
摘要： 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.
摘要翻译：为依赖关系感知事务批处理提供数据复制技术。读取与多个事务对应的多个变更记录。生成交易间依赖关系数据，交易间依赖数据包括多个待处理事务之间的至少一个交易间依赖关系。每个交易间依赖关系表示第一个事务依赖于第二个事务。基于事务间依赖关系数据生成批处理。批处理交易包括多个待处理事务中的至少一个待处理事务。批处理事务被分配给被配置为并行应用批处理事务的多个应用进程的应用进程。

4. 发明申请

US20150032694A1 Scalable Coordination Aware Static Partitioning For Database Replication 有权
标题翻译：可扩展协调感知数据库复制的静态分区
公开(公告)号：US20150032694A1
公开(公告)日：2015-01-29
申请号：US13950207
申请日：2013-07-24
申请人： Oracle International Corporation
发明人： Vasanth Rajamani , Lik Wong , Nimar S. Arora , Sean Lehouillier
IPC分类号： G06F17/30
CPC分类号： G06F17/30581 , G06F17/30368
摘要： 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.
摘要翻译：并行逻辑复制涉及在目标数据库服务器上运行的多个应用线程，并行地应用源事务所做的更改，其中单个源事务的更改可以由多个应用线程并行应用。源事务的应用事务可以由应用线程提交，独立于源事务的任何其他应用事务的承诺，即，不协调由源事务的另一应用线程执行的另一应用事务的提交。配置语言用于配置并行逻辑复制。该语言有助于并行逻辑复制的各个方面的配置，包括应用线程的数量，应用线程的分区方案，用于分区应用线程之间的更改记录以及并行逻辑复制的各种其他方面。

5. 发明授权

US09830372B2 Scalable coordination aware static partitioning for database replication 有权
公开(公告)号：US09830372B2
公开(公告)日：2017-11-28
申请号：US13950207
申请日：2013-07-24
申请人： Oracle International Corporation
发明人： Vasanth Rajamani , Lik Wong , Nimar S. Arora , Sean Lehouillier
IPC分类号： G06F17/30
CPC分类号： G06F17/30581 , G06F17/30368
摘要： 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.

6. 发明授权

US09569514B2 Statement-level and procedural-level replication 有权
标题翻译：语句级和程序级复制
公开(公告)号：US09569514B2
公开(公告)日：2017-02-14
申请号：US14052531
申请日：2013-10-11
申请人： Oracle International Corporation
发明人： Edwina M. Lu , James W. Stamos , Nimar S. Arora , Lik Wong , Haobo Xu , Thuvan Hoang , Byron Wang , Lakshminarayanan Chidambaran
IPC分类号： G06F17/30
CPC分类号： G06F17/30575 , G06F17/30578
摘要： 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.
摘要翻译：描述了在数据库系统中复制数据的技术。在示例实施例中，在目的地数据库处接收一组改变，其中该变更集合已经在源数据库处应用并且正在从源数据库复制到目的地数据库。分析一组变化，并且确定该组更改包括以下两个或多个：行级更改的子集，语句级更改的子集以及过程级更改的子集。至少在更改子集中包含的更改之间确定一组依赖关系。更改子集中的更改分配给两个或多个处理元素。通过相互并行并基于一组依赖关系执行两个或多个处理元件，将该组更改应用于目的地数据库。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式