数据库结果集缓存的研究与实现

《数据库结果集缓存的研究与实现》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、西南交通大学硕士学位论文数据库结果集缓存的研究与实现姓名：杨永亮申请学位级别：硕士专业：计算机应用技术指导教师：唐慧佳20080601AbstractAlongwiththecontinuousaccelerationofthesocialinformationprocess，dataquantitywhichneedbedealtbyavarietyofapplicationsbecomemuchbigger，SOitseemsespeciallyimportanttOimprovethedatabaseaccesss

2、peedoftheresponse．ResultcacheisausefulQueryOptimizationTechniqueforimprovingdatabaseresponsecapacity．Whenusersquerydatabase，meresultcacheCalldirectlyreturnthequeryresultbystoringqueryresultsinacachetable．Becauseofavoidingsearchesforthehugetableandthetime·consumin

3、gconnectionsoperations，theresultcacheimprovesSQLQueryEfficiency．Thispaperfirstlyintroducestheconceptoftheresultcache，andexpoundsthepositionoftheresultcacheinthequerysystem．Secondly,threetechnologiestOachieveresultcachearestudied：memoryspacemanagement；transactionm

4、anagement；cacheconsistencymanagement．Inthesestudiesthepaperputsforwardsimprovedalgorithmfortheresultchache．FinallytheserverresultcacheisdesignedandimplementedinthedomesticdatabaseOscar．Itisstudieddeeplythatthememoryallocationalgorithm，thememoryindexalgorithm，thec

5、achereplacementstrategyandthecachefailuretreatment．Thepaperalsoprovidesasolvingschemeandadetaileddesignofthedataconsistencymaintenancebetweentheserverandtheclient．Thestructureofthispaperis：firstlythepaperintroducestheconceptoftheresultcache．researchestheresultcac

6、heofORACLEdatabase，andmakesafeasibleanalysisoftheresultcacheimplementationinthedomesticdatabaseOSCAR；Secondly，thepaperenumeratesseveraltechnicalproblemsoftheresultcache，andfinallythealgorithmandstrategytOachievetheresultcahceisgiven。Measurementresultsindicatethat

7、thedesignoftheresultcacheisveryusefulforimprovingtheperformanceofread-intensiveworkloads．Keywords：ResultCache，memorymanagerment；problemconcurrencycontrol；failuremechanism：cacheconsistency西南交通大学学位论文版权使用授权书本学位论文作者完全了解学校有关保留、使用学位论文的规定，同意学校保留并向国家有关部门或机构送交论文的复印件和电子版，允

8、许论文被查阅和借阅。本人授权西南交通大学可以将本论文的全部或部分内容编入有关数据库进行检索，可以采用影印、缩印或扫描等复印手段保存和汇编本学位论文。本学位论文属于1．保密口，在年解密后适用本授权书；2．不保密d使用本授权书。(请在以上方框内打“4")学位论文作者签名：伯夺施日期：硼2。&Ⅶ，指导柳签名：丁绑日期：朋乎