-
公开(公告)号:US09189534B2
公开(公告)日:2015-11-17
申请号:US13230381
申请日:2011-09-12
IPC分类号: G06F17/30
CPC分类号: G06F17/30587 , G06F17/30575
摘要: Techniques are provided for resynchronizing instances of a replicated table. In one embodiment, a database server is provided as a member of a plurality of communicatively coupled database servers. Each database server is configured to support a replicating mode of operation and a non-replicating mode of operation. The instances of the replicated table are resynchronized responsive to a user request, without stopping any of the plurality of database servers and without requiring any of the plurality of database servers to operate in the non-replicating mode of operation.
摘要翻译: 提供技术用于重新同步复制表的实例。 在一个实施例中,数据库服务器被提供为多个通信耦合的数据库服务器的成员。 每个数据库服务器被配置为支持复制操作模式和非复制操作模式。 复制表的实例响应于用户请求重新同步,而不停止多个数据库服务器中的任何一个,并且不要求多个数据库服务器中的任何一个以非复制操作模式操作。
-
公开(公告)号:US08554730B2
公开(公告)日:2013-10-08
申请号:US13194393
申请日:2011-07-29
CPC分类号: G06F17/30575 , G06F17/30578
摘要: Techniques are disclosed for adding a key column to a table to be replicated, where the key column stores key values for use in replication. In one embodiment, a request is received to add a table to a replication domain, such that the table is replicated from a first database server to at least a second database server. Key values are generated for both existing records and new records subsequently requested to be inserted into the table, respectively. Each generated key value is unique across the replication domain. Further, the key column may be added to the table without requiring exclusive access to the table.
摘要翻译: 公开了将关键列添加到要复制的表的技术,其中键列存储用于复制的键值。 在一个实施例中,接收到将请求添加到复制域的请求,使得表从第一数据库服务器复制到至少第二数据库服务器。 为现有记录和随后请求插入表中的新记录分别生成键值。 每个生成的密钥值在复制域中是唯一的。 此外,密钥列可以被添加到表中,而不需要对表的独占访问。
-
公开(公告)号:US20130031051A1
公开(公告)日:2013-01-31
申请号:US13194393
申请日:2011-07-29
IPC分类号: G06F7/00
CPC分类号: G06F17/30575 , G06F17/30578
摘要: Techniques are disclosed for adding a key column to a table to be replicated, where the key column stores key values for use in replication. In one embodiment, a request is received to add a table to a replication domain, such that the table is replicated from a first database server to at least a second database server. Key values are generated for both existing records and new records subsequently requested to be inserted into the table, respectively. Each generated key value is unique across the replication domain. Further, the key column may be added to the table without requiring exclusive access to the table.
摘要翻译: 公开了将关键列添加到要复制的表的技术,其中键列存储用于复制的键值。 在一个实施例中,接收到将请求添加到复制域的请求,使得表从第一数据库服务器复制到至少第二数据库服务器。 为现有记录和随后请求插入表中的新记录分别生成键值。 每个生成的密钥值在复制域中是唯一的。 此外,密钥列可以被添加到表中,而不需要对表的独占访问。
-
公开(公告)号:US08862544B2
公开(公告)日:2014-10-14
申请号:US13615156
申请日:2012-09-13
IPC分类号: G06F17/30
CPC分类号: G06F17/30212
摘要: Provided are techniques for replication in a grid based environment. Grid control structures, including a grid command structure, are created. At an authorized node in a grid of nodes, a Data Definition Language (DDL) operation is received, the DDL operation is inserted into the grid command structure, and the DDL operation is propagated from the authorized node to one or more other nodes in the grid of nodes at the end of a transaction that inserted the DDL operation into the grid command structure.
摘要翻译: 提供了在基于网格的环境中进行复制的技术。 创建网格控制结构,包括网格命令结构。 在节点网格中的授权节点处,接收到数据定义语言(DDL)操作,DDL操作被插入到网格命令结构中,DDL操作从授权节点传播到一个或多个其他节点 在将DDL操作插入到网格命令结构中的事务结束处的节点网格。
-
公开(公告)号:US08688634B2
公开(公告)日:2014-04-01
申请号:US10788556
申请日:2004-02-27
CPC分类号: G06F17/30566 , G06F17/30286 , G06F17/30578
摘要: A method and system for providing convergence of data copies in asynchronous data replication in a database system, includes: labeling rows, a copy of identification and propagation controls. In applying communicated changes, conflicting changes are identified and resolved. In this manner, convergence of data copies in asynchronous data replication is provided, and processing and storage costs are significantly reduced.
摘要翻译: 一种用于在数据库系统中异步数据复制中提供数据副本收敛的方法和系统,包括:标记行,标识和传播控制的副本。 在应用传达的变更中,确定并解决冲突的变化。 以这种方式,提供异步数据复制中的数据副本的收敛,并且显着地减少处理和存储成本。
-
公开(公告)号:US08566280B2
公开(公告)日:2013-10-22
申请号:US13149374
申请日:2011-05-31
IPC分类号: G06F17/00
CPC分类号: G06F17/30212
摘要: Provided are techniques for replication in a grid based environment. Grid control structures, including a grid command structure, are created. At an authorized node in a grid of nodes, a Data Definition Language (DDL) operation is received, the DDL operation is inserted into the grid command structure, and the DDL operation is propagated from the authorized node to one or more other nodes in the grid of nodes at the end of a transaction that inserted the DDL operation into the grid command structure.
摘要翻译: 提供了在基于网格的环境中进行复制的技术。 创建网格控制结构,包括网格命令结构。 在节点网格中的授权节点处,接收到数据定义语言(DDL)操作,DDL操作被插入到网格命令结构中,DDL操作从授权节点传播到一个或多个其他节点 在将DDL操作插入到网格命令结构中的事务结束处的节点网格。
-
公开(公告)号:US20130006934A1
公开(公告)日:2013-01-03
申请号:US13615156
申请日:2012-09-13
IPC分类号: G06F17/30
CPC分类号: G06F17/30212
摘要: Provided are techniques for replication in a grid based environment. Grid control structures, including a grid command structure, are created. At an authorized node in a grid of nodes, a Data Definition Language (DDL) operation is received, the DDL operation is inserted into the grid command structure, and the DDL operation is propagated from the authorized node to one or more other nodes in the grid of nodes at the end of a transaction that inserted the DDL operation into the grid command structure.
摘要翻译: 提供了在基于网格的环境中进行复制的技术。 创建网格控制结构,包括网格命令结构。 在节点网格中的授权节点处,接收到数据定义语言(DDL)操作,DDL操作被插入到网格命令结构中,DDL操作从授权节点传播到一个或多个其他节点 在将DDL操作插入到网格命令结构中的事务结束处的节点网格。
-
公开(公告)号:US20120310886A1
公开(公告)日:2012-12-06
申请号:US13149374
申请日:2011-05-31
IPC分类号: G06F17/30
CPC分类号: G06F17/30212
摘要: Provided are techniques for replication in a grid based environment. Grid control structures, including a grid command structure, are created. At an authorized node in a grid of nodes, a Data Definition Language (DDL) operation is received, the DDL operation is inserted into the grid command structure, and the DDL operation is propagated from the authorized node to one or more other nodes in the grid of nodes at the end of a transaction that inserted the DDL operation into the grid command structure.
摘要翻译: 提供了在基于网格的环境中进行复制的技术。 创建网格控制结构,包括网格命令结构。 在节点网格中的授权节点处,接收到数据定义语言(DDL)操作,DDL操作被插入到网格命令结构中,DDL操作从授权节点传播到一个或多个其他节点 在将DDL操作插入到网格命令结构中的事务结束处的节点网格。
-
-
-
-
-
-
-