-
公开(公告)号：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.
摘要翻译： 公开了将关键列添加到要复制的表的技术，其中键列存储用于复制的键值。 在一个实施例中，接收到将请求添加到复制域的请求，使得表从第一数据库服务器复制到至少第二数据库服务器。 为现有记录和随后请求插入表中的新记录分别生成键值。 每个生成的密钥值在复制域中是唯一的。 此外，密钥列可以被添加到表中，而不需要对表的独占访问。
-
公开(公告)号：US20110320416A1
公开(公告)日：2011-12-29
申请号：US12822436
申请日：2010-06-24
IPC分类号： G06F17/30
CPC分类号： G06F16/273
摘要： According to a present invention embodiment, a system avoids duplicate processing of database objects to ensure operation integrity in a database system including a plurality of nodes. The system comprises a computer system including at least one processor. The computer system receives a data operation from a secondary node, executes the received data operation, and identifies each database object that is relocated based on the executed data operation. The computer system communicates to the secondary node operations performed by the computer system for execution of the data operation and an indication of each relocated database object. The secondary node stores an identifier reflecting the relocation for each relocated database object to prevent re-processing of the relocated database objects for the data operation. Embodiments of the present invention further include a method and computer program product for avoiding duplicate processing of database objects in substantially the same manner described above.
摘要翻译： 根据本发明的实施例，系统避免数据库对象的重复处理，以确保包括多个节点的数据库系统中的操作完整性。 该系统包括包括至少一个处理器的计算机系统。 计算机系统从辅助节点接收数据操作，执行接收的数据操作，并根据执行的数据操作识别重定位的每个数据库对象。 计算机系统与由计算机系统执行的辅助节点操作进行通信，以执行数据操作和每个重新定位的数据库对象的指示。 辅助节点存储反映每个重新定位的数据库对象的重新定位的标识符，以防止用于数据操作的重新定位的数据库对象的重新处理。 本发明的实施例还包括一种方法和计算机程序产品，用于以基本相同的方式避免数据库对象的重复处理。
-
-
搜索结果
3 条记录 (耗时 0.018 秒)
