07_SAPHANA内存计算概览

SAPHANA™Ӄ؁ਗ਼ॠяঔம橆ؗݿґ㔴ͧۙૼߟڵोеԂPatrickWeng冋ںਧ௙٭HANAு୼[e-mail]©2011SAPAG.Allrightsreserved.2੠स„Ӄ؁ਗ਼ॠࣩ஫ԇՂՆى„SAPؗݿݤܨڕݓ-HANAяঔ„SAPPredictiveAnalysisяঔ„HANAࣩӀֹڀ࣐Ղߥ҅„ୋग़©2011SAPAG.Allrightsreserved.3ࢻؗ:ґ㔴ࢗ䎮ؙېݤܨੂӯӣߤރ݇GPS஬ࡌઋӦବچବࣤрބݤܨ୦։ߑѫ߆ԇऄઢؚۯڀ؂ਜ਼Ԥऄ׿ଽўTweetsઋӦThings१Ԉԯޞࢃێґ㔴Јӆށઙͧёࡢଞґ㔴З਑ՇўҚՉڰށઙ©2011SAPAG.Allrightsreserved.4࠿מͫރљԞЅઋङ޴ਈગו澝Ѯ۟֘澝ޗޞޗӶङէեՖ঩৏Ѯ૿वރ݇ͫײѾر଑пؘޞङރ݇ԆٗۨОؗݿङҒێͫОѣЏݕ҈ؗݿӐঌङङ҉݇;ײѾ޾ױङؗݿѩԗࣿф澝࣒ࡶͫٮԉѣЏՕܴ৒ۅՇي;ۊњࣩग़ߥފ͵Ӄ؁ਗ਼ॠ܉ߐٝҪક֨߆ԇ֘ङПӄ؂Иהࣲ૝ם୏ङؘޞރ݇ͫђӣߤչсޣИݕ҈ԯޞङৈߧ͠ޥьС੕ӏԃࡄէͺ©2011SAPAG.Allrightsreserved.5RAMџࠀЈ஑Four1.86GHz8-coreIntelNHMprocessorsin4UBoxEightmemoryboardsat1067MHzSamsungDDR316GBDIMM1TBӄ؂םֺRAMֲࠥ֌ऀCPUПைЉӇՊڽCPUӄ߾ރ୏Љލ׍ԆӃ؁ਗ਼ॠ۪ޱׁࣩकיߟדࣂ֗ל؟ଞӃ؁+©2011SAPAG.Allrightsreserved.6Ӄ؁ࠢझࣶڼ100ࣨЄҔӱ2012ٶ,70%ङҶࣱ1000ڠѣЏѫرޢূރ݇حҵӄ؂ͫљݕԟ֌ԇ޴ਈځऀङۅਈ澞-Gartnerѭঞݤܨٿझࣶ੾ՇࠥरӃ؁ݤܨٿӃ؁੾Շঈरёԗц㑦ࠖ઩ӰІࡢ͜զӸ઩ࠖ͜©2011SAPAG.Allrightsreserved.7ܦՕளॏާԆ֗ৗؗࢻȐள㓬ৗਗ਼ॠȑէͺדࣂࠆړ࣌஖ѭঞݤܨٿझࣶ؁Ҥߌ߄ЈՉ୦։࣒ࡶѓڀીԇCRMEKPOӸॏࣩڀ࣐ॸঞӃ؁ी୎ރ݇ࡶЈਸ਼͜„ރ݇ۈީ्द-ӄ؂-CPUͫރ݇թզङࣼே҉ࣀ؂֨„࡚߄ޏֺ߫ߣङރ݇ڀݵ㣜ͫثॆўङՇيޗࡣҭӣӯऀڭלࣩ©2011SAPAG.Allrightsreserved.8SAPӃ؁ਗ਼ॠ۪ޱࣩૡԖHANAީׂйSAPङӄ؂ઋ঑܉ߐЉލ଒ԗङфսSAPBusinessObjectsandotherApplicationsSAPBusinessObjectsandotherApplicationsSQLMDXBICSSAPHANASAPHANASAPECCSAPECCSAPBWSAPBW3rdParty3rdPartyReal-TimeReplicationSAPBusinessObjectsDataServicesSAPHANAѢЎ࢝߂ޏ࣍ߎSPS0520102003+MaxDBLiveCacheTREXSAPLiveCacheSAPTREXׂйઅ਩ङ؍ҶݜফઆӐސࠄͫ୓ثৈߣԗչளৈߣԗރ݇2009رBWAङ௤ݼչExplorerङএѐৈՠ૜ߛͫђ৲Օљ҅BIExplorer֨ह୿Օљӣߤם୏ङރ݇BOExplorerAcceleratedversionପଋԆବރ݇ङݕՈђ৲ݕԟBWܕ੮߲તङۅਈͫЭݵܴԈہઋ঑չރ݇ৼத2007SAPBWAԅૻ֗©2011SAPAG.Allrightsreserved.9੠स„Ӄ؁ਗ਼ॠࣩ஫ԇՂՆى„SAPࣩӃ؁ਗ਼ॠ۪ޱ-HANAяঔ„SAPPredictiveAnalysisяঔ„HANAࣩӀֹڀ࣐Ղߥ҅„ୋग़©2011SAPAG.Allrightsreserved.10HANA-ள㓬ৗӢ߅੕ӏݱߥؗݿਗ਼ॠ„࡚߄ڍଖङЏԇӣߤדࣂ૙ܩ„ךהࣲ֘ͫࢁ୏ӄ؂„ؘޞङઋ঑ږݲ„বإݵܴERPफ़Ԥބ࣐„௄੸ङગו„ӄ৥BAEͧЏԇӣߤږݲͨݖܕਸ਼ЎߗӔ„ANSI92SQL„MDX,JDBC/ODBCHANAފьСHANA۪ޱஅݰHANAࣩЖࢤ䎯ݤܨۻՇոىࢻНьСފHANASAPHANASAP֋Ԇ׫ѝERP/CRMॗॗ…Ҿєґ㔴ॸঞDB2SybaseOracleSQLServerؘޞգ࠵޾ޏETLٗӀHANAStudioڏࠥ঒ࣲBIؙېॏSQLMDXBICSӄ؂ރ݇ڀӄ؂ރ݇ڀDWݤܨђٿॕЅݱߓੳٖҿਗ਼ॠոਗ਼ӥڕݓਸ਼&Ӧ؁Ҥ©2011SAPAG.Allrightsreserved.11SAPHANA۪ޱߌ߄HANAފьСHANA۪ޱஅݰHANAࣩЖࢤ䎯ݤܨۻՇոىࢻНьСފHANASAPHANADatabaseઘ୼બࡌהࣲ/ۼ੧ݏӲSQLParserMDXSQLScriptCalcEngineзԇ঒ࣲރ݇ڀѫઢ঒ࣲҼ঩ږݲRowStoreColumnStoreރܴ݇СكPageManagementLogger्द؂ҥLogVolumesDataVolumes݉ߓ঒ࣲҫރ݇঒ࣲԆૺݏӲ֘ރ݇זӲ߆ԇ©2011SAPAG.Allrightsreserved.12SAPHANAखѝהࣲ֘„ਸ਼ࣔضਙڠהࣲ֘„4~8Зࠤѹ/Пߡӄ؂——Оݤܨԙ„64GBν2TB„ԥߚ16GBљЇङӄ؂؂ҥޙںԲԚ„ڽବ୺؂दPCIe-Flash/SSD„ڽବկԈչգ࠵ޙں؂ҥ/्द„ڽବ्दSASdrives„ރܴ݇Сكݵܴৠৌ„ךЗ10Gb٫ءङ௤ବৠԪHANAފьСHANA۪ޱஅݰHANAࣩЖࢤ䎯ݤܨۻՇոىࢻНьСފHANA©2011SAPAG.Allrightsreserved.13HANASAPHANAފखѝո૆ѝࣩ▁ѼԖ੦הӃ؁ਗ਼ॠڕݓӃ؁ݤܨٿؗݿݤܨॡࣂٴՕ૆ѝ+ੜ੩ࣩखѝॸঞखѝHANAފьСHANA۪ޱஅݰHANAࣩЖࢤ䎯ݤܨۻՇոىࢻНьСފHANA©2011SAPAG.Allrightsreserved.14ૹ૚SAPHANAੜ੩ࣩखѝ੦הள؏ޅӧ੮)HANAފьСHANA۪ޱஅݰHANAࣩЖࢤ䎯ݤܨۻՇոىࢻНьСފHANAબઘ୼©2011SAPAG.Allrightsreserved.15ॆў܉ߐஶޏ૷ў܉ߐஶޏӃ؁ਗ਼ॠ۪ޱࣩ“䶟᯦”„64bit֪֭ॱ୿ȌԥՖ۽يӱ2TB„100GB/sރ݇Ѯ૿„џࠀଊବЈ஑ͫۅਈଊବݕԟ„ך߾הࣲ֘߫ߣ࠿ՖӢ࣌8x8߾CPU)„ם୏Ӣ࣌ٷ੧଍੧„࠿ՖӢ࣌ङџࠀѺڊ„੧ӧ؂ҥͫث઻؂ҥ„Թঢ়„ӣԚӱךՖ߆ԇ֘ਭࢵ„Ոࢃৼத੮„Ցݖҵ׍୏ރ݇ӄ؂ઋ঑ङࠢھٷЉޏ௪ͫࣀ৲சवॆўङۨߎЈ஑љՃ૷ў܉ߐङஶޏͫએSAPՕљӯऀׂйӄ؂ङځऀݕ҈ুৃؘޞ঒ࣲչ଍৓ङ۠ްHANAފьСHANA۪ޱஅݰHANAࣩЖࢤ䎯ݤܨۻՇոىࢻНьСފHANA©2011SAPAG.Allrightsreserved.16Ӧړਸ਼ړ؁Ҥࢲࡴङ૴݅SAPHANAॸঞӃ؁ݤܨٿݤܨٿڕݓӃ؁ݤܨٿݤܨٿڕݓӧ؂ҥ੧؂ҥ„ܷ஬ଣܫۏڢङ؂ҥސڔ„੧ڔӧڔਘंл૴„ݷՊ؂ҥސڔޗ஬୍կHANAފьСHANA۪ޱஅݰHANAࣩЖࢤ䎯ݤܨۻՇոىࢻНьСފHANA©2011SAPAG.Allrightsreserved.17HANAࢤ䎯▁ރ݇Թঢ়ԅૻӄ؂ߢବઘ୼׸դֽ١ۅӰڙٌԘчअ㬮֚Їࢁ׮㬮㱌Їࢁ׮㬮㱌Їࢁ׮Ѯ৏Ҽ঩ֺރ݇ڀ੮Ӧړ؁Ҥݤܨ؀ӀԸবڙٌ㬮֚㬮㱌㬮㱌ԘчЇࢁЇࢁЇࢁअ׮׮׮0:ڙٌ1:㬮֚2:㬮㱌0:Ԙч1:Їࢁ0:अ1:׮Ӧړ؁Ҥ૜ਸ਼େڅԸব1x01x12x21x03x11x03x10:ڙٌ1:㬮֚2:㬮㱌0:Ԙч1:Їࢁ0:अ1:׮1x0੮ॐЗڙٌ*եவङރ؁੮ॐؘஎङқHANAފьСHANA۪ޱஅݰHANAࣩЖࢤ䎯ݤܨۻՇոىࢻНьСފHANAࠆ܈Ӄ؁Зࣩݤܨ©2011SAPAG.Allrightsreserved.18HANAࢤ䎯зރ݇ӣ৲࡞Фݤܨ„Ӄ؁ޯ֩Ԗͫ܋םރ݇୏չઋ঑୏ӣށӱЉգהࣲ֘„ٶਸ਼דࣂͫЉգङ߆ԇ֘Ф୿Эһцգ▲ুރ݇„؟䍴㓬ͫԥ▲ङ߆ԇ֘ङDOWNߑرЉڧրѠѾઋ঑HANAފьСHANA۪ޱஅݰHANAࣩЖࢤ䎯ݤܨۻՇոىࢻНьСފHANA©2011SAPAG.Allrightsreserved.19HANAࢤ䎯зރ݇ӣ৲࡞Фރ݇ӣԚչٷ੧הࣲͧMPPࠥڔͨҸ՛ࡨӆ֪ঝӰSAPԘчי૏IBMԘчי૏HPЇࢁՠ૏HPԘчי૏SAPԘчי૏IBMԘчי૏HPЇࢁՠ૏HPԘчי૏ާԆ֗AާԆ֗BNewDBॡࣂॸঞSelect*fromtableWhere६ӯ=‘טઞ’HANAފьСHANA۪ޱஅݰHANAࣩЖࢤ䎯ݤܨۻՇոىࢻНьСފHANAݤܨٿ਽ੑ֢©2011SAPAG.Allrightsreserved.20HANAࢤ䎯зך߾ٷ੧הࣲCPUߟ-1CPUߟ-2CPUߟ-3CPUߟ-4HANAފьСHANA۪ޱஅݰHANAࣩЖࢤ䎯ݤܨۻՇոىࢻНьСފHANA©2011SAPAG.Allrightsreserved.21HANAࢤ䎯Ѕ߂شԗރ݇Ѯ૿ѭঞࣩݱړݤܨਗ਼ॠݤܨٿق஄ґ㔴ॸঞڀ࣐قࠆړૃՉSAPHANAґ㔴ॸঞڀ࣐قݤܨਗ਼ॠ␔ⷧ帰並ㆤ㝝␔ⷧ帰並ㆤ㝝Ӄ؁ݤܨٿHANAފьСHANA۪ޱஅݰHANAࣩЖࢤ䎯ݤܨۻՇոىࢻНьСފHANA©2011SAPAG.Allrightsreserved.22HANAࣩ߃ૻ㓬ৗҶ੮۾ݔͫޗѠѾѩԗͧޗফږͫӣԚঈͨԤ਽-8ԝࣨЄ޻ݤܨٿ੢ڢ-2ࡄॡ৏ઋ؏ۨ-1ॡ؏ۨҶୂङઋ঑মԆઋ঑SUM/MIN/AVGঈҶ੮۾ݔͫޗѠѾѩԗͧޗফږͫӣԚঈͨHANAފьСHANA۪ޱஅݰHANAࣩЖࢤ䎯ݤܨۻՇոىࢻНьСފHANA©2011SAPAG.Allrightsreserved.23ݤܨؗݿբࠖ୓ثSAP঩৏ङSLTؘޞգ࠵SAPॸঞރ݇ڀ੮DBઇՇ֘ޙںઓڣ੮યՈֲࠥSAP-SLTॸঞSAPHANAॸঞӃ؁ݤܨٿݤܨٿڕݓӃ؁ݤܨٿݤܨٿڕݓӧ؂ҥ੧؂ҥӊރֲ݇ࠥݏӲֲࠥRFCକݎރ݇ڀକݎ„ՕযͫՕএङIT߫ߣސڔ„ؘޞङҒێգ࠵ͫҒێޗڍଖͫЭՕؔޞҁЏգ࠵„ٝੴચޢङٺࡤ҅ऀङ܉ߐͧனㄹߑͫTDMSͫ10+ٶङாऩ௠ચͨHANAފьСHANA۪ޱஅݰHANAࣩЖࢤ䎯ݤܨۻՇոىࢻНьСފHANA©2011SAPAG.Allrightsreserved.24ݤܨؗݿբࠖ୓ثNon-SAP঩৏ङSLTؘޞգ࠵ஂSAPॸঞރ݇ڀ੮DBઇՇ֘ޙںઓڣ੮SAP-SLTॸঞSAPHANAॸঞӃ؁ݤܨٿݤܨٿڕݓӃ؁ݤܨٿݤܨٿڕݓӧ؂ҥ੧؂ҥӊރֲ݇ࠥݏӲֲࠥރ݇ڀକݎ„ՕযͫՕএङIT߫ߣސڔ„ؘޞङҒێգ࠵ͫҒێޗڍଖͫЭՕؔޞҁЏգ࠵„ٝੴચޢङٺࡤ҅ऀङ܉ߐͧனㄹߑͫTDMSͫ10+ٶङாऩ௠ચͨHANAފьСHANA۪ޱஅݰHANAࣩЖࢤ䎯ݤܨۻՇոىࢻНьСފHANAયՈֲࠥރ݇ڀକݎ©2011SAPAG.Allrightsreserved.25SAPHANAӃ؁ݤܨٿݤܨٿڕݓӃ؁ݤܨٿݤܨٿڕݓݤܨETLERP/MIS/…ރ݇ڀځऀ঩৏DSગઋ֘DSҁЏ߆ԇ֘ރ݇ࢎ࡮ͫ૴݅ͫޅࣲؔޞङҁЏܚՈͫգ࠵DSગઋ֘DSҁЏ߆ԇ֘ރ݇ࢎ࡮ͫ૴݅ͫޅࣲؔޞङҁЏܚՈͫգ࠵DataServicesঐѝDataServicesঐѝDSગઋ֘DSҁЏ߆ԇ֘ރ݇ࢎ࡮ͫ૴݅ͫޅࣲؔޞङҁЏܚՈͫգ࠵DataServicesঐѝҾєґ㔴ॸঞރ݇ڀځऀ঩৏ӧ؂ҥ੧؂ҥHANAފьСHANA۪ޱஅݰHANAࣩЖࢤ䎯ݤܨۻՇոىࢻНьСފHANA©2011SAPAG.Allrightsreserved.26ݤܨࣩىࢻSAPIn-MemoryDatabase-ӄ؂ރ݇ڀؘޞգ࠵ރ݇SAPBWSAPBW3rdParty3rdPartyܚՈރ݇SAPBusinessObjectsBI4.0SemanticLayerCrystalWebIDashboardsExplorerAOfficeSQL(ODB