- 1、本文档共62页,可阅读全部内容。
- 2、原创力文档(book118)网站文档一经付费(服务费),不意味着购买了该文档的版权,仅供个人/单位学习、研究之用,不得用于商业用途,未经授权,严禁复制、发行、汇编、翻译或者网络传播等,侵权必究。
- 3、本站所有内容均由合作方或网友上传,本站不对文档的完整性、权威性及其观点立场正确性做任何保证或承诺!文档内容仅供研究参考,付费前请自行鉴别。如您付费,意味着您自己接受本站规则且自行承担风险,本站不退款、不进行额外附加服务;查看《如何避免下载的几个坑》。如果您已付费下载过本站文档,您可以点击 这里二次下载。
- 4、如文档侵犯商业秘密、侵犯著作权、侵犯人身权等,请点击“版权申诉”(推荐),也可以打举报电话:400-050-0827(电话支持时间:9:00-18:30)。
查看更多
ch9. transaction
Ch9 Transaction Transaction Concept A transaction is a unit of program execution that accesses and possibly updates various data items. (访问并可能更新各种数据项的一个程序执行单元) Transaction Concept A transaction must see a consistent database. During transaction execution the database may be inconsistent. When the transaction is committed, the database must be consistent. Two main issues to deal with: Failures of various kinds, such as hardware failures and system crashes Concurrent execution of multiple transactions ACID Properties To preserve integrity of data, the database system must ensure: Atomicity. Either all operations of the transaction are properly reflected in the database or none are. Consistency. Execution of a transaction in isolation preserves the consistency of the database. Isolation. Although multiple transactions may execute concurrently, each transaction must be unaware of other concurrently executing transactions. Intermediate transaction results must be hidden from other concurrently executed transactions. That is, for every pair of transactions Ti and Tj, it appears to Ti that either Tj, finished execution before Ti started, or Tj started execution after Ti finished. Durability. After a transaction completes successfully, the changes it has made to the database persist, even if there are system failures. Example of Fund Transfer Transaction to transfer $50 from account A to account B: 1. read(A) 2. A := A – 50 3. write(A) 4. read(B) 5. B := B + 50 6. write(B) Atomicity requirement — if the transaction fails after step 3 and before step 6, the system should ensure that its updates are not reflected in the database, else an inconsistency will result. Consistency requirement – the sum of A and B is unchanged by the execution of the transaction. Example of Fund Transfer (Cont.) Isolation requirement — if between steps 3 and 6, another transaction is allowed to access the partially updated database, it will see an inconsistent database (the sum A + B wi
您可能关注的文档
- 2016春夏interTEXTILE上海国际面料博览会趋势分析.docx
- 22-10-0054-01-0000-ofdma-based-terrestrial-geolocation.ppt
- 22-11-0022-00-0000-best-static-tone-locations.ppt
- 2A公开课Sunshine English2A.ppt
- 24小时血压监测,平稳降压.ppt
- 2对话框驱动及应用实例.ppt
- 22-10-0171-01-0000-802-22-motions-nov-ec-meeting.ppt
- 3-管理Magento主题.doc
- 3D analysis.ppt
- 3D_Game_Programming0919.ppt
- 建筑工程图集 16CJ73-1:铝木复合节能门窗--瑞明铝木复合门窗系统.pdf
- 建筑工程图集 04SG307:现浇钢筋混凝土板式楼梯.pdf
- 建筑工程图集 08J927-2:机械式汽车库建筑构造.pdf
- 建筑工程图集 05S506-1:自承式平直形架空钢管.pdf
- 建筑工程图集 19G905-3:房屋建筑工程施工工艺图解一一组拼式铝合金模板系列施工工艺图解.pdf
- 建筑工程图集 05X101-2:地下通信线缆敷设.pdf
- 建筑工程图集 04J601-1:木门窗.pdf
- 建筑工程图集 06G901-1:混凝土结构施工钢筋排布规则与构造详图(现浇混凝土框架、剪力墙、框架-剪力墙).pdf
- 黑龙江省哈尔滨市第九中学校2024-2025学年高二上学期10月考试历史学科试卷(无答案).pdf
- 广西壮族自治区北海市2025届高三一模考试语文试题(无答案).pdf
文档评论(0)