专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

US09244996B2 Replicating data across multiple copies of a table in a database system 有权
标题翻译：在数据库系统中的表的多个副本上复制数据
公开(公告)号：US09244996B2
公开(公告)日：2016-01-26
申请号：US11771801
申请日：2007-06-29
申请人： Serge Bourbonnais , Elizabeth B. Hamel , Bruce G. Lindsay , Stephen J. Todd
发明人： Serge Bourbonnais , Elizabeth B. Hamel , Bruce G. Lindsay , Stephen J. Todd
IPC分类号： G06F17/30
CPC分类号： G06F17/30578 , G06F17/30345 , Y10S707/99938
摘要： A mechanism for handling transaction messages in asynchronous data replication in a database system, in which the database system includes a source node and a target node, and each transaction message has information concerning a row change to a table copy at the source node. The mechanism determines whether a first transaction message has a dependency on a preceding non-completed transaction message. Responsive to the first transaction message having a dependency on the preceding non-completed transaction, the mechanism holds the first transaction message, completes the preceding non-completed transaction message including applying the row change associated with the preceding non-completed transaction message to the table copy at the target node, and responsive to completing the preceding non-completed transaction message, releases the first transaction message and applying the row change associated with the first transaction message to the table copy at the target node.
摘要翻译：用于在数据库系统中处理异步数据复制中的事务消息的机制，其中数据库系统包括源节点和目标节点，并且每个事务消息具有关于在源节点处的表副本的行更改的信息。该机制确定第一事务消息是否具有对先前未完成的事务消息的依赖性。响应于对先前未完成的事务具有依赖性的第一交易消息，该机制保持第一交易消息，完成前述未完成的交易消息，包括将与先前未完成的交易消息相关联的行变更应用于表在目标节点处的副本，并且响应于完成上述未完成的交易消息，释放第一交易消息并将与第一交易消息相关联的行变更应用于目标节点处的表副本。

2. 发明授权

US08352425B2 Parallel apply processing in data replication with preservation of transaction integrity and source ordering of dependent updates 失效
标题翻译：在数据复制中并行应用处理，保留事务完整性和依赖更新的源排序
公开(公告)号：US08352425B2
公开(公告)日：2013-01-08
申请号：US12049196
申请日：2008-03-14
申请人： Serge Bourbonnais , Elizabeth B. Hamel , Bruce G. Lindsay , Stephen J. Todd
发明人： Serge Bourbonnais , Elizabeth B. Hamel , Bruce G. Lindsay , Stephen J. Todd
IPC分类号： G06F17/00
CPC分类号： G06F17/30578 , G06F17/30345 , Y10S707/99938
摘要： A computer readable medium encoded with a computer program for handling transaction messages in asynchronous data replication in a database system is disclosed. The computer program provides a high speed parallel apply of transactional changes to a target node such that the parallel nature of the application of changes does not compromise the integrity of the data. The computer program detects, tracks, and handles dependencies between transaction messages to be applied to the target node. If a transaction message has a dependency on one or more preceding transaction messages whose applications have not yet completed, that transaction message is held until the application completes. In addition, the computer program requires significantly less overhead than conventional approaches.
摘要翻译：公开了一种用于在数据库系统中异步数据复制中处理事务消息的计算机程序编码的计算机可读介质。计算机程序提供对目标节点的事务更改的高速并行应用，使得应用改变的并行性质不会危及数据的完整性。计算机程序检测，跟踪和处理要应用于目标节点的事务消息之间的依赖关系。如果事务消息对应用程序尚未完成的一个或多个先前的事务消息具有依赖性，那么该事务消息将保持到应用程序完成为止。此外，计算机程序需要比常规方法显着更少的开销。

3. 发明授权

US07426559B2 Method for sequential coordination of external database application events with asynchronous internal database events 有权
标题翻译：使用异步内部数据库事件顺序协调外部数据库应用程序事件的方法
公开(公告)号：US07426559B2
公开(公告)日：2008-09-16
申请号：US10143317
申请日：2002-05-09
申请人： Elizabeth B. Hamel , Bruce G. Lindsay
发明人： Elizabeth B. Hamel , Bruce G. Lindsay
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30578
摘要： Database management methods that exploit time dependent sequential database management system processes to ensure presentation of the same data or view to one or a plurality of users through sequencing asynchronous database management operations such as recovery and replication. Sequencing is accomplished through the use of entries in sequential logs, including transaction logs, recovery logs, and other data recovery tools and applications. Uses include managing data migration and data replication.
摘要翻译：数据库管理方法利用时间依赖的顺序数据库管理系统进程，以通过排序异步数据库管理操作（如恢复和复制）来确保向一个或多个用户呈现相同的数据或视图。顺序通过使用顺序日志中的条目来实现，包括事务日志，恢复日志和其他数据恢复工具和应用程序。用途包括管理数据迁移和数据复制。

4. 发明申请

US20080195673A1 METHOD, SYSTEM, AND PROGRAM PRODUCT FOR SEQUENTIAL COORDINATION OF EXTERNAL DATABASE APPLICATION EVENTS WITH ASYNCHRONOUS INTERNAL DATABASE EVENTS 有权
标题翻译：使用异步内部数据库事件进行外部数据库应用程序的顺序协调的方法，系统和程序产品
公开(公告)号：US20080195673A1
公开(公告)日：2008-08-14
申请号：US12103548
申请日：2008-04-15
申请人： Elizabeth B. Hamel , Bruce G. Lindsay
发明人： Elizabeth B. Hamel , Bruce G. Lindsay
IPC分类号： G06F12/00
CPC分类号： G06F17/30578
摘要： Database management systems, methods, and program products that exploit time dependent sequential database management system processes to ensure presentation of the same data or view to one or a plurality of users through sequencing asynchronous database management operations such as recovery and replication. Sequencing is accomplished through the use of entries in sequential logs, including transaction logs, recovery logs, and other data recovery tools and applications. Uses include managing data migration and data replication.
摘要翻译：数据库管理系统，方法和程序产品利用时间依赖的顺序数据库管理系统流程，通过排序异步数据库管理操作（如恢复和复制）来确保向一个或多个用户呈现相同的数据或视图。顺序通过使用顺序日志中的条目来实现，包括事务日志，恢复日志和其他数据恢复工具和应用程序。用途包括管理数据迁移和数据复制。

5. 发明授权

US07240054B2 Techniques to preserve data constraints and referential integrity in asynchronous transactional replication of relational tables 失效
标题翻译：在关系表的异步事务复制中保留数据约束和引用完整性的技术
公开(公告)号：US07240054B2
公开(公告)日：2007-07-03
申请号：US10788651
申请日：2004-02-27
申请人： Nicolas G. Adiba , Roberta J. Cochrane , Elizabeth B. Hamel , Somil D. Kulkarni , Bruce G. Lindsay
发明人： Nicolas G. Adiba , Roberta J. Cochrane , Elizabeth B. Hamel , Somil D. Kulkarni , Bruce G. Lindsay
IPC分类号： G06F17/30
CPC分类号： G06F17/30371 , G06F17/30578 , Y10S707/99934
摘要： An improved method and system for preserving data constraints during parallel apply in asynchronous transaction replication in a database system have been disclosed. The method and system preserves secondary unique constraints and referential integrity constraints, while also allowing a high degree of parallelism in the application of asynchronous replication transactions. The method and system also detects and resolves ordering problems introduced by referential integrity cascade deletes, and allows the parallel initial loading of parent and child tables of a referential integrity constraint.
摘要翻译：已经公开了一种用于在数据库系统中的异步事务复制中并行地保留数据约束的改进的方法和系统。该方法和系统保留次要唯一约束和引用完整性约束，同时还允许应用异步复制事务的高度并行性。该方法和系统还检测和解决引用完整性级联删除引入的排序问题，并允许并行初始加载父表和子表的引用完整性约束。

6. 发明申请

US20080195672A1 SYSTEM AND PROGRAM PRODUCT FOR SEQUENTIAL COORDINATION OF EXTERNAL DATABASE APPLICATION EVENTS WITH ASYNCHRONOUS INTERNAL DATABASE EVENTS 有权
标题翻译：使用异步内部数据库事件对外部数据库应用程序进行顺序协调的系统和程序产品
公开(公告)号：US20080195672A1
公开(公告)日：2008-08-14
申请号：US12103538
申请日：2008-04-15
申请人： Elizabeth B. Hamel , Bruce G. Lindsay
发明人： Elizabeth B. Hamel , Bruce G. Lindsay
IPC分类号： G06F17/00
CPC分类号： G06F17/30578
摘要： Database management systems and program products that exploit time dependent sequential database management system processes to ensure presentation of the same data or view to one or a plurality of users through sequencing asynchronous database management operations such as recovery and replication. Sequencing is accomplished through the use of entries in sequential logs, including transaction logs, recovery logs, and other data recovery tools and applications. Uses include managing data migration and data replication.
摘要翻译：数据库管理系统和程序产品利用时间依赖的顺序数据库管理系统进程，以通过排序异步数据库管理操作（如恢复和复制）来确保向一个或多个用户呈现相同的数据或视图。顺序通过使用顺序日志中的条目来完成，包括事务日志，恢复日志和其他数据恢复工具和应用程序。用途包括管理数据迁移和数据复制。

7. 发明授权

US07330860B2 Fault tolerant mechanism to handle initial load of replicated object in live system 有权
标题翻译：在系统中处理复制对象的初始负载的容错机制
公开(公告)号：US07330860B2
公开(公告)日：2008-02-12
申请号：US10789326
申请日：2004-02-26
申请人： Nicolas G. Adiba , Serge Bourbonnais , Elizabeth B. Hamel , Somil Kulkarni , Bruce G. Lindsay
发明人： Nicolas G. Adiba , Serge Bourbonnais , Elizabeth B. Hamel , Somil Kulkarni , Bruce G. Lindsay
IPC分类号： G06F12/00 , G06F17/30
CPC分类号： G06F17/30578 , G06F17/30312 , Y10S707/99953 , Y10S707/99955
摘要： An automatic initial data load to a new table copy concurrently with active replication to existing table copies in an asynchronous replication group includes: initiating a data load of the new table copy; creating spill queue(s) at the new table copy; loading the data from a source table copy to the new table copy, where changes for the active table copies are applied during the loading, but changes to the new table copy are stored in a spill storage area; applying the changes in the spill storage area to the new table copy after the loading of the data is done; and removing the spill storage area after the changes have been applied to the new table copy. Thus, a new table copy is initialized into the replication group without requiring that replication be suspended at the source or any of the existing table copies during the initializing process.
摘要翻译：在异步复制组中，将活动复制与现有表副本并发的新表复制的自动初始数据加载包括：启动新表副本的数据加载; 在新表副本上创建溢出队列; 将数据从源表副本加载到新的表副本，其中在加载期间应用活动表副本的更改，但对新表副本的更改将存储在溢出存储区中; 在完成数据的加载之后，将溢出存储区域中的更改应用于新的表格副本; 并且在将更改应用于新的表格副本之后移除溢出存储区域。因此，将新的表副本初始化为复制组，而不需要在初始化过程中将源复制或任何现有表复制暂停。

8. 发明授权

US07203687B2 Peer-to-peer replication member initialization and deactivation 失效
标题翻译：对等复制成员初始化和停用
公开(公告)号：US07203687B2
公开(公告)日：2007-04-10
申请号：US10789656
申请日：2004-02-26
申请人： Nicolas G. Adiba , Jaime F. Anaya , Elizabeth B. Hamel , Yat On Lau , Siqun Li , Bruce G. Lindsay
发明人： Nicolas G. Adiba , Jaime F. Anaya , Elizabeth B. Hamel , Yat On Lau , Siqun Li , Bruce G. Lindsay
IPC分类号： G06F17/00 , G06F7/00
CPC分类号： G06F17/30578 , G06F11/1425 , G06F11/1479 , Y10S707/99953
摘要： A method and system for member initialization to and deactivation from an asynchronous data replication group in a database system is disclosed. The method and system allows new members to be added to the replication group or existing members to be removed from the replication group, without requiring the halting of the asynchronous replication of data. The performance advantages of asynchronous replication are still realized during member initialization or deactivation.
摘要翻译：公开了一种用于在数据库系统中从异步数据复制组成员初始化和停用成员的方法和系统。该方法和系统允许将新成员添加到要从复制组中删除的复制组或现有成员，而不需要暂停数据的异步复制。在成员初始化或停用期间，异步复制的性能优势仍然可以实现。

9. 发明授权

US08688634B2 Asynchronous peer-to-peer data replication 失效
标题翻译：异步对等数据复制
公开(公告)号：US08688634B2
公开(公告)日：2014-04-01
申请号：US10788556
申请日：2004-02-27
申请人： Kevin S. Beyer , Elizabeth B. Hamel , Bruce G. Lindsay , Clarence M. Pruet, III
发明人： Kevin S. Beyer , Elizabeth B. Hamel , Bruce G. Lindsay , Clarence M. Pruet, III
IPC分类号： G06F17/00 , G06F17/30
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.
摘要翻译：一种用于在数据库系统中异步数据复制中提供数据副本收敛的方法和系统，包括：标记行，标识和传播控制的副本。在应用传达的变更中，确定并解决冲突的变化。以这种方式，提供异步数据复制中的数据副本的收敛，并且显着地减少处理和存储成本。

10. 发明授权

US07979546B2 Method, system, and program product for sequential coordination of external database application events with asynchronous internal database events 有权
标题翻译：用于使用异步内部数据库事件顺序协调外部数据库应用程序事件的方法，系统和程序产品
公开(公告)号：US07979546B2
公开(公告)日：2011-07-12
申请号：US12103548
申请日：2008-04-15
申请人： Elizabeth B. Hamel , Bruce G. Lindsay
发明人： Elizabeth B. Hamel , Bruce G. Lindsay
IPC分类号： G06F17/30
CPC分类号： G06F17/30578
摘要： Database management systems, methods, and program products that exploit time dependent sequential database management system processes to ensure presentation of the same data or view to one or a plurality of users through sequencing asynchronous database management operations such as recovery and replication. Sequencing is accomplished through the use of entries in sequential logs, including transaction logs, recovery logs, and other data recovery tools and applications. Uses include managing data migration and data replication.
摘要翻译：数据库管理系统，方法和程序产品利用时间依赖的顺序数据库管理系统流程，通过排序异步数据库管理操作（如恢复和复制）来确保向一个或多个用户呈现相同的数据或视图。顺序通过使用顺序日志中的条目来实现，包括事务日志，恢复日志和其他数据恢复工具和应用程序。用途包括管理数据迁移和数据复制。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式