ACompetitiveComparisonBetweenOracleEngineeredSyste

EngineeredSystemsandSAPMay16th,2014Copyright©2014AccentureAllRightsReserved.Forinternaluseonly!•Morethan15yearsofDatabaseExperience•Hehasbeenworkingindifferenttechnicalroles:databaseadministration,databasedesign,development.HehasdeepexpertiseinOracleRDBMSRACfromversion8onwards,SybaseASE,IBMDB2•AccentureOracleEngineeredSystemsLeadforFinlandandworkscloselywithAccenture'sEngineeredSystemsLeadership•DatabaseBlogat,FinlandTel:+358(0)[e-mail]©2014AccentureAllRightsReserved.Forinternaluseonly!AgendaExadata:BriefIntroductionOracleExadataunderSAPOracleExadata:UseCases&AccentureExadataAssetsEvaluationofOracleExadataandSAPHANAHANAvs.OracleIn-MemoryOracle&SAPPartnershipandJointWorkQ&A2Copyright©2014AccentureAllRightsReserved.Forinternaluseonly!AgendaExadata:BriefIntroductionOracleExadataunderSAPOracleExadata:UseCases&AccentureExadataAssetsEvaluationofOracleExadataandSAPHANAHANAvs.OracleIn-MemoryOracle&SAPPartnershipandJointWorkQ&A3Copyright©2014AccentureAllRightsReserved.Forinternaluseonly!OracleExadataispartofabundleofin-memoryapplications4WhatisOracleExadata?ExadataExalogicSuperClusterBigDataApplianceExalyticsWhatisit?DatabaseMachineforconsolidation,datawarehouse,OLTP,andmixedworkloadsApplicationMachineforPrivateCloudandconsolidatingOracleFusionMiddleware,OracleapplicationsandLinuxapplicationsMulti-purposeSolaris/SPARCsystem.DesignedforconsolidationofOracleandthird-partyapplicationsanddatabaseenvironmentsOptimizedforBigData.ExpandableHadoopandNoSQLbasedsystem,optimizedforlowdensityandunstructureddataIn-MemoryBIMachine.ExtremeperforminginmemoryandmiddletieranalyticsplatformMarketMaturity4,000Installsandgrowing100Installsandgrowing300Installsandgrowing100Installsandgrowing400InstallsandgrowingCopyright©2014AccentureAllRightsReserved.Forinternaluseonly!OracleExadataisajointhardwareandsoftwaresolutionThesystemis:•Completeandintegrated(servers,network,storage)•WithonearchitectureforOLTP,DataWarehousing,ConsolidationandDatabaseCloudWorkloads•Pre-builtandscalable•Balancedworkload•Securecloud-basedOracleExadatahasthepurposeto:•Reducesystemsintegrationeffort•Runexistingapplicationsunchanged,includingSAP•Applyexistingpersonnel,skills,Oraclelicenses•Speedupdatabasequeriesperformance•Lessadministration,simplerpatching,betteruptime•Consolidateplatformsanddatabases,reducepowerandcoolingcosts•ItleveragescommoditycomponentstodeliveralowerTCO5WhatisOracleExadata?Copyright©2014AccentureAllRightsReserved.Forinternaluseonly!OracleExadatafacilitatestolowtotalcostofownership6WhatisOracleExadata?TheOracleExadataDatabaseMachineprovidesperformanceforboth,datawarehousingandonlinetransactionprocessing(OLTP)applications,makingitaplatformforconsolidatingontogridsorprivateclouds.Thisprimarilyleadsto:•Reducenon-discretionaryeffortwithdatabaseconsolidation,reducelicensecostsandoperationalexpenditures•Considerbusinessintelligence,analytics,OLTPordatawarehouseimplementationsCopyright©2014AccentureAllRightsReserved.Forinternaluseonly!OracleExadataisacomprehensiveapproach7WhatisOracleExadata?TheExadataDatabaseMachineiscomposedofdatabaseservers,OracleExadataStorageServers,anInfiniBandfabricforstoragenetworkingandalltheothercomponentsrequiredtohostanOracleDatabase.InfinibandNetwork40GB/SecTransferRateNoBottleneckDatabaseclusterStorageGridScalable,Secure,Redundant•Exadataisengineeredend-to-end,optimizedasFull-Systemandreadytorun•Buildsonprovenlong-termSAPonOracleDatabaseleadershipandskills•CertifiedbySAPCopyright©2014AccentureAllRightsReserved.Forinternaluseonly!8WhatisOracleExadata?Copyright©2014AccentureAllRightsReserved.Forinternaluseonly!OracleExadataisanengineeredoffering9WhatisOracleExadata?InnovationBenefitsSmartstoragecapabilitiesSmartstoragereducestheI/ObandwidthconsumptionandCPUconsumptionofdatabaseserverbyoffloadingqueryprocessingtodataawarestoragelayer–DWdatabasesgainsignificantfromthisExadatacapability.HybridcolumnarcompressionforOLTPReducedwarehousesizeinExadataincreasestheDWdatabasesperformanceduetolowerdatabasescanI/O.Thereareassociatedcapexsavingstoo.SmartflashcacheRepeatedrandomreadsandwritestypicalofOLTPdatabasesbenefitfromtheusageofFlashcache–enhancesread/writeperformancebetween8X–20Xresultinginsmootheronlineexperience.InfinibandnetworkBothDWandOLTPdatabasesgainsignificantfromtheusageoftheultrahighspeedInfinibandnetwork–datamovementbetweendatabaseandstoragelayershappenveryfast.SingleStackforallOracleproductsBothDWandOLTPdatabasesbenefitfromtheeaseofpatchingandmaintenanceofExadata.saaaIntelligentStorageHybridColumnarCompressionSmartPCIFlashCacheCopyright©2014AccentureAllRightsReserved.Forinternaluseonly!Thein-memoryvisionassolutionforbottlenecksindataanalysis10WhatisOracleExadata?QueryResultsAggregatesIndexesDataWarehouseOperationalDataStoreCalculationEngineCopyETLQueryTraditionalApproachforDataAnalysisIn-memoryanalyticsDatabase(OLTP+OLAP)In-memoryApproachforDataAnalysisBusinessData•Transactionaldataisnotavaialblerightafterth