专利快速检索-快速检索全球专利，免费商用专利数据库-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. 发明授权

US09589041B2 Client and server integration for replicating data 有权
标题翻译：用于复制数据的客户端和服务器集成
公开(公告)号：US09589041B2
公开(公告)日：2017-03-07
申请号：US13951281
申请日：2013-07-25
申请人： Oracle International Corporation
发明人： Hung V. Tran , Lik Wong , Nimar Singh Arora , Thuvan Hoang , Edwina Ming-Yue Lu , Tianshu Li
IPC分类号： G06F17/00 , G06F17/30
CPC分类号： G06F17/30578 , G06F17/00
摘要： Techniques are provided for client and server integration for scalable replication. A replication client transmits change records to a database server over a stream. The database server determines at least one batch comprising change records for at least one transaction. The database server generates dependency data for at least one change record in a batch based on at least one constraint identifier for at least one column. The database server determines an ordered grouping of the change records based on an operation type of each change record and the dependency data of each change record, wherein change records sharing operation types are grouped together unless a division based on the dependency data is determined. The database server generates a reordered transaction comprising a plurality of reordered operations based on the ordered grouping of the change records of the particular batch.
摘要翻译：为客户端和服务器集成提供了可扩展复制的技术。复制客户端通过流将更改记录传输到数据库服务器。数据库服务器至少确定一个包含至少一个交易的更改记录的批次。数据库服务器基于至少一个列的至少一个约束标识符来为批次中的至少一个改变记录生成依赖性数据。数据库服务器基于每个改变记录的操作类型和每个改变记录的依赖性数据来确定改变记录的有序分组，其中改变记录共享操作类型被分组在一起，除非确定基于依赖性数据的划分。数据库服务器基于特定批次的改变记录的有序分组来生成包括多个重新排序的操作的重排序事务。

3. 发明授权

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

4. 发明申请

US20150032695A1 CLIENT AND SERVER INTEGRATION FOR REPLICATING DATA 有权
标题翻译：用于替换数据的客户端和服务器集成
公开(公告)号：US20150032695A1
公开(公告)日：2015-01-29
申请号：US13951281
申请日：2013-07-25
申请人： Oracle International Corporation
发明人： Hung V. Tran , Lik Wong , Nimar Singh Arora , Thuvan Hoang , Edwina Ming-Yue Lu , Tianshu Li
IPC分类号： G06F17/30
CPC分类号： G06F17/30578 , G06F17/00
摘要： Techniques are provided for client and server integration for scalable replication. A replication client transmits change records to a database server over a stream. The database server determines at least one batch comprising change records for at least one transaction. The database server generates dependency data for at least one change record in a batch based on at least one constraint identifier for at least one column. The database server determines an ordered grouping of the change records based on an operation type of each change record and the dependency data of each change record, wherein change records sharing operation types are grouped together unless a division based on the dependency data is determined. The database server generates a reordered transaction comprising a plurality of reordered operations based on the ordered grouping of the change records of the particular batch.
摘要翻译：为客户端和服务器集成提供了可扩展复制技术。复制客户端通过流将更改记录传输到数据库服务器。数据库服务器至少确定一个包含至少一个交易的更改记录的批次。数据库服务器基于至少一个列的至少一个约束标识符来为批次中的至少一个改变记录生成依赖性数据。数据库服务器基于每个改变记录的操作类型和每个改变记录的依赖性数据来确定改变记录的有序分组，其中改变记录共享操作类型被分组在一起，除非确定基于依赖性数据的划分。数据库服务器基于特定批次的改变记录的有序分组来生成包括多个重新排序的操作的重排序事务。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式