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
Transactions and beyond it..
相關文章
- SESSIONS, PROCESSES, TRANSACTIONSSession
- Commit Transactions (143)MIT
- Overview of Autonomous Transactions (150)View
- Shipping Transactions Date 相關
- 中文Beyond Compare 4啟用安裝包+Beyond Compare 4金鑰
- Fragment Transactions和Activity狀態丟失Fragment
- MySQL 5.5 -- Metadata Locking Within TransactionsMySql
- ubuntu 命令安裝 beyond compareUbuntu
- 中文Beyond Compare 4安裝包+Beyond Compare 4序號產生器金鑰
- Beyond Compare 4過期怎麼辦?Beyond Compare 4 Mac永 久金鑰分享Mac
- Oracle 19c Concepts(10):TransactionsOracle
- Laravel 之巢狀事務 transactions 實現Laravel巢狀
- centos 使用 beyond compare 對比工具CentOS
- 認識 MongoDB 4.0 的新特性——事務(Transactions)MongoDB
- db2批次處理doubt transactionsDB2
- Destiny 2: Beyond Light Unveils New Stasis Subclasses
- LFS 8.0 和 Beyond LFS 8.0 正式釋出
- Script: To Display Active Transactions in Rollback Segments_1019467.6
- Oracle sessions,processes 和 transactions 引數 關係 說明OracleSession
- centos下如何使用 beyond compare 對比工具CentOS
- Beyond Compare 4 for Mac中文版下載Mac
- git中配置Beyond Compare作為mergetoolGit
- 使用Spring實現反應式事務(Reactive Transactions)SpringReact
- db2 如何模擬indobt transactions 用到的指令碼DB2指令碼
- The partner transaction manager has disabled its support for remote/network transactions.REM
- Beyond Compare 4 for Mac,檔案對比同步工具Mac
- Beyond Compare for Mac(檔案比較對比工具)Mac
- GO語言實現區塊鏈Part6 Transactions 2Go區塊鏈
- GO語言實現區塊鏈Part4 Transactions 1Go區塊鏈
- Oracle OCP 1Z0 053 Q130(flashback transactions)Oracle
- Beyond the C++ Standard Library電子書pdf下載C++
- 檔案同步對比軟體:Beyond Compare 4 for MacMac
- Beyond Compare 4 for Mac:你的檔案比較神器Mac
- Oracle Critical Patch Update - January 2008 and Beyond [ID 467881.1]Oracle
- OGG-01028 Record position is beyond end of recovery
- 強大的檔案對比工具Beyond Compare 4 for MacMac
- beyond Compare4不需要補丁的破解方法
- goldengate extract abended unable to queue I/O, I/O beyond file sizeGo