sap_如何將sap內(nèi)存計(jì)算應(yīng)用(sap hana)集成到你的系統(tǒng)布局中

1、,,Matt Kangas/CSA AmericasHong Gun Cho/CSA TechnologyDennis Schwerer/CSA TechnologySeptember, 2011,TEC104如何將SAP內(nèi)存計(jì)算應(yīng)用(SAP HANA)集成到你的系統(tǒng)布局中,Disclaimer,This presentation outlines our general product direction and should

2、 not be relied on in making a purchase decision. This presentation is not subject to your license agreement or any other agreement with SAP. SAP has no obligation to pursue any course of business outlined in this present

3、ation or to develop or release any functionality mentioned in this presentation. This presentation and SAP's strategy and possible future developments are subject to change and may be changed by SAP at any time for a

4、ny reason without notice. This document is provided without a warranty of any kind, either express or implied, including but not limited to, the implied warranties of merchantability, fitness for a particular purpose, o

5、r non-infringement. SAP assumes no responsibility for errors or omissions in this document, except if such damages were caused by SAP intentionally or grossly negligent.,日程,什么是SAP HANA?SAP HANA – 體系結(jié)構(gòu)與系統(tǒng)環(huán)境概覽數(shù)據(jù)抽取數(shù)據(jù)加載的選

6、項(xiàng)使用SLT進(jìn)行數(shù)據(jù)抽取系統(tǒng)擴(kuò)展規(guī)模選型SAP HANA系統(tǒng)環(huán)境簡(jiǎn)化推薦使用的方法,什么是SAP HANA?,,什么是SAP HANA?,,更加便宜的硬件與技術(shù)創(chuàng)新相結(jié)合，使SAP有能力在具有內(nèi)存計(jì)算業(yè)務(wù)應(yīng)用的實(shí)時(shí)企業(yè)環(huán)境規(guī)劃下發(fā)布產(chǎn)品,什么是SAP HANA?,SAP HANA預(yù)打包的解決方案，以預(yù)安裝和定義的形式向客戶發(fā)布內(nèi)嵌工具，管理生命周期、安全優(yōu)化與日常運(yùn)營(yíng)為持續(xù)運(yùn)營(yíng)提供其必需的任務(wù)、概念與過程的最佳實(shí)踐,S

7、AP HANA 將軟件與硬件結(jié)合起來,內(nèi)存計(jì)算引擎（軟件）,預(yù)先安裝好的系統(tǒng)（硬件）,+,SAP HANA – “Appliance”的含義,時(shí)間價(jià)值（便于安裝）,降低總擁有成本（便于維護(hù)）,SAP HANA - “Appliance”的含義,傳統(tǒng)軟件發(fā)布方式：on-premise解決方案SAP僅提供軟件客戶負(fù)責(zé)管理整個(gè)產(chǎn)品生命周期,Appliance的發(fā)布一種“SaaS式的正規(guī)客戶”SAP定義整體解決方案SAP與合作伙

8、伴管理產(chǎn)品生命周期,Appliance運(yùn)營(yíng)概念,基礎(chǔ)設(shè)施*,運(yùn)營(yíng)*,安裝/咨詢,支持（軟件、維護(hù)、基礎(chǔ)設(shè)施）,SAP 軟件開發(fā),軟件與許可證,硬件與技術(shù)合作伙伴,SAP托管與云計(jì)算的發(fā)布,基礎(chǔ)設(shè)施,運(yùn)營(yíng),安裝/咨詢,支持（軟件、維護(hù)、基礎(chǔ)設(shè)施）,SAP軟件開發(fā),軟件與許可證,,,,* 可以外包或由客戶所擁有,,SAP的職責(zé),客戶的職責(zé),,合作伙伴的職責(zé),SAP HANA-體系結(jié)構(gòu)與系統(tǒng)環(huán)境概覽,體系結(jié)構(gòu)概覽SAP HANA Appli

9、ance與周邊環(huán)境,,,SAPHost Agent,Sybase Replication Server,SAP HANAstudio,SAP HANA appliance,SAP HANA Load Controller,SAP HANA構(gòu)件體系結(jié)構(gòu),SAP HANA 1.0 SPS 02SAP HANA databaseSAP HANA database clientsSAP HANA studio (P2 reposito

10、ry)Sybase Replication ServerSAP HANA Load ControllerSAP Host AgentLM Structure filesSAPCAROS configuration & usersSL Toolset 1.0 SPS 02Software Update Manager for SAP HANASAP JVM,LM Structure files,SAP HANA

11、database clients,SAPCAR,SAP HANAdatabase,SLES 11 SP1,硬件廠商特定的服務(wù)器管理工具,存儲(chǔ)子系統(tǒng),,SAP SW Update Manager (SUM) for SAP HANA,SL Toolset 1.0,SAP JVM,從部署的角度看The SAP HANA appliance軟件經(jīng)過適當(dāng)定義與驗(yàn)證的硬件和軟件庫(kù),,數(shù)據(jù)源,SAP ERP System,SAP ERP

12、SAP Host Agent 7.20 Sybase Replication Agent (HP UNIX, SLES, AIX),SAP BW System,Non – SAP System,SAP HANA系統(tǒng)環(huán)境,DB Server,SAP HANA 1.0,SAP HANA,JDBC,ODBC,ODBO,SQL DBC,SAP In-Memory Database,Replication Server,SAP HANA

13、 Studio,SAP Business Application,Replication Agent,,SAP BusinessObjects Data Services 4.0,,任意數(shù)據(jù)源,SAP BusinessObjects BI 4.0,,Repository,SAP BusinessObjects BI clients,SQL,MDX,BICS,AuthenticationContent mgmt,sync,管理與模型

14、控制,load,(可選的),(可選的),(可選的),(現(xiàn)存系統(tǒng)),Studio,SLT,數(shù)據(jù)抽取,數(shù)據(jù)加載的可選方案,SAP HANA數(shù)據(jù)復(fù)制技術(shù),加載數(shù)據(jù)的可選方式,Load Controller & Sybase Replication Server (基于數(shù)據(jù)庫(kù)日志的復(fù)制)SAP LT Replication (基于觸發(fā)器的復(fù)制)Data Services 4.0 (基于ETL的復(fù)制)R3load (非正式 – 用于

15、概念驗(yàn)證)主安裝中，為全面導(dǎo)出數(shù)據(jù)而進(jìn)行的系統(tǒng)復(fù)制Python importManager.py & exportManager.py從SAP HANA導(dǎo)出向SAP HANA導(dǎo)入SQL語(yǔ)句:使用SQL語(yǔ)句創(chuàng)建MARA表(難以手工完成)LOAD from '//HANA/HN1_COPA_TABLES/MARA.ctl‘ THREADS 4 BATCH 100;,從SAP ERP表向SAP HANA復(fù)制,參考

16、SAP note # 1513496 以獲取關(guān)于這些限制的最新信息,截至2011年7月的計(jì)劃,許可證限制仍可能存在,支持能力矩陣 參考SAP Note 1513496來獲取最新的正式發(fā)布的限制,數(shù)據(jù)抽取,使用SLT進(jìn)行數(shù)據(jù)抽取,LT Replication的概念:基于觸發(fā)器方式的體系結(jié)構(gòu)與關(guān)鍵構(gòu)件,SAP HANA system,,LT system (NW7.02),,應(yīng)用程序數(shù)據(jù)庫(kù)表,源系統(tǒng),,Write Modules,Co

17、ntroler Modules,數(shù)據(jù)庫(kù)連接,RFC連接,Read Modules,,LoggingTables,,應(yīng)用程序數(shù)據(jù)庫(kù)表,DB Trigger,高效率的數(shù)據(jù)初始復(fù)制，基于數(shù)據(jù)庫(kù)觸發(fā)器的和增量日志概念 （接近零關(guān)機(jī)時(shí)間）,靈活可靠的數(shù)據(jù)復(fù)制流程，包括數(shù)據(jù)遷移（為TDMS和SAP LT所使用）,通過數(shù)據(jù)庫(kù)連接進(jìn)行數(shù)據(jù)復(fù)制（無其他交互）,,,,LT replicator不必作為單獨(dú)的SAP系統(tǒng)部署，可以運(yùn)行在任何版本為7.02 A

18、BAP stack (Kernel 7.20EXT) 的SAP NetWeaver 上,LT Replicator 的技術(shù)要求和系統(tǒng)設(shè)置,SAP HANA系統(tǒng),,LT系統(tǒng)(NW7.02),,源系統(tǒng),,,,系統(tǒng)需求:- SAP Basis: Netweaver 702，Kernel 7.20EXT （目前有限的平臺(tái)可用性） - 文件系統(tǒng)：100 GB- RAM: 16-32 GB CPU: 2-4核,數(shù)據(jù)庫(kù)連接,RFC連接,

19、系統(tǒng)需求 SAP Basis 4.6C或更高 所有數(shù)據(jù)庫(kù),安裝： 各DMIS 2010版本 最低支持包水平：最近可用,安裝： Add-on DMIS 2010_1_700 最低支持包水平： SP04 (與SAP HANA 1.0 GA同步發(fā)布)*,I安裝： SAP HANA SPS02：包括LT復(fù)制功能完全集成到HANA Modeler的用戶界面,基本配置： 定義到源系統(tǒng)的RFC連接- 定義到HANA系統(tǒng)的數(shù)據(jù)庫(kù)連

20、接- 定義數(shù)據(jù)復(fù)制所需的最大作業(yè)數(shù),基本配置： 可選：為日志表定義分離的表空間 為RFC用戶定義適當(dāng)?shù)氖跈?quán),基本配置：- 創(chuàng)建數(shù)據(jù)庫(kù)用戶（如果需要）,,LT replicator的實(shí)例可以運(yùn)行在任意SAP NetWeaver 7.02 ABAP 系統(tǒng)（使用SAP Kernel 7.20EXT）上，例如Solution Manager 7.1，源系統(tǒng)甚至HANA服務(wù)器（需要安裝SAP NetWeaver 7.02 ABAP Sta

21、ck作為 LT Replicator的基礎(chǔ)）-它不必是一個(gè)獨(dú)立的SAP系統(tǒng)！,系統(tǒng)擴(kuò)展,,分布式系統(tǒng),使用共享文件系統(tǒng)的多節(jié)點(diǎn)，以進(jìn)行負(fù)載分配,SAP HANA分布式系統(tǒng),,,源系統(tǒng),SAP HANA數(shù)據(jù)庫(kù),存儲(chǔ)系統(tǒng),節(jié)點(diǎn)4,節(jié)點(diǎn)1,節(jié)點(diǎn)2,節(jié)點(diǎn)3,高可用性特點(diǎn),情境單一數(shù)據(jù)中心失效（由于火災(zāi)，斷電，地震等）單一節(jié)點(diǎn)失效（硬件故障）概念冗余數(shù)據(jù)中心（包括冗余SAP HANA系統(tǒng)）-熱待命同步鏡像單一SAP HABA數(shù)據(jù)庫(kù)系統(tǒng)

22、環(huán)境內(nèi)的待命系統(tǒng)-冷待命失效恢復(fù)被自動(dòng)觸發(fā),2個(gè)獨(dú)立的系統(tǒng)環(huán)境,抗災(zāi)難能力冗余硬件,數(shù)據(jù)中心1,數(shù)據(jù)中心2,,,,,,,源系統(tǒng),源系統(tǒng),SAP HANA數(shù)據(jù)庫(kù),SAP HANA數(shù)據(jù)庫(kù),存儲(chǔ)系統(tǒng),節(jié)點(diǎn)4,節(jié)點(diǎn)1,節(jié)點(diǎn)2,節(jié)點(diǎn)3,節(jié)點(diǎn)4,節(jié)點(diǎn)1,節(jié)點(diǎn)2,存儲(chǔ)系統(tǒng),節(jié)點(diǎn)3,,切換,鏡像操作,,鏡像操作,代理,失效恢復(fù)節(jié)點(diǎn),冷待命（Cold Standby）節(jié)點(diǎn)將替代失效節(jié)點(diǎn),HANA分布式待命系統(tǒng),,,源系統(tǒng),SAP HANA數(shù)據(jù)庫(kù),存儲(chǔ)

23、系統(tǒng),節(jié)點(diǎn)4,節(jié)點(diǎn)1,節(jié)點(diǎn)2,節(jié)點(diǎn)3,待命節(jié)點(diǎn),,規(guī)模選型,,DISCLAIMER,Sizing recommendations apply for certified hardware only. Please contact hardware vendor for suitable hardware configuration.Note that SAP HANA is constantly being optimized. T

24、his might have impact on sizing recommendations, which will be reflected in this document. Therefore, check for the latest version of this document and the note.Note that the sizing guideline in this document refers to

25、 SAP HANA Platform only. Additional applications running on top of SAP HANA (e.g. Business Information Warehouse, etc.) are not covered in this document. Application specific sizing guidelines will be available for these

26、 cases soon.,經(jīng)過認(rèn)證的硬件http://service.sap.com/pam包含最新列表,經(jīng)過認(rèn)證的硬件http://service.sap.com/pam包含最新列表,*Intel Nehalem CPU將被 Intel Westmere CPU代替,SAP HANA平臺(tái)規(guī)模選型：總結(jié),內(nèi)存磁盤CPU,內(nèi)存 = 數(shù)據(jù)源規(guī)模 * 2 / 5,CPU: 每個(gè)活動(dòng)用戶0.2個(gè)CPU內(nèi)核,磁盤日志 =

27、1 * 內(nèi)存,磁盤存儲(chǔ) = 4 * 內(nèi)存,內(nèi)存大小：靜態(tài)數(shù)據(jù),靜態(tài)數(shù)據(jù)對(duì)內(nèi)存的需求從源數(shù)據(jù)庫(kù)相應(yīng)的表的大小推出必須使用數(shù)據(jù)庫(kù)特定的類目信息決定數(shù)據(jù)庫(kù)大?。ㄈ鏞racle數(shù)據(jù)庫(kù)：dba_segments; DB2數(shù)據(jù)庫(kù)：syscat.tables).數(shù)據(jù)庫(kù)特定腳本，以及決定數(shù)據(jù)庫(kù)大小的更多細(xì)節(jié)可參見SAP Note 1609322.數(shù)據(jù)庫(kù)表平均壓縮比率：SAP HANA 內(nèi)存 = 5 : 1需注意，這一壓縮比率是參考未壓縮數(shù)據(jù)庫(kù)表

28、得出的，并未包含數(shù)據(jù)庫(kù)索引所占用的空間,內(nèi)存靜態(tài) = 源數(shù)據(jù)大小 / 5,內(nèi)存大?。哼\(yùn)行時(shí)對(duì)象,動(dòng)態(tài)創(chuàng)建的對(duì)象需要更多的內(nèi)存 當(dāng)加載新數(shù)據(jù)時(shí) 當(dāng)執(zhí)行檢索時(shí)我們推薦，為動(dòng)態(tài)對(duì)象保留與靜態(tài)對(duì)象同等大小的內(nèi)存空間：因此，內(nèi)存總量為：,內(nèi)存靜態(tài) = 內(nèi)存動(dòng)態(tài),內(nèi)存 =內(nèi)存靜態(tài) +內(nèi)存動(dòng)態(tài) =源數(shù)據(jù)規(guī)模* 2 / 5,磁盤大小,持久層所需磁盤大小：上述磁盤空間不包括備份的需求。日志文件/操作性磁盤空間所需的

29、磁盤大?。?磁盤日志 = 1 * 內(nèi)存,磁盤持久 = 4 * 內(nèi)存,CPU規(guī)模選型,規(guī)模選型的方法類似于為BW和BWA進(jìn)行的基于用戶的CPU規(guī)模選型通過多用戶情境最大化查詢吞吐量（10-20M條），這些情境帶有復(fù)雜度不等的查詢，來自所發(fā)布的內(nèi)容假定：- 三個(gè)不同的查詢復(fù)雜度類別- 三類不同的用戶特性（點(diǎn)擊率，查詢復(fù)雜度）- 用戶類別與查詢復(fù)雜度的分布與BW相同查詢吞吐量對(duì)于每核/每核活動(dòng)用戶的正態(tài)化,CPU: 0.2

30、CPU核/用戶,SAP HANA系統(tǒng)環(huán)境,簡(jiǎn)化,企業(yè)數(shù)據(jù)倉(cāng)庫(kù),公司商業(yè)智能,數(shù)據(jù)庫(kù),本地商業(yè)智能,. . .,This presentation outlines our general product direction and should not be relied on in making a purchase decision.,今天的情況,企業(yè)數(shù)據(jù)倉(cāng)庫(kù)(BW),公司商業(yè)智能,數(shù)據(jù)庫(kù),本地商業(yè)智能,SAP ERP 1(或CR

31、M, SRM, SCM),數(shù)據(jù)庫(kù),同步,x,SAP ERP n(或CRM, SRM, SCM),數(shù)據(jù)庫(kù),SAP HANA 1.0,非SAP業(yè)務(wù)應(yīng)用,數(shù)據(jù)庫(kù),SAP HANA 1.0,. . .,BWA,SAP HANA 1.0,This presentation outlines our general product direction and should not be relied on in making a purch

32、ase decision.,階段1–SAP HANA 1.0,普遍可用,企業(yè)數(shù)據(jù)倉(cāng)庫(kù)(BW),公司商業(yè)智能,. . .,SAP HANA (nxt),虛擬數(shù)據(jù)集市,虛擬數(shù)據(jù)集市,虛擬數(shù)據(jù)集市,本地商業(yè)智能,This presentation outlines our general product direction and should not be relied on in making a purchase decision.,正

33、在工作中,階段2–為BW提供主要的持久化,企業(yè)數(shù)據(jù)倉(cāng)庫(kù)(BW),公司商業(yè)智能,. . .,SAP HANA (nxt),虛擬數(shù)據(jù)集市,虛擬數(shù)據(jù)集市,虛擬數(shù)據(jù)集市,本地商業(yè)智能,新應(yīng)用,This presentation outlines our general product direction and should not be relied on in making a purchase decision.,正在工作中,階段3–新應(yīng)

34、用,公司商業(yè)智能,SAP HANA,虛擬數(shù)據(jù)集市,虛擬數(shù)據(jù)集市,虛擬數(shù)據(jù)集市,本地商業(yè)智能,新應(yīng)用,ERP 1,ERP n,EDW (BW),. . .,This presentation outlines our general product direction and should not be relied on in making a purchase decision.,前景,階段4 – 未來的應(yīng)用庫(kù)（前景）,This pr

35、esentation outlines our general product direction and should not be relied on in making a purchase decision.,簡(jiǎn)化,簡(jiǎn)化,This presentation outlines our general product direction and should not be relied on in making a purchase

36、 decision.,SAP HANA系統(tǒng)環(huán)境,推薦,對(duì)系統(tǒng)環(huán)境的考慮BI 4.0 GA和SAP HANA 1.0 SPS02–今天,硬件與許可證 BI 4.0不基于SAP HANA 1.0設(shè)施 它需要額外的硬件和額外的許可證硬件提供商和業(yè)務(wù)伙伴進(jìn)行的安裝和配置 SAP HANA 1.0由硬件提供商和業(yè)務(wù)伙伴準(zhǔn)備和安裝SAP或其他顧問方進(jìn)行的安裝與配置 BI 4.0安裝與配置 SAP HANA 1.0安裝與配置重要：

37、SAP HANA JDBC驅(qū)動(dòng)需要在BI 4.0系統(tǒng)上手動(dòng)復(fù)制和升級(jí),對(duì)系統(tǒng)環(huán)境的考慮BI 4.0 GA和SAP HANA 1.0 SPS02–今天,一個(gè)BI 4 system能夠訪問多個(gè)SAP HANA 1.0系統(tǒng)當(dāng)使用Database Credential映射時(shí)，SAP HANA數(shù)據(jù)庫(kù)的密碼必須跨SAP HANA系統(tǒng)相匹配,對(duì)系統(tǒng)環(huán)境考慮的路線圖明天,BI 4.0安裝于SAP HANA之外的單獨(dú)硬件之上BI 4.0客戶端可以

38、訪問多個(gè)HANA實(shí)例，以進(jìn)行報(bào)表生成,SAP HANA數(shù)據(jù)庫(kù)作為容器和審計(jì)對(duì) BI 4.1 (CMS) 提供支持簡(jiǎn)化系統(tǒng)環(huán)境作為容器，期待其性能與其他數(shù)據(jù)庫(kù)看齊,BI 4.0 GA,,,Planned functionality only. SAP reserves the right to change planning.,,BI 4.1,使用SAP HANA， 快速部署B(yǎng)I 4,未來,This presentation outl

39、ines our general product direction and should not be relied on in making a purchase decision.,,,SAP In-Memory Appliance 1.0 – 基于日志的ERP數(shù)據(jù)復(fù)制三個(gè)系統(tǒng)構(gòu)成的系統(tǒng)環(huán)境 - 例子,,SAP ERP Production,,LoadController,Sybase Replication Server,S

40、ybase Agent,SAP HANA Database,SAP HANA Production,,IMCE Studio,,BI Clients PRD,,,Production,,,通過CTS傳輸,,,導(dǎo)入/導(dǎo)出,SAP HANA Database,SAP HANA Database,,,SAP In-Memory Appliance 1.0 – 基于觸發(fā)器的數(shù)據(jù)復(fù)制三個(gè)系統(tǒng)構(gòu)成的系統(tǒng)環(huán)境 - 例子,,SAP ERP Prod

41、uction,,LoadController,Sybase Replication Server,SAP HANA Database,SAP HANA Production,,IMCE Studio,,BI Clients PRD,,,Production,,SLTPRD,,SLT,SLT,可選：?jiǎn)我坏腟LT服務(wù)于所有非生產(chǎn)系統(tǒng),SAP HANA Database,SAP HANA Database,,,SAP In-Memory A

42、ppliance 1.0 – 基于ETL的ERP數(shù)據(jù)復(fù)制三個(gè)系統(tǒng)構(gòu)成的系統(tǒng)環(huán)境 - 例子,,SAP ERP Production,,LoadController,Sybase Replication Server,SAP HANA Database,SAP HANA Production,,IMCE Studio,,BI Clients PRD,,,Production,,DS4.0PRD,,SAP HANA Database,S

43、AP HANA Database,更多信息,,SAP 網(wǎng)頁(yè):Service Marketplace (SMP): service.sap.com/solutionmanagerSAP Developer Network (SDN): www.sdn.sap.com/irj/sdn/alm,,相關(guān)的SAP 培訓(xùn)和認(rèn)證信息service.sap.com/solutionmanager=> Services => Exp

44、ert Guided Implementation,,其他相關(guān)Tech材料SAP Solution Manager 7.1www.sap-press.de,附錄,SAP HANA 體系結(jié)構(gòu),體系結(jié)構(gòu)概況引擎自身,體系結(jié)構(gòu)概況向SAP HANA加載數(shù)據(jù),體系結(jié)構(gòu)概況數(shù)據(jù)建模,體系結(jié)構(gòu)概況報(bào)表生成,,體系結(jié)構(gòu)概況管理,SAP HANA Appliance的“T恤衫”大小 規(guī)范與大致的數(shù)據(jù)規(guī)模,Starts at S and