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

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

公开(公告)号：US20140081907A1

公开(公告)日：2014-03-20

申请号：US13622276

申请日：2012-09-18

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Hung V. Tran ,  Lik Wong ,  Edwina Ming-Yue Lu

IPC: G06F17/30

CPC classification number: G06F17/30575 ,  G06F17/30309

Abstract: Transient duplicate key violations of unique key constraints are handled during row updates. Row changes are buffered until a point is reached that those changes are safe to execute. Row changes are effectively reordered to avoid constraint violations during execution of updates. In response to receiving a constraint key violation from a server after an attempted update, a client locally stores a record containing information regarding the failed update. Later, in response to the lack of receipt of an error in response to another update to the same column of the same table, the client uses the information in this record to instruct the server to attempt to repeat a failed update that previously attempted to change the value of a row to a value that was present in a uniqueness-constrained column at the time of the failure, but is no longer present due to the successful update.

Abstract translation: 在行更新期间处理对唯一密钥约束的瞬态重复密钥违规。 行更改缓冲，直到达到这些更改才能执行的安全性。 行更改被有效地重新排序，以避免在执行更新期间发生约束违规。 响应于在尝试更新之后从服务器接收到约束密钥冲突，客户端本地存储包含关于故障更新的信息的记录。 之后，为了响应对同一表的同一列的另一次更新而收到错误的响应，客户端使用该记录中的信息来指示服务器尝试重复以前尝试更改的故障更新 一行的值在故障时存在于唯一性受限列中但由于更新成功而不再存在的值。

公开(公告)号：US09965535B2

公开(公告)日：2018-05-08

申请号：US13622276

申请日：2012-09-18

Applicant: Oracle International Corporation

Inventor： Hung V. Tran ,  Lik Wong ,  Edwina Ming-Yue Lu

IPC: G06F17/30

CPC classification number: G06F17/30575 ,  G06F17/30309

Abstract: Transient duplicate key violations of unique key constraints are handled during row updates. Row changes are buffered until a point is reached that those changes are safe to execute. Row changes are effectively reordered to avoid constraint violations during execution of updates. In response to receiving a constraint key violation from a server after an attempted update, a client locally stores a record containing information regarding the failed update. Later, in response to the lack of receipt of an error in response to another update to the same column of the same table, the client uses the information in this record to instruct the server to attempt to repeat a failed update that previously attempted to change the value of a row to a value that was present in a uniqueness-constrained column at the time of the failure, but is no longer present due to the successful update.

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