发明授权
- 专利标题： Techniques to preserve data constraints and referential integrity in asynchronous transactional replication of relational tables
- 专利标题（中）： 在关系表的异步事务复制中保留数据约束和引用完整性的技术
-
申请号： US10788651申请日： 2004-02-27
-
公开(公告)号： US07240054B2公开(公告)日： 2007-07-03
- 发明人: 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
- 申请人地址： US NY Armonk
- 专利权人： International Business Machines Corporation
- 当前专利权人： International Business Machines Corporation
- 当前专利权人地址： US NY Armonk
- 代理机构： Sawyer Law Group LLP
- 主分类号： G06F17/30
- IPC分类号： G06F17/30
摘要：
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.
公开/授权文献
信息查询
