testyahoo

yahoo 相册  时间:2021-02-22  阅读:()
AlternativeConcurrencyControlMethodsR&G-Chapter17RoadmapSofar:Correctnesscriterion:serializabilityLock-basedCCtoenforceserializabilityStrict2PLDeadlocksLockinggranularitiesTreelockingprotocolsPhantomsToday:AlternativeCCmechanismsOptimisticCC(Kung-Robinson)Lockingisaconservativeapproachinwhichconflictsareprevented.
Disadvantages:Lockmanagementoverhead.
Deadlockdetection/resolution.
Lockcontentionforheavilyusedobjects.
Lockingis"pessimistic"becauseitassumesthatconflictswillhappen.
WhatifconflictsarerareWemightgetbetterperformancebynotlocking,andinsteadcheckingforconflictsatcommittime.
Kung-RobinsonModelXactshavethreephases:READ:Xactsreadfromthedatabase,butmakechangestoprivatecopiesofobjects.
VALIDATE:Checkforconflicts.
WRITE:Makelocalcopiesofchangespublic.
RVWValidationIdea:testconditionsthataresufficienttoensurethatnoconflictoccurred.
EachXactassignedanumericid.
Justuseatimestamp.
AssignedatendofREADphase.
ReadSet(Ti):SetofobjectsreadbyXactTi.
WriteSet(Ti):SetofobjectsmodifiedbyTi.
Test1ForalliandjsuchthatTiWTS(O):AllowTtoreadO.
ResetRTS(O)tomax(RTS(O),TS(T))ChangetoRTS(O)onreadsmustbewrittentodisk!
Thisandrestartsrepresentoverheads.
TimestampCC:WhenXactTwantstoWriteObjectOIfTS(T)WTS(O))untilwriterofOcommits.
SimilartowritersholdingXlocksuntilcommit,butstillnotquite2PL.
T1T2W(A)R(A)W(B)CommitUnrecoverableschedulesareallowedbyTimestampCC!
Recoverableschedule:xactscommitonlyafter(andif)allxactswhosechangestheyreadcommitAweakerconditionthanAvoidCascadingRollbackMultiversionTimestampCCIdea:Letwritersmakea"new"copywhilereadersuseanappropriate"old"copy:OO'O''MAINSEGMENT(CurrentversionsofDBobjects)VERSIONPOOL(Olderversionsthatmaybeusefulforsomeactivereaders.
)Readersarealwaysallowedtoproceed.
Butmaybeblockeduntilwritercommits.
MultiversionCC(Contd.
)Eachversionofanobjecthasitswriter'sTSasitsWTS,andtheTSoftheXactthatmostrecentlyreadthisversionasitsRTS.
Versionsarechainedbackward;wecandiscardversionsthatare"toooldtobeofinterest".
EachXactisclassifiedasReaderorWriter.
Writermaywritesomeobject;Readerneverwill.
XactdeclareswhetheritisaReaderwhenitbegins.
ReaderXactForeachobjecttoberead:FindsnewestversionwithWTSReaderXactsareneverrestarted.
However,mightblockuntilwriteroftheappropriateversioncommits.
ToldnewWTStimelineWriterXactToreadanobject,followsreaderprotocol.
Towriteanobject:FindsnewestversionVs.
t.
WTSIfRTS(V))Else,rejectwrite.
ToldnewWTSCVVRTS(V)SummaryOptimisticCCusingend-of-xact"validation"Goodif:Read-dominatedworkloadSystemhaslotsofextraresourcesMostrealsystemsuselockingSummary(Contd.
)Anotheralternative:TimestampCCDecidelogicalxactexecutionorderwhenxactsentersystemEnforcebycomparingxacttimestampswithobjecttimestampsVariant:MultiversionCCKeepout-of-dateversionsofobjects,so"old"readersdon'thavetorestart(theycanrun"inthepast")OracleusesaflavorofmultiversionCC

ReliableSite怎么样,月付$95美国洛杉矶独立服务器

ReliableSite怎么样?ReliableSite好不好。ReliableSite是一家成立于2006年的老牌美国商家,主要经营美国独立服务器租赁,数据中心位于:洛杉矶、迈阿密、纽约,带宽1Gbps起步,花19美元/月即可升级到10Gbps带宽,月流量150T足够各种业务场景使用,且免费提供20Gbps DDoS防护。当前商家有几款大硬盘美国独服,地点位于美国洛杉矶或纽约机房,机器配置很具有...

UCloud云服务器低至年59元

最近我们是不是在讨论较多的是关于K12教育的问题,培训机构由于资本的介入确实让家长更为焦虑,对于这样的整改我们还是很支持的。实际上,在云服务器市场中,我们也看到内卷和资本的力量,各大云服务商竞争也是相当激烈,更不用说个人和小公司服务商日子确实不好过。今天有看到UCloud发布的夏季促销活动,直接提前和双十一保价挂钩。这就是说,人家直接在暑假的时候就上线双十一的活动。早年的双十一活动会提前一周到十天...

LOCVPS新上日本软银线路VPS,原生IP,8折优惠促销

LOCVPS在农历新年之后新上架了日本大阪机房软银线路VPS主机,基于KVM架构,配备原生IP,适用全场8折优惠码,最低2GB内存套餐优惠后每月仅76元起。LOCVPS是一家成立于2012年的国人VPS服务商,提供中国香港、韩国、美国、日本、新加坡、德国、荷兰、俄罗斯等地区VPS服务器,基于KVM或XEN架构(推荐选择KVM),线路方面均选择国内直连或优化方案,访问延迟低,适合建站或远程办公使用。...

yahoo 相册为你推荐
主页改不了浏览器主页改不了 怎么办啊arm开发板想购买一个ARM开发板,选什么类型的好今日热点怎么删除今日热点怎么卸载删除 今日热点新闻彻底卸载删迅雷云点播账号求迅雷云播账号创维云电视功能创维新出的4K超高清健康云电视有谁用过,功能效果怎么样?怎么升级ios6苹果iPhone6怎么升级系统人人逛街过节了,这儿可真热闹写一段话ejb开发EJB是什么?iphone6上市时间苹果六什么时候出的电子商务网站模板电子商务网站策划书
80vps qingyun 免空 空间论坛 共享主机 爱奇艺vip免费试用7天 免费美国空间 爱奇艺vip免费领取 如何安装服务器系统 免费网页申请 中国电信宽带测速器 如何建立邮箱 最漂亮的qq空间 cloudlink 电信网络测速器 php服务器 iki lamp是什么意思 主机返佣 rewritecond 更多