SAP HANA培训教材_05SAP HANA TechIntro + Operations

SAPHANAProductManagementDecember2011SAPHANAOperations©2011SAPAG.Allrightsreserved.2DisclaimerThispresentationoutlinesourgeneralproductdirectionandshouldnotbereliedoninmakingapurchasedecision.ThispresentationisnotsubjecttoyourlicenseagreementoranyotheragreementwithSAP.SAPhasnoobligationtopursueanycourseofbusinessoutlinedinthispresentationortodeveloporreleaseanyfunctionalitymentionedinthispresentation.ThispresentationandSAP'sstrategyandpossiblefuturedevelopmentsaresubjecttochangeandmaybechangedbySAPatanytimeforanyreasonwithoutnotice.Thisdocumentisprovidedwithoutawarrantyofanykind,eitherexpressorimplied,includingbutnotlimitedto,theimpliedwarrantiesofmerchantability,fitnessforaparticularpurpose,ornon-infringement.SAPassumesnoresponsibilityforerrorsoromissionsinthisdocument,exceptifsuchdamageswerecausedbySAPintentionallyorgrosslynegligent.©2011SAPAG.Allrightsreserved.4WhatisSAPHANA?HWtechnologyinnovations64bitaddressspace–2TBincurrentservers100GB/sdatathroughputDramaticdeclineinprice/performanceMulti-corearchitecture(8x10coreCPUperblade)MassiveparallelscalingwithmanybladesOneblade~$50,000=1enterpriseclassserverRowandcolumnstoreCompressionPartitioningNoaggregatetablesInsertonlyondeltaSAPSWtechnologyinnovationsConvergenceofimprovedhardwareeconomicsandtechnologyinnovationsenablesSAPtodeliveronitsvisionofthereal-timeenterprisewithin-memorybusinessapplications©2011SAPAG.Allrightsreserved.5InMemoryComputing–aparadigmshiftProgrammingagainstanewscarceresource…CoreCPUPerformancebottlenecktoday:CPUwaitingfordatatobeloadedfrommemoryintocachePerformancebottleneckinthepast:DiskI/ODiskCPUCacheMainMemory…requirescache-consciousdata-structuresandalgorithms.©2011SAPAG.Allrightsreserved.6SimplifiedMemoryHierarchyMainmemoryvs.Cache(BasedonIntelNehalem)CPUCore1stLevelCache2ndLevelCacheShared3rdLevelCacheCore1stLevelCache2ndLevelCacheCore1stLevelCache2ndLevelCacheCore1stLevelCache2ndLevelCacheSizeLatency64KB1-2cycles256KB6-20cycles8MB30-60cyclesSeveralGBsuptoTBs100-400cyclesMainMemoryFlash–5000cycles;Diskseek–10,000,000cycles©2011SAPAG.Allrightsreserved.7ColumnardatastorebenefitsOptimizesloadofdatatoCPUHighdatacompressionVeryfastdataaggregationMakesuseofreal-lifefilloftables(fewfieldsfilled,fewupdates)Canbejoinedwithrow-baseddataMakingUseofColumnarDataStoreA10€B35$C2€D40€E12$ABCDE103524012€$€€$memoryaddressorganizebyroworganizebycolumnA10€B35$C2€D40€E12$conceptualviewmappingtomemory©2011SAPAG.Allrightsreserved.8Advantage:CompressionColumnwisestorestablesbycolumnColumnscanbeaccessedinonereadColumnscontainonlyonedatatype,enablingveryhighcompression(10x)Accessingallattributesforonetuple(record)isanexpensiveoperationRowwisestorestablesbyrowDatarecordsareavailableascompletetuplesinonereadCompressionislimitedAccessingonlyfewattributesforeachtupleisanexpensiveoperationTuple1Tuple2Att1Att2Att3Att5Att4©2011SAPAG.Allrightsreserved.9Advantage:ParallelizationColumn-basedstoragealsosimplifiesparallelexecutionusingmultipleprocessorcoresOperationsondifferentcolumnscaneasilybeprocessedinparallelexecutionofoperationsononecolumncanbeparallelizedbydividingthecolumnintomultiplesectionsthatareprocessedbydifferentprocessorcores©2011SAPAG.Allrightsreserved.10Delta-MergeMain1IndexDelta1IndexDelta1IndexWriteBeforeMergeReadDuringMergeMergeOperationWriteMain1IndexNewMain2NewDelta2ReadNewMain2NewDelta2WriteAfterMergeRead©2011SAPAG.Allrightsreserved.11NextGenerationAnalyticsDBindexesMaterializedviewsSummarizationtablesScanspeed:2M/ms*VirtualviewsAggregationspeed:50M/s*TraditionalSAPIn-Memory©2011SAPAG.Allrightsreserved.12MaintenanceOperationWhatisSAPHANAfromLMperspective?SAPHANA–Prepackagedsolution,deliveredtothecustomerasinstalledandpreconfiguredsystem.–Built-inToolsforlifecyclemanagement,securityoptimizationandoperation.–Bestpracticesintasks,conceptsandproceduresnecessaryfortheongoingoperationArchitecture&LandscapeInstallationUpdate&PatchingAdministration&MonitoringBackup&RecoverySAPHANA-Architecture&LandscapeOverviewArchitecture&LandscapeInstallationAdministration&MonitoringUpdate&PatchingBackup&Recovery©2011SAPAG.Allrightsreserved.14SAPHostAgentSAPHANAstudioSAPHANAappliancesoftwareSAPHANAComponentArchitectureSAPHANAplatformedition–SAPHANAdatabase–SAPHANAclient–SAPHANAstudioP2repository–SAPHostAgent–Machinereadableproductdescription(LMstructurefiles)–SAPCAR–OperatingsystemconfigurationSLToolset1.0–SoftwareUpdateManagerforSAPHANA–SAPJVMSAPCARSAPHANAclientMachinereadableproductdescription(LMstructurefiles)SAPHANAdatabaseSLES11SP1ServerManagementTools(HWvendorspecific)StorageSubsystemSAPSoftwareUpdateManagerforSAPHANASLToolsetSAPJVMTheSAPHANAappliancesoftwarefromandeploymentpointofview:AwelldefinedandvalidatedstackofHWandSWcomponents©2011SAPAG.Allrightsreserved.15SAPHANAReplicationTechnologiesSAPHANAdatabase©2011SAPAG.Allrightsreserved.16SAPHANAsolution(addinge.g.SBOPBIclients)SAPHANAenterpriseextendededition(forlogbasedreplication)SAPHANAProduct&LicensePackagingBI4.0DashboardsCrystalReportsExplorerSybaseRep.AgentSAPHANALoadCtrlSybaseRep.ServerAddi