創(chuàng)新的數(shù)據(jù)庫技術 Oracle Database 12c

1、Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted1創(chuàng)新的數(shù)據(jù)庫技術創(chuàng)新的數(shù)據(jù)庫技術Oracle Database 12c 齊琨()資深解決方案咨詢顧問Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted2Safe Harbor StatementThe following is inte

2、nded to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions.The development, release, a

3、nd timing of any features or functionality described for Oracles products remain at the sole discretion of Oracle.Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted3日程日程介紹Oracle Database 12c創(chuàng)新助力合作伙伴與合作伙伴一同創(chuàng)新Copyright 2013, Oracle and/or its affili

4、ates. All rights reserved.Oracle Confidential Highly Restricted4介紹介紹Oracle Database 12cCopyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted5Oracle歷年持續(xù)創(chuàng)新歷年持續(xù)創(chuàng)新Self-Service ProvisioningMetering and ChargebackConsolidation PlanningApplication Continuit

5、yMultitenant DatabaseCopyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted6今天的私有數(shù)據(jù)庫架構(gòu)今天的私有數(shù)據(jù)庫架構(gòu)使用Oracle Database 11g集群共享服務器和OS虛擬機共享服務器Schema整合共享服務器、OS和數(shù)據(jù)庫Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Res

6、tricted7傳統(tǒng)的非傳統(tǒng)的非CDB架構(gòu)架構(gòu)每個數(shù)據(jù)庫需要獨立的內(nèi)存和進程ERP數(shù)據(jù)數(shù)據(jù)庫庫文件文件內(nèi)存使用內(nèi)存使用后臺后臺進進程程CRM數(shù)據(jù)數(shù)據(jù)庫庫文件文件后臺后臺進進程程內(nèi)存使用內(nèi)存使用DW數(shù)據(jù)數(shù)據(jù)庫庫文件文件后臺后臺進進程程內(nèi)存使用內(nèi)存使用Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted8全新全新 DB12c 多租期數(shù)據(jù)庫架構(gòu)多租期數(shù)據(jù)庫架構(gòu)內(nèi)存和進程僅在容器級使用ERPCRMDW后臺進程后臺進程內(nèi)存使用內(nèi)存使用容器數(shù)據(jù)庫容器數(shù)據(jù)

7、庫CDBCopyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted9全新全新 DB12c 私有數(shù)據(jù)庫架構(gòu)私有數(shù)據(jù)庫架構(gòu)專用數(shù)據(jù)庫共享服務器和操作系統(tǒng)虛擬機共享服務器多租期數(shù)據(jù)庫共享服務器、OS和數(shù)據(jù)庫整合度提高整合度提高使用 Oracle Database 12cCopyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly R

8、estricted10架構(gòu)對比架構(gòu)對比業(yè)務價值業(yè)務價值虛擬機虛擬機專用專用多租期多租期實施容易容易容易適用的應用范圍一些場景所有場景所有場景隔離程度最高高高可用性高最高最高擴展性受限優(yōu)秀優(yōu)秀性能受限全部全部整合密度低高最高ROI投資回報率投資回報率低低高高最高最高Oracle 多租期: 最好的整合度, 最大的ROICopyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted11Database 12c中的新特性中的新特性提供的價提供的價值值新特性新特

9、性/功能功能適用適用場場景景管理新的數(shù)據(jù)源數(shù)據(jù)庫內(nèi)部Map Reduce / 模式匹配大數(shù)據(jù)和分析存儲優(yōu)化處理爆發(fā)性數(shù)據(jù)熱圖,自動數(shù)據(jù)優(yōu)化 (ADO) 確保業(yè)務持續(xù)性應用持續(xù),遠程同步,全局數(shù)據(jù)服務高可用性阻止數(shù)據(jù)泄漏數(shù)據(jù)遮蔽,權(quán)限分析,數(shù)據(jù)掩碼數(shù)據(jù)安全提高操作效率整合重放, DaaS, 快照克隆管理性更低的成本和靈活的收益多租期選件數(shù)據(jù)整合/私有云Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted12數(shù)據(jù)庫整合和數(shù)據(jù)庫云服數(shù)據(jù)庫整合和數(shù)據(jù)

10、庫云服務務DBaaSv與您一同創(chuàng)新與您一同創(chuàng)新 #1Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted13新特性新特性? 真正的數(shù)據(jù)庫虛擬化 下一代數(shù)據(jù)庫 整合和云的最佳平臺數(shù)據(jù)庫選件數(shù)據(jù)庫選件: Oracle多租期(全新) 業(yè)務機會業(yè)務機會: 數(shù)據(jù)庫整合 Database-as-a-Service 企業(yè)云的主動提供客戶收益客戶收益: 每個服務器支持更多的應用 更少的硬件需求 更大的靈活性 易于管理DW數(shù)據(jù)庫整合和數(shù)據(jù)庫整合和DBaaSCo

11、pyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted14操作系統(tǒng)級服務器池(server pool)數(shù)據(jù)庫級Schema ERPDWCRM PDB PDB PDBCCOAHCMOSOSOSOSPDBSchemaSchemaSchemaSchemaSchemaOracle Database CloudOracle 數(shù)據(jù)庫云架構(gòu) 12c可插拔、多租戶架構(gòu) CDB SchemaSchemaSchemaSchema數(shù)據(jù)庫級虛擬化Pluggable Dat

12、abaseCopyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted15多租戶-可插拔數(shù)據(jù)庫創(chuàng)建可插拔數(shù)據(jù)庫RootEmptyERPEmptyDWEmptyCRMPDB SEED 可以快速為每個需整合的數(shù)據(jù)庫創(chuàng)建一個空PDBCopyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted16SQL SET T

13、IMING ONSQL create pluggable database c01p01p2 admin user app_Admin identified by pwd3 file_name_convert = (/pdbseed/, /c01p01p/)4 /Pluggable database created.Elapsed: 00:00:57.11SQL alter pluggable database c01p01p open;Pluggable database altered.SQL alter pluggable database all open;Pluggable data

14、base altered.多租戶-可插拔數(shù)據(jù)庫 創(chuàng)建Pluggable Database舉例Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted17SQL alter pluggable database c01p01p close;Pluggable database altered.SQL drop pluggable database c01p01p including datafiles;Pluggable database drop

15、ped.多租戶-可插拔數(shù)據(jù)庫 刪除Pluggable Database舉例Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted18多租戶-可插拔數(shù)據(jù)庫Fast Cloning和SnapshotsRootERPPDB COPY1 PDB SEED 在單個容器數(shù)據(jù)庫(CDB)內(nèi)克隆PDB非常簡單 在克隆PDB過程中擦除或掩蓋數(shù)據(jù)非常容易 克隆PDB過程甚至快于文件系統(tǒng)拷貝ERPPDB COPY2 ERP PDBCopyright 2013, Or

16、acle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted19SQL alter pluggable database C01P01P close ;Pluggable database altered.SQL alter pluggable database C01P01P open read only ;Pluggable database altered.SQL SET TIMING ONSQL create pluggable database C01P02P2 from C

17、01P01P3 file_name_convert = (/c01p01p, /c01p02p)4 /Pluggable database created.Elapsed: 00:00:31.90SQL alter pluggable database C01P02P open ;多租戶-可插拔數(shù)據(jù)庫Fast Cloning舉例Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted20大數(shù)據(jù)大數(shù)據(jù), 數(shù)據(jù)倉庫數(shù)據(jù)倉庫, 分析分析v與您一同創(chuàng)新與

18、您一同創(chuàng)新 #2Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted21新特性新特性? 數(shù)據(jù)庫內(nèi)的MapReduce能力 Java 和SQL 接口 行級模式匹配 R 統(tǒng)計分析數(shù)據(jù)庫選件和產(chǎn)品數(shù)據(jù)庫選件和產(chǎn)品: 高級分析 Oracle NoSQL Oracle Big Data Appliance業(yè)務機會業(yè)務機會: 客戶細分 客戶業(yè)務增長 威脅檢測 語義分析 客戶收益客戶收益: 從數(shù)據(jù)獲取業(yè)務價值 預測 (更好的計劃)大數(shù)據(jù)大數(shù)據(jù), 數(shù)據(jù)倉庫和

19、分析數(shù)據(jù)倉庫和分析191319日股票價格數(shù)據(jù)存儲數(shù)據(jù)存儲表對象視圖外部表ReducerTable ReaderTable WriterOracle JVMMapperTable ReaderTable WriterOracle 數(shù)據(jù)庫數(shù)據(jù)庫SQLSQL 結(jié)果SQL 查詢Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted22高級分析選件的使用場景高級分析選件的使用場景為正確的客戶提供正確的目標發(fā)現(xiàn)隱藏的客戶細分發(fā)現(xiàn)最合適的銷售機會預計客戶的變

20、動360度全方位客戶機會發(fā)現(xiàn)安全和可疑活動檢測理解客戶調(diào)查中的語義減少醫(yī)療差錯 ，改善健康質(zhì)量理解社交網(wǎng)絡的影響力Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted23存儲優(yōu)化存儲優(yōu)化v與您一同創(chuàng)新與您一同創(chuàng)新 #3Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted24新特性新特性? 數(shù)

21、據(jù)訪問跟蹤 自動化, 基于策略的壓縮和數(shù)據(jù)分層數(shù)據(jù)庫選件數(shù)據(jù)庫選件: 高級壓縮業(yè)務機會業(yè)務機會: 大型數(shù)據(jù)庫 數(shù)據(jù)增長帶來的成本,性能等存儲問題 存儲分層 客戶收益客戶收益: 高效管理增長的數(shù)據(jù) 實時和交互處理數(shù)據(jù)存儲優(yōu)化存儲優(yōu)化活動數(shù)據(jù)活動數(shù)據(jù)頻繁訪問數(shù)據(jù)頻繁訪問數(shù)據(jù)偶爾訪問偶爾訪問休眠數(shù)據(jù)休眠數(shù)據(jù)ORDERSCopyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted25Oracle 存存儲儲廠商廠商磁磁盤節(jié)盤節(jié)省省大量大量節(jié)節(jié)省省部分部分性能性

22、能加速加速查詢查詢增加支出增加支出數(shù)據(jù)數(shù)據(jù)庫庫集成集成深度集成深度集成排除排除維護維護任任務務包括內(nèi)存包括內(nèi)存訪問訪問集成集成RMAN 和和Active DataGuard零集成零集成維護維護任任務務要考要考慮慮數(shù)據(jù)的數(shù)據(jù)的實時訪問實時訪問自動數(shù)據(jù)優(yōu)化的優(yōu)勢Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted26信息生命周期管理命令舉例ALTER TABLE sales_ado ILM ADD POLICY ROW STORE COMPRES

23、S ADVANCED ROW AFTER 30 DAYS OF NO MODIFICATION;ALTER TABLE salesILM ADD Move PolicyTIER Partitions TO Archive_TBSON OrdersClosedPolicy;Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted27高可用性和數(shù)據(jù)保護高可用性和數(shù)據(jù)保護v與您一同創(chuàng)新與您一同創(chuàng)新 #4Copyright 2013, Oracle an

24、d/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted28PrimaryStandbyASYNCSYNCFar sync standby遠距離Data guard保證零數(shù)據(jù)丟失 Far Sync Standby 當Standby距離很遠，可以在Primary本地啟用輕量級redo復制 同樣將redo壓縮和redo多地址服務傳輸壓力卸載到本地 透明Switch over和FailoverCopyright 2013, Oracle and/or its affiliates. All right

25、s reserved.Oracle Confidential Highly Restricted29新特性新特性? 遠程standby數(shù)據(jù)庫0數(shù)據(jù)丟失 負載均衡 復制DB的Failover數(shù)據(jù)庫選件數(shù)據(jù)庫選件: Active Data Guard GoldenGate業(yè)務機會業(yè)務機會: 關鍵任務應用 客戶分布在全球 數(shù)據(jù)中心分布在全球 MAA擴展客戶收益客戶收益: 業(yè)務持續(xù)性 數(shù)據(jù)保護 高可用和數(shù)據(jù)保護高可用和數(shù)據(jù)保護PrimaryFar SyncInstance(Active)Far SyncInstance(Idle)syncasyncGlobal Data ServicesCopyrig

26、ht 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted30需求需求Oracle MAA其他其他數(shù)據(jù)丟失0數(shù)據(jù)丟失 Data Guard有限的0數(shù)據(jù)丟失(例如，同步鏡像，有限保護)恢復時間秒級 RAC, Data Guard, GoldenGate小時級成本 (ROI)不需要額外空閑冗余設備 RAC, Data Guard, Golden Gate空閑冗余總結(jié)總結(jié)高可用性和數(shù)據(jù)保護Copyright 2013, Oracle and/or its affili

27、ates. All rights reserved.Oracle Confidential Highly Restricted31數(shù)據(jù)安全數(shù)據(jù)安全v與您一同創(chuàng)新與您一同創(chuàng)新 #5Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted32新特性新特性? 動態(tài)遮蔽數(shù)據(jù) 敏感數(shù)據(jù)發(fā)現(xiàn) 為測試系統(tǒng)提供安全 數(shù)據(jù)庫選件數(shù)據(jù)庫選件: Data Masking Advanced Security業(yè)務機會業(yè)務機會: 呼叫中心 決策支持 PII, PHI, PC

28、I Data客戶收益客戶收益: 符合法律合規(guī)性要求 阻止數(shù)據(jù)威脅和濫用 移動數(shù)據(jù)上提供數(shù)據(jù)安全數(shù)據(jù)安全數(shù)據(jù)安全Soc. Sec. #115-69-3428DOB11/06/71PIN5623敏感數(shù)據(jù)遮蔽敏感數(shù)據(jù)遮蔽策略策略Call Center OperatorPayroll ProcessingCopyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted33數(shù)據(jù)掩碼數(shù)據(jù)掩碼在源端進行掩碼最小化敏感數(shù)據(jù)導出測試系統(tǒng)安全化010010110010101

29、001001001001001001001001001001000100101010010010010011100100100100100100100001001001011100100101010010010101010011010100101010010數(shù)據(jù)泵文件進行子集和掩碼12.1生產(chǎn)測試在源端掩碼首先在生產(chǎn)段數(shù)據(jù)進行子集操作單獨對敏感數(shù)據(jù)進行掩碼0100101100101010010010010010010010010010010010001001010100100100100111001001001001001001000010010010111001001010100100101

30、01010011010100101010010生產(chǎn)數(shù)據(jù)子集克隆和掩碼11.2測試Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted34數(shù)據(jù)庫管理數(shù)據(jù)庫管理v與您一同創(chuàng)新與您一同創(chuàng)新 #6Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted35新特性新特性? 云管理 主動性能管理 數(shù)據(jù)庫整合

31、管理 數(shù)據(jù)庫選件數(shù)據(jù)庫選件: Enterprise Manager 12c Real Application Testing 業(yè)務機會業(yè)務機會: 數(shù)據(jù)庫整合 Database-as-a-Service 云管理, 自服務, 收費 大量數(shù)據(jù)庫的管理客戶收益客戶收益: 用更少的成本更高效的管理IT基礎設施數(shù)據(jù)庫管理數(shù)據(jù)庫管理SALESHRERPCRMCopyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted36數(shù)據(jù)庫管理數(shù)據(jù)庫管理跨數(shù)據(jù)庫生命周期的全面管

32、理跨數(shù)據(jù)庫生命周期的全面管理規(guī)規(guī)劃劃DatabaseConsolidation 測試測試優(yōu)優(yōu)化化遷移遷移整合規(guī)劃/建議實時整合測試Oracle多租期Container DB & Pluggable DB 性能優(yōu)化Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted37Exadata 技術創(chuàng)新技術創(chuàng)新 齊琨()資深解決方案咨詢顧問Copyright 2013, Oracle and/or its affiliates. All rights r

33、eserved.Oracle Confidential Highly Restricted38Exadata用于用于一臺機器可適用于一臺機器可適用于 數(shù)據(jù)倉庫 OLTP 數(shù)據(jù)庫云Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted39Exadata 架構(gòu)架構(gòu)可伸縮的數(shù)據(jù)庫服務器可伸縮的數(shù)據(jù)庫服務器 8x 2-socket, 或 2x 8-socket Xeon database servers Oracle Database, ASM, RA

34、C; Linux 或 Solaris 標準以太網(wǎng)接口可伸縮的智能存儲服務器可伸縮的智能存儲服務器 2-socket 存儲服務器, Exadata Storage Software Up to 672 terabytes disk per rack 56 PCI Flash memory cards per rackInfiniBand網(wǎng)絡網(wǎng)絡 Unified internal connectivity ( 40 Gb/sec )Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidentia

35、l Highly Restricted40預構(gòu)建系統(tǒng)與傳統(tǒng)系統(tǒng)的差別預構(gòu)建系統(tǒng)與傳統(tǒng)系統(tǒng)的差別性能目標性能目標性能目標性能目標時間 (以天計)時間 (以月計)100%度量、診斷調(diào)優(yōu)和重新配置測試和調(diào)試出問題的部分組裝一堆組件多供應商客戶配置Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted41Exadata 工程化系工程化系統(tǒng)統(tǒng)在優(yōu)化系統(tǒng)方面花費了幾百人年幫助IT人員著重解決業(yè)務需要標準平臺改善支持體驗運行所有運行所有現(xiàn)現(xiàn)有的有的Oracl

36、e數(shù)據(jù)數(shù)據(jù)庫庫工作工作構(gòu)建Oracle云更低風險, 更佳收益Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted42擴展性支持業(yè)務發(fā)展擴展性支持業(yè)務發(fā)展可升級統(tǒng)統(tǒng)一的架構(gòu)使得性能更快，成本更低一的架構(gòu)使得性能更快，成本更低配配滿配滿配配配1/8配配Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restri

37、cted43擴展超過擴展超過18個機柜個機柜全帶寬和冗余用內(nèi)部線纜和交換機擴展到用內(nèi)部線纜和交換機擴展到18個機柜個機柜用外部交換機和線纜擴展超過用外部交換機和線纜擴展超過18個機柜個機柜Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted44Exadata X3-2 1/8配配更低的成本更低的成本16 Database Cores, 54 TB Disk, 2.4 TB PCI Flash具備所有Exadata的高可用性配置讓更多業(yè)務可以使

38、用讓更多業(yè)務可以使用Exadata硬件上與硬件上與1/4配的區(qū)別配的區(qū)別 禁用一半 CPU Cores, Disks, 和 Flash Cards一半Database和Exadata Software Licenses只需要軟件命令即可以升級成只需要軟件命令即可以升級成1/4配配快于2010 配, 2008 配更低的更低的成本成本Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted45無縫升級和擴展無縫升級和擴展一個數(shù)據(jù)庫服務器可以有不同代的

39、服務一個數(shù)據(jù)庫服務器可以有不同代的服務器器數(shù)據(jù)庫和集群可以分布到多帶產(chǎn)品上數(shù)據(jù)庫和集群可以分布到多帶產(chǎn)品上新的軟件可以運行在舊的硬件上新的軟件可以運行在舊的硬件上X2-2 2011年部署1/4配X3-2 2013年1/4配到半配X4-2 2014年1/2配到滿配升級樣例Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted46硬件演進硬件演進V1V2X2X3 2008200920102012Storage (TB)4X3365045041686

40、72Flash (TB)5.35.322.48X 044.83XCPU (Cores)649612864192Memory (GB)16X576115220482564096Connectivity (Gb/s)50X24241844004008 8800X4 2013Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted47Exadata硬件情況硬件情況X3-8 FullX4-2 FullX4-2 Half X4-2 QuarterX4-2

41、Eighth2842216019296482440962048 (max 4096)1024 (max 2048)512 (max 1024)512 (max 1024)2222211111141473316816884361844.8 TB44.8 TB22.4 TB9.6 TB4.8 TB200 TB200 TB100 TB43.2 TB21.6 TB672 TB672 TB336 TB144 TB72 TB90 TB90 TB45 TB19 TB9 TB300 TB300 TB150 TB63 TB30 TB60 TB60 TB30 TB13 TB6.3 TB200 TB200 TB10

42、0 TB43 TB21.5 TBCopyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted48X4-2 SQL IO性能性能X4-2Full RackX4-2 Half RackX4-2Quarter X4-2 EighthFlash CacheSQL Bandwidth1,3High Cap Disk100 GB/s50 GB/s21.5 GB/s10.7 GB/sHigh Perf Disk100 GB/s 50 GB/s21.5 GB/s10

43、.7 GB/sFlash SQL IOPS2,38K Reads2,660,0001,330,000570,000285,0008K Writes1,680,000840,000360,000180,000Disk SQL Bandwidth1,3High Cap Disk20 GB/s10 GB/s4.5 G/s2.25 GB/sHigh Perf Disk24 GB/s12 GB/s5.2 GB/s2.6 GB/sDisk SQL IOPSHigh Cap Disk32,00016,0007,0003,500High Perf Disk50,00025,00010,8005,400Data

44、 Load Rate420 TB/hr10 TB/hr5 TB/hr2.5 TB/hr1 - Bandwidth is peak physical scan bandwidth achieved running SQL, assuming no compression. Effective data bandwidth will be much higher when compression is factored in. 2 - IOPS Based on read IO requests of size 8K running SQL, typically with sub-millisec

45、ond latencies. Note that the IO size greatly effects flash IOPS. Others quote IOPS based on 2K, 4K or smaller IOs that are not relevant for databases and measure IOs using low level tools instead of SQL.3- Actual Performance varies by application.4 Load rates are typically limited by database server

46、 CPU, not IO. Rates vary based on load method, indexes, data types, compression, and partitioningCopyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted49Exadata關鍵創(chuàng)新關鍵創(chuàng)新極限性能極限性能+ 混合列壓縮混合列壓縮 數(shù)據(jù)倉庫10 x 壓縮 存檔系統(tǒng)15x 壓縮壓縮數(shù)據(jù)放在壓縮數(shù)據(jù)放在Flash中中節(jié)省空間節(jié)省空間壓縮壓縮primary D

47、Bstandbytestdevbackup未壓縮未壓縮 智能線性存儲擴展智能線性存儲擴展 InfiniBand 連接存儲服務器 Smart Scan 智能掃描進行查詢卸載 智能智能PCI Flash緩存緩存 在disk前段提供透明緩存 30 x加速隨機I/O 提高4x數(shù)據(jù)掃描效率Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted50Exadata 存儲索引存儲索引示例表示例表 SALES 對常用列自動收集的摘要存儲在Exadata Stor

48、age Server的內(nèi)存Order_dateShip_dateCust_IDProd_IDAmount03-SEP-200919-SEP-2009100753293210,000.0003-SEP-200905-SEP-2009200982009820,000.0003-SEP-200907-OCT-2009100892001015,000.0003-SEP-200901-OCT-2009201001000035,000.0003-SEP-200919-OCT-2009803003000010,000.0003-SEP-200903-NOV-200910000 203040,000.00MI

49、NMAXData Chunk #1Order_date03-SEP-200903-SEP-2009Ship_date05-SEP-200907-OCT-2009Cust_ID1007520098Prod_ID2001032932Amount10,00020,000Data Chunk #2Order_date03-SEP-200903-SEP-2009Ship_date01-OCT-200903-NOV-2009Cust_ID1000080300Prod_ID 203030000Amount10,00040,000Copyright 2013, Oracle and/or its affili

50、ates. All rights reserved.Oracle Confidential Highly Restricted51Exadata 存儲索引存儲索引示例表示例表 SALES 存儲索引將無關data chunk忽略掉提供類似分區(qū)修剪的功能WHERE ship_date between 01-SEP-2009 and 31-SEP-2009排除排除 data chunk #2 MINMAXData Chunk #1Order_date03-SEP-200903-SEP-2009Ship_date05-SEP-200907-OCT-2009Cust_ID1007520098Prod_I

51、D2001032932Amount10,00020,000Data Chunk #2Order_date03-SEP-200903-SEP-2009Ship_date01-OCT-200903-NOV-2009Cust_ID1000080300Prod_ID 203030000Amount10,00040,000Order_dateShip_dateCust_IDProd_IDAmount03-SEP-200919-SEP-2009100753293210,000.0003-SEP-200905-SEP-2009200982009820,000.0003-SEP-200907-OCT-2009

52、100892001015,000.0003-SEP-200901-OCT-2009201001000035,000.0003-SEP-200919-OCT-2009803003000010,000.0003-SEP-200903-NOV-200910000 203040,000.00 xCopyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted52Exadata 智能掃描智能掃描: 比較比較 傳統(tǒng)掃描處理技術傳統(tǒng)掃描處理技術基于傳統(tǒng)存儲技術，全部的

53、數(shù)據(jù)庫智能存在于數(shù)據(jù)庫主機來源于存儲的數(shù)據(jù)大部分被數(shù)據(jù)庫主機所丟棄大量的廢棄數(shù)據(jù)占用寶貴的數(shù)據(jù)庫主機資源（IO、內(nèi)存和CPU），嚴重影響其它任務執(zhí)行， 導致處理緩慢I/Os 執(zhí)行:返回 1 TB 數(shù)據(jù)DB主機篩選1 TB數(shù)據(jù)，得到1000行客戶要求的數(shù)據(jù)，計算并返回給客戶端返回數(shù)據(jù)行SELECT customer_id FROM calls WHERE amount 200;DB主機確定表的存儲分區(qū)發(fā)起I/Os請求Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highl

54、y Restricted53Exadata 智能掃描智能掃描: 比較比較 Exadata的智能掃描技術的智能掃描技術僅查詢相關的字段customer_id和符合條件的行 where amount200被返回給數(shù)據(jù)庫服務器通過把掃描處理從數(shù)據(jù)庫中剝離，減少了數(shù)據(jù)庫服務器的CPU負擔，同時極大降低了無效的信息傳輸僅僅傳輸需要的、有價值的信息返回2MB數(shù)據(jù)到數(shù)據(jù)庫服務器返回數(shù)據(jù)行構(gòu)造Smart Scan 并發(fā)送到存儲單元Smart Scan在TB的表中識別出符合查詢需求的行和字段匯聚各存儲單元的返回結(jié)果到結(jié)果集SELECT customer_id FROM calls where amount 20

55、0;Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted54Exadata 智能掃描智能掃描:卸載卸載 data mining scoring 處理處理Data mining scoring 在 Exadata 執(zhí)行:所有的data mining scoring 功能卸載到 Exadata主要性能益處: CPU密集的操作從數(shù)據(jù)庫服務期轉(zhuǎn)移到exadata storage servers高達2x 性能收益(因為更多 CPU 在Exadata s

56、torage grid)更多性能收益, 因為 I/O 優(yōu)化減少數(shù)據(jù)庫服務器的CPU使用select cust_idfrom customerswhere region = USand prediction_probability(churnmod, Y using *) 0.8;Scoring function executed in ExadataNewCopyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted55Sun Oracle Datab

57、ase Machine:對大型掃描的優(yōu)化對大型掃描的優(yōu)化1 TB（壓縮）10 TB 的用戶數(shù)據(jù)需要10 TB 的IO100 GB（分區(qū)修剪）20 GB（存儲索引）5 GB （智能掃描）在Database Machine 上實現(xiàn)亞秒級數(shù)據(jù)減少10 倍，掃描加快2000 倍Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted56Exadata Smart Flash Cache在PCI flash中緩存讀寫IO透明加速讀寫敏感負載高達2.66百萬

58、次 SQL 8K讀高達1.68百萬次 SQL 8K寫持久化寫緩存提高數(shù)據(jù)庫恢復速度Exadata的Flash Cache比其他傳統(tǒng)的Flash層更高效緩存當前的熱數(shù)據(jù)，而不是昨天的數(shù)據(jù)緩存數(shù)據(jù)力度比其他緩存技術小816倍極大的改善Flash的效率I/Os2.66 百萬次百萬次 8K Read 1.68 百萬次百萬次 8K Write Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted57序號行行業(yè)業(yè)及及項項目目配置配置測試結(jié)測試結(jié)果果測試測

59、試日期日期1Telco: 經(jīng)營分析V2, Rack168倍 2010.11.26 - 282Telco: 財務系統(tǒng)V2, Rack20倍7天, 20103Telco:經(jīng)營分析V2, Rack235倍2010.9.8 - 154保險: 數(shù)據(jù)倉庫V2, Rack25倍21天, 2010.55MRD: ETC (DW)V2, Rack300倍14天, 2010.56MRD: ODS/DW V2, Rack62倍14天, 2010.57DATES & DWV2, Rack10 - 450倍2010.7.5 -168MRD: 集運運輸(OLTP)V2, Rack10倍2010.8.9 - 189電力:

60、低壓集超(DW)V110 倍7天, 2010.1Exadata 中國區(qū)用戶POC測試結(jié)果* 測試結(jié)果為Exadata相當于用戶原有環(huán)境或第三方對比測試方案的性能提升倍數(shù)Copyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly Restricted58一流品牌選擇一流品牌選擇ExadataCopyright 2013, Oracle and/or its affiliates. All rights reserved.Oracle Confidential Highly