數(shù)據(jù)庫結(jié)果集緩存的研究與實(shí)現(xiàn).pdf

1、西南交通大學(xué)碩士學(xué)位論文數(shù)據(jù)庫結(jié)果集緩存的研究與實(shí)現(xiàn)姓名：楊永亮申請(qǐng)學(xué)位級(jí)別：碩士專業(yè)：計(jì)算機(jī)應(yīng)用技術(shù)指導(dǎo)教師：唐慧佳20080601AbstractAlongwiththecontinuousaccelerationofthesocialinformationprocess，dataquantitywhichneedbedealtbyavarietyofapplicationsbecomemuchbigger，SOitseemsesp

2、eciallyimportanttOimprovethedatabaseaccessspeedoftheresponseResultcacheisausefulQueryOptimizationTechniqueforimprovingdatabaseresponsecapacityWhenusersquerydatabase，meresultcacheCalldirectlyreturnthequeryresultbystoringq

3、ueryresultsinacachetableBecauseofavoidingsearchesforthehugetableandthetimeconsumingconnectionsoperations，theresultcacheimprovesSQLQueryEfficiencyThispaperfirstlyintroducestheconceptoftheresultcache，andexpoundstheposition

4、oftheresultcacheinthequerysystemSecondlythreetechnologiestOachieveresultcachearestudied：memoryspacemanagement；transactionmanagement；cacheconsistencymanagementInthesestudiesthepaperputsforwardsimprovedalgorithmfortheresul

5、tchacheFinallytheserverresultcacheisdesignedandimplementedinthedomesticdatabaseOscarItisstudieddeeplythatthememoryallocationalgorithm，thememoryindexalgorithm，thecachereplacementstrategyandthecachefailuretreatmentThepaper

6、alsoprovidesasolvingschemeandadetaileddesignofthedataconsistencymaintenancebetweentheserverandtheclientThestructureofthispaperis：firstlythepaperintroducestheconceptoftheresultcacheresearchestheresultcacheofORACLEdatabase

7、，andmakesafeasibleanalysisoftheresultcacheimplementationinthedomesticdatabaseOSCAR；Secondly，thepaperenumeratesseveraltechnicalproblemsoftheresultcache，andfinallythealgorithmandstrategytOachievetheresultcahceisgiven。Measu