公开(公告)号：US20150032695A1

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

申请号：US13951281

申请日：2013-07-25

Applicant: Oracle International Corporation

Inventor： Hung V. Tran ,  Lik Wong ,  Nimar Singh Arora ,  Thuvan Hoang ,  Edwina Ming-Yue Lu ,  Tianshu Li

IPC: G06F17/30

CPC classification number: G06F17/30578 ,  G06F17/00

Abstract: 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.

Abstract translation: 为客户端和服务器集成提供了可扩展复制技术。 复制客户端通过流将更改记录传输到数据库服务器。 数据库服务器至少确定一个包含至少一个交易的更改记录的批次。 数据库服务器基于至少一个列的至少一个约束标识符来为批次中的至少一个改变记录生成依赖性数据。 数据库服务器基于每个改变记录的操作类型和每个改变记录的依赖性数据来确定改变记录的有序分组，其中改变记录共享操作类型被分组在一起，除非确定基于依赖性数据的划分。 数据库服务器基于特定批次的改变记录的有序分组来生成包括多个重新排序的操作的重排序事务。

公开(公告)号：US09589041B2

公开(公告)日：2017-03-07

申请号：US13951281

申请日：2013-07-25

Applicant: Oracle International Corporation

Inventor： Hung V. Tran ,  Lik Wong ,  Nimar Singh Arora ,  Thuvan Hoang ,  Edwina Ming-Yue Lu ,  Tianshu Li

IPC: G06F17/00 ,  G06F17/30

CPC classification number: G06F17/30578 ,  G06F17/00

Abstract: 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.

Abstract translation: 为客户端和服务器集成提供了可扩展复制的技术。 复制客户端通过流将更改记录传输到数据库服务器。 数据库服务器至少确定一个包含至少一个交易的更改记录的批次。 数据库服务器基于至少一个列的至少一个约束标识符来为批次中的至少一个改变记录生成依赖性数据。 数据库服务器基于每个改变记录的操作类型和每个改变记录的依赖性数据来确定改变记录的有序分组，其中改变记录共享操作类型被分组在一起，除非确定基于依赖性数据的划分。 数据库服务器基于特定批次的改变记录的有序分组来生成包括多个重新排序的操作的重排序事务。