While data integrity is managed very effectively within a single database with row locking, deadlock detection, and roll-back features, distributed data integrity is far more complex. Recovery in a distributed database environment involves ensuring that the entire transaction has completed successfully before issuing a COMMIT to each of the subcomponents in the overall transaction. This can often be a cumbersome chore, and it is the idea behind the the two-phase commit.

One popular alternative to the two-phase commit is replicating information and relying on asynchronous replication techniques to enforce the data integrity. e.g. MS's implementation- https://technet.microsoft.com/en-us/library/ms152501(v=sql.105).aspx

最新文章

  1. 关于学习angularJS 的 心里路程(二)
  2. Python爬虫Scrapy框架入门（0）
  3. VisualSVN Server添加svn项目
  4. MVC小系列（八）【改变Areas的FindView顺序】
  5. unix 环境高级编程-读书笔记与习题解答-第二篇
  6. Java的内存机制详解
  7. 老男孩Python全栈开发（92天全）视频教程 自学笔记09
  8. CentOS 7 单用户模式+救援模式
  9. HDU 3974 Assign the task（dfs时间戳+线段树成段更新）
  10. +QFTPOPEN: 603,0 怎么把这样一个字符串中的 603 提取出来给一个 uint32_t 的变量那
  11. 基于 Axis2的webService接口的基本开发步骤
  12. 开启andriod手机的adbd，进行无线adb调试
  13. SignalR集成Autofac
  14. lintcode - 被围绕的区域
  15. TCP/IP四层体系结构
  16. python 集合互相转换
  17. 【SPOJ】Substrings
  18. P5135 painting（组合数）
  19. bzoj4149: [AMPPZ2014]Global Warming
  20. ajax——dom基础

热门文章

  1. Serlvet学习笔记之二—不同页面共享数据
  2. ios错误大全
  3. 开源的PaaS方案：在OpenStack上部署CloudFoundry （四）使用Micro Bosh部署CloudFoundry
  4. LeetCode——Min Stack
  5. LINUX IPTABLES 防火墙配置
  6. Gallery 里面怎么设置ImageView的OnClick事件
  7. tpcc-mysql安装、使用、结果解读
  8. jquery收集表单数组及去掉字符串最后的逗号！
  9. vue监听滚动事件
  10. sublime3095-注册码下载安装