资源描述：
《A Hybrid OLTP&OLAP Main Memory Database System Based on Virtual Memory Snapshots》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。
1、HyPer:AHybridOLTP&OLAPMainMemoryDatabaseSystemBasedonVirtualMemorySnapshotsAlfonsKemper1,ThomasNeumann2Fakultatf¨urInformatik¨TechnischeUniversitatM¨unchen¨Boltzmannstraße3,D-85748Garching1kemper@in.tum.de2neumann@in.tum.deAbstract—Thetwoareasofonlinetransactionprocessingda
2、tabasesystem.Inaddition,aseparateDataWarehouse(OLTP)andonlineanalyticalprocessing(OLAP)presentdiffer-systemisinstalledforbusinessintelligencequeryprocessing.entchallengesfordatabasearchitectures.Currently,customersPeriodically,e.g.,duringthenight,theOLTPdatabasechangeswithh
3、ighratesofmission-criticaltransactionshavesplittheirareextracted,transformedtothelayoutofthedatawarehousedataintotwoseparatesystems,onedatabaseforOLTPandoneso-calleddatawarehouseforOLAP.Whileallowingforschema,andloadedintothedatawarehouse.Thisdatastagingdecenttransactionrat
4、es,thisseparationhasmanydisadvantagesanditsassociatedETL(Extract–Transform–Load)obviouslyincludingdatafreshnessissuesduetothedelaycausedbyonlype-incurstheproblemofdatastalenessastheETLprocesscanriodicallyinitiatingtheExtractTransformLoad-datastagingandonlybeexecutedperiodic
5、ally.excessiveresourceconsumptionduetomaintainingtwoseparateRecently,strongargumentsforso-calledrealtimebusinessinformationsystems.Wepresentanefficienthybridsystem,calledHyPer,thatcanhandlebothOLTPandOLAPsimultaneouslyintelligenceweremade.HassoPlattner,theco-founderofbyusing
6、hardware-assistedreplicationmechanismstomaintainSAP,advocatesthe“dataatyourfingertips”-goalforenter-consistentsnapshotsofthetransactionaldata.HyPerisamain-priseresourceplanningsystems[2].ThecurrentlyexercisedmemorydatabasesystemthatguaranteestheACIDpropertiesofseparationoftr
7、ansactionprocessingontheOLTPdatabaseOLTPtransactionsandexecutesOLAPquerysessions(multipleandBIqueryprocessingonthedatawarehousethatisonlyqueries)onthesame,arbitrarilycurrentandconsistentsnapshot.Theutilizationoftheprocessor-inherentsupportforvirtualperiodicallyrefreshedviol
8、atesthisgoalasbusinessanalystsmemorymanagement(addresstranslation,caching,copyonha
