公开(公告)号：US07613740B2

公开(公告)日：2009-11-03

申请号：US11367761

申请日：2006-03-03

申请人： Bruce D. Holenstein ,  Gary E. Strickler ,  Eugene P. Jarema ,  Paul J. Holenstein

发明人： Bruce D. Holenstein ,  Gary E. Strickler ,  Eugene P. Jarema ,  Paul J. Holenstein

IPC分类号： H04L12/28 ,  H04L12/56 ,  G06F7/00 ,  G06F11/00 ,  G06F12/00 ,  G06F13/14 ,  G06F13/38 ,  G06F15/16 ,  G06F17/30

CPC分类号： G06F17/30581 ,  G06F11/2041 ,  G06F11/2097 ,  Y10S707/99952

摘要： A data replication engine is controlled in a system that replicates data associated with a plurality of transactions from a source database to a target database. The system includes a change queue that contains transaction data associated with the transactions. The system maintains one or more attributes outside of the change queue which are associated with transactions. One or more attributes outside of the change queue are identified which are associated with a transaction. The one or more of the identified attributes are then used to control the replication engine.

摘要翻译： 数据复制引擎在系统中被控制，该系统将与多个事务相关联的数据从源数据库复制到目标数据库。 该系统包括一个包含与事务关联的事务数据的更改队列。 系统维护与事务相关联的改变队列之外的一个或多个属性。 识别与事务相关联的改变队列之外的一个或多个属性。 然后使用一个或多个所标识的属性来控制复制引擎。

公开(公告)号：US20090177710A1

公开(公告)日：2009-07-09

申请号：US12403009

申请日：2009-03-12

申请人： Bruce D. HOLENSTEIN ,  Gary E. STRICKLER ,  Eugene P. JAREMA ,  Paul J. HOLENSTEIN

发明人： Bruce D. HOLENSTEIN ,  Gary E. STRICKLER ,  Eugene P. JAREMA ,  Paul J. HOLENSTEIN

IPC分类号： G06F17/30

CPC分类号： G06F17/30578 ,  Y10S707/99938 ,  Y10S707/99952 ,  Y10S707/99953

摘要： A method is provided for resolving collisions in a database replication system. The system includes a source database and a target database, wherein changes made at the source database are replicated to the target database. Each database has one or more tables, and at least one of the tables has multiple constraints. A collision is detected during data replication as a result of one of the tables having multiple constraints. One constraint that contributes to the collision is identified. The constraint that contributes to the collision is relaxed, or the cause of the constraint that contributes to the collision is removed. This process is repeated for all additional constraints that contribute to the collision. In this manner, the collision is resolved.

摘要翻译： 提供了一种解决数据库复制系统中的冲突的方法。 系统包括源数据库和目标数据库，其中源数据库所做的更改将复制到目标数据库。 每个数据库都有一个或多个表，至少有一个表有多个约束。 由于具有多个约束的表之一，在数据复制期间检测到冲突。 确定有助于碰撞的一个约束。 有助于碰撞的约束是放松的，或者有助于碰撞的约束的原因被消除。 对于有助于碰撞的所有其他约束，重复此过程。 以这种方式，解决了碰撞。

公开(公告)号：US07523110B2

公开(公告)日：2009-04-21

申请号：US11367757

申请日：2006-03-03

申请人： Bruce D. Holenstein ,  Gary E. Strickler ,  Eugene P. Jarema ,  Paul J. Holenstein

发明人： Bruce D. Holenstein ,  Gary E. Strickler ,  Eugene P. Jarema ,  Paul J. Holenstein

IPC分类号： H04L12/28 ,  H04L12/56 ,  G06F7/00 ,  G06F11/00 ,  G06F12/00 ,  G06F13/14 ,  G06F13/38 ,  G06F15/16 ,  G06F17/30

CPC分类号： G06F17/30578 ,  Y10S707/99938 ,  Y10S707/99952 ,  Y10S707/99953

摘要： Collisions are resolved in a database replication system. The system includes a plurality of nodes arranged in either a master-slave or network configuration. Each node includes a database, wherein changes made at the databases of each node are replicated to the databases at one or more of the other nodes. When a collision is detected during data replication between multiple nodes, the collision is resolved by a rule that gives precedence to certain nodes over other nodes.

摘要翻译： 冲突在数据库复制系统中解决。 该系统包括以主从或网络配置的多个节点。 每个节点包括数据库，其中在每个节点的数据库处进行的改变被复制到一个或多个其他节点处的数据库。 当在多个节点之间的数据复制期间检测到冲突时，通过比其他节点优先于某些节点的规则来解决冲突。

公开(公告)号：US08086661B2

公开(公告)日：2011-12-27

申请号：US12403009

申请日：2009-03-12

申请人： Bruce D. Holenstein ,  Gary E. Strickler ,  Eugene P. Jarema ,  Paul J. Holenstein

发明人： Bruce D. Holenstein ,  Gary E. Strickler ,  Eugene P. Jarema ,  Paul J. Holenstein

IPC分类号： G06F15/16

CPC分类号： G06F17/30578 ,  Y10S707/99938 ,  Y10S707/99952 ,  Y10S707/99953

摘要： A method is provided for resolving collisions in a database replication system. The system includes a source database and a target database, wherein changes made at the source database are replicated to the target database. Each database has one or more tables, and at least one of the tables has multiple constraints. A collision is detected during data replication as a result of one of the tables having multiple constraints. One constraint that contributes to the collision is identified. The constraint that contributes to the collision is relaxed, or the cause of the constraint that contributes to the collision is removed. This process is repeated for all additional constraints that contribute to the collision. In this manner, the collision is resolved.

摘要翻译： 提供了一种解决数据库复制系统中的冲突的方法。 系统包括源数据库和目标数据库，其中源数据库所做的更改将复制到目标数据库。 每个数据库都有一个或多个表，至少有一个表有多个约束。 由于具有多个约束的表之一，在数据复制期间检测到冲突。 确定有助于碰撞的一个约束。 有助于碰撞的约束是放松的，或者有助于碰撞的约束的原因被消除。 对于有助于碰撞的所有其他约束，重复此过程。 以这种方式，解决了碰撞。