concurrent database transaction 中文意思是什麼
concurrent database transaction
解釋
并行數據庫事務處理- concurrent : adj 1 同時發生的，並發的，並存的，共存的；合作的。2 （意見）一致的。3 【動物；動物學】趨合的；【...
- transaction : n 1 辦理，處理；交易；業務，事務。2 【法律】和解。3 〈pl 〉（學會等的）會議記錄；學報。4 【心理學...
-
If a lock escalation attempt fails because of conflicting locks held by concurrent transactions, the database engine will retry the lock escalation for each additional 1, 250 locks acquired by the transaction
如果由於並發事務所持有的鎖沖突而導致鎖升級嘗試失敗，則數據庫引擎將對事務獲取的其他1 ， 250個鎖重試鎖升級。 -
This isolation level eliminates the possibility that one transaction could overwrite changes made by another concurrent transaction ( the second lost updates problem ) if all data access is performed in a single atomic database transaction
如果所有的數據訪問都是在統一的原子數據庫事務中，此隔離級別將消除一個事務在另外一個並發事務過程中覆蓋數據的可能性（第二個事務更新丟失問題） 。 -
As the application of distributed computing is used much more widely ， distributed database becomes a significant part of information management it avoids a lot of disadvantages of conventional centralized database ， and is applicable to many situations distributed database is a set of data which is the unity logic ， but in fact these data is located on different sites it is of high availability ， easy expansibility ， high concurrency ， high efficiency and etc in distributed system ， data redundancy is a method to improve the speed of query and the availability of system distributed query should shield the lower level details of data redundancy from end users ， distributed transaction should ensure data from disaccord this paper introduces basic conceptions of distributed database firstly ， discusses distributed transaction and concurrent control ， describes the development prototype mysql ’ s characters ， architecture and executive mechanism ， then shows the skeleton model of dpsql and exposes the strategy and algorithm of distributed query and distributed transaction ， at last analyzes the extra expenses and response delay of distributed processes this paper exposes the implementation mechanism of distributed query and distributed transaction emphatically distributed query uses the strategy of “ read one ， write a11 ” s0 in such a system if user ’ s requests are read - - only for the most part and the distribution of data redundancy is plausible ， efficiency is very high distributed transaction uses two - 。 phase commit protocol to ensure the consistency of global data ， which has less communication overhead
分散式查詢需要向用戶屏蔽數據冗餘分散的底層細節，分散式事務處理要保證全局數據完整，這都是傳統集中式數據庫不曾面臨的問題。本文首先介紹了分散式數據庫的概念性問題；接著討論了分散式事務涉及的定義及演算法；然後描述了dpsql的原型mysql的特性、結構和執行機制；繼而給出了dpsql的梗概模型，闡述了實現分散式查詢和分散式事務處理的策略及演算法；最後分析了進行分散式處理給系統增加的額外開銷和客戶端的額外響應延遲。本文重點描述了分散式查詢和分散式事務處理的實現機制，分散式查詢採用」讀一個寫全部」的本地優先策略，在讀操作頻繁的系統中，只要庫的分佈合理，單機效率極高，幾乎無任何附加開銷和延遲，而以整個系統的角度看來，吞吐量就更是優于單機系統；分散式事務處理採用兩階段提交協議，通信次數較少並能確實保證副本一致。
分享友人