内存技术平台(SAP HANA)深度剖析_V1.0

PleasenotethatthisdocumentisSubjecttochangeandmaybechangedatanytimewithoutnotice.Thisdocumentisnotintendedtobindanyparticularcourseofbusiness,productstrategyanddevelopment...Ӄ؁۪ޱٴՕ(SAPHANA)࡬څӺ߅⢖щͫ2014ٶ7߃࣍13918717715੠सݤ؀Ѫ੹ੱSAPѐ৅SAPHANAӄ؂ރ݇ڀѐ৅SAPHANA܉ߐ߫ߣӻߤӣߤٵՖͧBusinessObjectͨSAPHANAځऀࠄ҆2014/8/82ݤ؀Ѫ੹ੱͧжؗ৕иୱ૔2014/8/83࡚ੰ֪ޑׁकݤܨଞOracle۝ਸ਼ݿ୎र)HANA۝ਸ਼ݿ୎र)ܶளҔݤOLAPӠݤ࡚ੰь6001.14526Ԥ਽ߓੳь7501.62462㔀଑Ѿ஛ь*7ь૝ޞ97*ऴӢߓੳь*7ь૝ޞ75*ؙېґ㔴ߓੳь*7ь૝ޞ0.4*਽գ੢ڢݤBWStorage(MB)HANAStorage(MB)Ըবࢴ/BIC/AZINV_D0100247,718,40896,761.006,192.0015.63/BI0/PMATERIAL258,023104.006.5016.00/BIC/AZFF_O1400742,91856.0013.004.31/BIC/AZSD_D2800538,97832.003.908.21/BI0/TMATERIAL257,17417.001.739.83/BIC/Z0PLANT23,7492.000.643.13㓬ৗ͵㖏ъࣩտڀૻڅ؁Ҥ͵Ք੏ࣩԸবࢴۊњފ㓓СҞࣩͺ2014/8/84DataServiceSAPBWColumnTableRowTableAttributeviewAnalyticviewCalculationviewWebIExplorerDashboardCrystalReportAnalysisECCSLTLegacySystem੠सރ؁ѫપઢSAPяঔSAPHANAӄ؂ރ݇ڀѐ৅SAPHANA܉ߐ߫ߣӻߤӣߤٵՖͧBusinessObjectͨSAPHANAځऀࠄ҆2014/8/85SAPяঔSystemsApplicationsandProductsinDateProcessingSAPۨॹй1972ٶͫۈୂѹйڴ֢ࡗضךנ١ͫީҶࣱ߂םङѣЏ঒ࣲչԣգԗऄ׿֌ԇઆӐސࠄ҈ځ֌澝ҶࣱআІםࣞॹ૷ў҈ځ֌澞ऩӹͫSAP֨50ךЗ֢؟ܨ߄29,000ךդմٗ澞SAP֨120ךЗ֢؟չ֪Ԛܨ߄18,800ך؟ؚۯ澝56,000ךЗ঩৏؍੸ࢵљՃ1000Ѕךդ߂ৄऀۯͫЍउ500ڠИ80%љЇङҸ՛ୃ֨҅ऀSAPङ঒ࣲઆӐސࠄ澞2014/8/86੠सރ؁ѫપઢSAPѐ৅SAPHANAӃ؁ݤܨٿяঔSAPHANA܉ߐ߫ߣӻߤӣߤٵՖͧBusinessObjectͨSAPHANAځऀࠄ҆2014/8/87سৼSAPHANAӄ؂܉ߐࠢଚ2014/8/88ࣹӸѢЎঃґ㔴ߌ߄ޥלଞڌ૥„јझࣶНЗڵࣩਗ਼ॠૼۉٙלࣩਗ਼ॠ࣌஖„I/O࣌஖ج৩ڌ૥ՂCPUࣩѹݝӮ࣐„һॸֹݤܨٿНOLTP੦ਗ਼ࣩͧুԤ▁ࣩݤܨ؁ҤࣩݱړݸࡄளݝࢁરӢ߅୻࠭„80%ࣩOLAPߓੳ࣐҄ЈӰ20%ࣩ਑Շࣩਸ਼ݤܨ„…ڕફו޳ࣩڏՆज़ࣛ„…ૼۉѹݝࣩ଑঵ݱߥ„…٪޼Јװࣩ࣐ېѼய2014/8/89झࣶI/Oފ࣌஖அշ㓬ࣩਗ਼ॠ޲۪ޱ2014/8/810૚Խࢻ֧ޭ޼☢ࣶI/O⎼஖ਸ਼؁ҤӦ؁ҤӢԙԸবӉҴDelta؁ҤSSDFlashHDDCPUӃ؁झࣶूऔ㓬ࣩ૆ѝ۪ޱ:HANA2014/8/811्दӄ؂ͧރ݇ͨ୺؂-Flashͧޙںͨރ݇ӊҵգ࠵ӊҵߛਘѠѾDBߛਘѠѾ঩৏ڑ࠵֋Ԇޕৗ૆ѝ-BI۱߄ङI/Oͫઋ঑ୃ֨ӄ؂୍կФեޣफ़Ԥࣩࣂ੕SAPHANAؗݿݤܨਗ਼ॠٴՕؗݿ„Џԇޗڍଖؘͫޞઋ঑„ࢁ୏ރ݇ͫह୿ڱӱৈߧ૙ܩ„ךהࣲ֘ͫࢁ୏ӄ؂„ؘޞङઋ঑ږݲ„ݵܴOLTP+OLAPࢌՠિૺڏݚړखѝߌ߄„x86߫ߣङ▲ѽߑ„ӄ৥BAE(Џԇӣߤږݲ),BFL澝PALڀͫதۨR澞ڏݚړ૆ѝߌ߄„SQL/ODBC/JDBC/ODBO..„Python/OData/Web߆ԇ2014/8/812ڏࠥٗӀӄ؂ރ݇ڀӄ؂ރ݇ڀރ݇߆ԇઋ঑ږݲӧ؂ҥ੧؂ҥؗݿӕؘޞSLTDSDXCކўՔڎࠆݤܨٿٴՕSAPBISQLMDXBICSҾєBIݰڀ࣐,ױशԇSAP֋Ԇ׫ѝERP/CRMঈঈ…Ҿєґ㔴ॸঞׂйDB2,Sybase,Oracle,SQL-ServerঈͨDWݤܨђٿЏԇԅਈڀ௄ࡹӣߤڀځऀ߆ԇAppږݲHTML5R/Hadoop޾ך…տফ͈ޯܞࣔহ(HassoPlattner)᧶҅ऀӧڔչ੧ڔࢌՠ؂ҥङӄ؂ઋ঑܉ߐؘͫ࣫OLTPչOLAPङପऀރ݇ڀٵՖSAPHANAੜ੩ࣩखѝॸঞ2014/8/813„ԥߑђ128GB~4TBӄ؂„޾ךङॆў҈ځ֌ͫ૝ଋ60य़ઁࠀङઍચॆў߆ԇ֘„кୂ০„ઍચङգ࠵ͫڑ࠵ङத৩ؠࢳוѡۊזސࠄ„BIͫETLͫוѡٗӀङઍચ„֠৉HANAٵՖङӬӫѣЏ(150+ޏӫҸ՛|startups.saphana.com)ੜ੩ࣩखѝॸঞ„ӄ؂ؠ୏͹128GB~500TB„ઋ঑ਈԃ͹16߾~10,000߾„ђԥਭࢵӱ125Зਭࢵङத৩ՔسͧՔלࣩٴՕSAPHANAࣩԣભ㓬ৗݸЉѯࠢSAPؙېؗ੩͵„ݕ௤1,000ҕ͹કךӣߤࡶ३ͧ➻࠮澝ૃ௹ͨ„ݕ௤10,000ҕ͹ӌנٌࡡ澝Essar澝SAPIT澝ډשضם؆„ݕ௤100,000ҕ͹Yodobashiۋী„ђ24شޞљЇӗصӱ3.8ॡ:ௐս௓މ/ӣ୦–࣒ࡶͫђ৲஑Ѻд35%ङ଍ો„ђ15شޞљЇӗصӱ4.8ॡ:ாऩ঒ࣲ/߆ԇ–ӯ䃔,働ݼ„ђ3מӗصӱ2ॡ:ன։/ґக–׫୐2014/8/814ԼޥॸঞSAPHANA┿ⓗᛌؗݿޟڼࣩ۶਽Ӣ߅ૻڅݤܨளԸবࠢݤ؀Ѫ੹ੱͧжؗ৕иୱ૔2014/8/815࡚ੰ֪ޑׁकݤܨଞOracle۝ਸ਼ݿ୎र)HANA۝ਸ਼ݿ୎र)ܶளҔݤOLAPӠݤ࡚ੰь6001.14526Ԥ਽ߓੳь7501.62462㔀଑Ѿ஛ь*7ь૝ޞ97*ऴӢߓੳь*7ь૝ޞ75*ؙېґ㔴ߓੳь*7ь૝ޞ0.4*਽գ੢ڢݤBWStorage(MB)HANAStorage(MB)Ըবࢴ/BIC/AZINV_D0100247,718,40896,761.006,192.0015.63/BI0/PMATERIAL258,023104.006.5016.00/BIC/AZFF_O1400742,91856.0013.004.31/BIC/AZSD_D2800538,97832.003.908.21/BI0/TMATERIAL257,17417.001.739.83/BIC/Z0PLANT23,7492.000.643.13㓬ৗ͵㖏ъࣩտڀૻڅ؁Ҥ͵Ք੏ࣩԸবࢴݱࡄٜͧকݘՉ2014/8/816ѭঞࣩݱࡄ:֧ڀ࣐ق۝ਸ਼੤יݤܨؤ୳ֹݒҀڀ࣐قݤܨٿقࢻ֧ޭ޼ࣩݱࡄ:Ӄ؁З۝ਸ਼ݤܨؤ୳ֹਗ਼ॠਗ਼ॠ૽્ਗ਼ॠ૽્۬ݤܨؤ୳ֹࣩਗ਼ॠ૽્ЇݚӰݤܨٿقͣӃ؁Зਗ਼ॠ֧ͤڀ࣐قոݤܨٿقУ୎ͧՐѭ૶ਗ਼ॠࣩগ߈Ӄ؁㓢ি2014/8/817A10€B35$C2€D40€E12$һॸֹ਽গ߄Ӄ؁Зࣩ؁ҤݱړܘӦ؁Ҥܘਸ਼؁ҤA10€B35$C2€D40€E12$ABCDE103524012€$€€$Ӧړ؁Ҥ„ӧڔ؂ҥ֨םךރەӑЈЉ஬੽ௌיङফږ„֜О଑य़ӧڔ؂ҥސڔߎ૯ؼঝѷйО࠿▲ӧୃڏॹдফږ„֜Оރ݇֨ӄ؂ӄયՈͫ۱љҿߎ૯ङઘ୼ବچЭࡁૻڽ„ࢃஔдফږՕљਭ঳ӄ؂ॱ୿ͫգޞЭ׍ڠдӊҵۅਈӦړ؁Ҥ2014/8/818ݤܨࣩГ֩؁Ҥ͵Main&Deltaޘݵܴރ݇ளڅԸবͫՁਈգޞளૻӉҴMainMemoryMainDeltaރ݇યՈރ݇ӊҵރ݇௤چԹঢ়ͫયՈۅਈ௤چѩԗӊҵѩԗӉݒҀ„ރ݇ՑӊҵDelta؂ҥԚֿ„Ց߄ܷҴݱҁ੾ՇݒҀ„ޘਈયՈMain؂ҥͫЭਈયՈDelta؂ҥDelta՟ٶ„ڑ࠵ۼ੧„ރ݇Թঢ়஬੽ङރ݇Ҷୂ؂ҥ֨MainMemoryͫ֨࠳ٯયՈޞͫЉ஬੽ઘ୼्द澞֨CommitङޞҘͫѫ܋Logӊҵ्दԸব2014/8/819ҷ՚գव[CHAR50]֩ԙ[CHAR30]Ӣঐ[CHAR5]INTELUSAASiemensEuropeBSiemensEuropeCSAPEuropeASAPEuropeAIBMUSAA0112230INTEL1Siemens2SAP3IBM1000010Europe1USA0120000A1B2Cһॸֹзঢ਽Ӧړ؁Ҥ؀ӀԸবॠࡄ1x“0“2x“1“2x“2“1x“3“0INTEL1Siemens2SAP3IBM1x“1“4x“0“1x“1“0Europe1USA1x“0“1x“1“1x“2“3x“0“0A1B2CӦړ؁ҤࠖେԸবॠࡄ؀ӀԸব޲ӱࠖେԸব޲ӱѸզଞԸব޲ӱПߑNПߑ1ݤܨӢԙ„੮ՕљੴӣԚͫٷЌՕљੴӣ٢ӱךՖ঩৏Ї„ֺٚ੮ͫՕљੴ૧ߑ֘ङٷ੧ԗ„ӣ٢ڔۼ੧2014/8/820уռуռঐச৸10ARed20BBlue30AGreen40ARed50CRed60ARedуռуռঐச৸10ARed30AGreen40ARed60ARedуռуռঐச৸20BBlue50CRedSELECT*FROMtableWHEREcolor=‘Red’SELECT*FROMtableWHEREgroup=‘A’ٶਸ਼Ԗ„ٷՇऀۯ„߲તИङٷՇݱҁ„ރ݇ӣԚͫ֨ࣞॹؘ۪҆ৱத৩࣪׋„ԥ▲߲તИङࡊٵ۪ৱָफӦӣ„ثйځऀڐՇৱީ؏Ҷଥޢङ2014/8/821߾1߾2ColA10000326786786823458986757234123212342343454544711ProcessedbyColB454576634726443534341252234609878787ProcessedbyColC25002178675343243289089562356366536456743452351343414331233562356߾3߾4ProcessedbyProcessedbyسৼSAPHANAރ݇ڏࠥ2014/8/822ڀ࣐ڏՆ:બભSQL„Ғێֺࠥ,ઋ঑ֺࠥ„SQLScript„֌Џӡރڀ„௄ࡹӡރڀ„…2014/8/823ڐՇٵՖڏࠥٵՖ঒ࣲडݏ޾ךԅਈSAPHANAStudio֢ڤԖڎࠆ:Оݤܨੑ֢2014/8/824ProductIDSizeColor1000114BlackProductIDLanguageDescription10001ENLaptop10001ZH➙ઓᮏProductIDSizeColorDescription1000114BlackLaptop֢ڤԖڎࠆ͵יঢࠆֹ2014/8/825SalesOrderCustomerProductIDSalesQty…SalesDateSalesAmtFactTable20010101DataFoundationDateWeekMonthYearProductIDSizeColorDescription1000114BlackLaptopޅֹগ߄StarSchemaਗ਼ॠੑ֢:֢ڤԖڎࠆ&঩ऑ㕭Քј͵„֣ڥԗङރ݇ࡶڏࠥ:UNION澝ৼՠ澝܎ڧ澝Joinঈ„৚ुߣଭମ૾ࡶ͹SQLScript澝SQL澝CallProcedure澝Built-InFunctions澝Variablesঈ2014/8/826֣ڥԗङރ݇ࡶڏࠥ৚ुߣଭମ૾ࡶݤܨ޴ୡܰӱ„ݏӲރ݇঴Ӱङߓஒ2014/8/827سৼSAPHANA௄ࡹٵՖ2014/8/828R͵ޣࡗਸ਼ࣩݤܨ㞀㟮ٖҿ2014/8/829֋ЎӠݤٿ(BFL)ոஓ࡚Ӣ߅ॠࡄٿ(PAL)2014/8/830ݤܨ㞀㟮ॠࡄK-meansৼঝABCӣঝҼ৻ӣߤ(૆࣒下ӣߤ)Ԇߓછӣ੮ஓ࡚ॠࡄׂ֜঑ࡣ֛ڡӣߤC4.5Ӑঌ߹Lӡރڀ(C++)SQLScript„ӯऀсޣރ݇ߛӣߤबҼۅ„֎େ&ㆲ٢҅ऀࠄ҆੠सރ؁