c實(shí)現(xiàn)自動(dòng)化信息生命周期管理

利用OracleDatabase12c實(shí)現(xiàn)自動(dòng)化信息生命周期管理Oracle系統(tǒng)技術(shù)產(chǎn)品管理高級(jí)總監(jiān)KevinJernigan以下內(nèi)容旨在概述產(chǎn)品的總體發(fā)展方向。該內(nèi)容僅供參考，不可納入任何合同。

本演示不承諾提供任何材料、代碼或功能，也不應(yīng)將其作為購(gòu)買(mǎi)決策的依據(jù)。此處所述有關(guān)Oracle產(chǎn)品的任何特性或功能的開(kāi)發(fā)、發(fā)布以及相應(yīng)的日程安排均由Oracle自行決定。議題數(shù)據(jù)增長(zhǎng)熱圖自動(dòng)數(shù)據(jù)優(yōu)化熱圖和ADO的優(yōu)勢(shì)數(shù)據(jù)多樣性和使用量不斷增加

2011年數(shù)據(jù)量達(dá)1,800EB，到2020年將增長(zhǎng)20倍

移動(dòng)到2013年，移動(dòng)設(shè)備將成為第一大Internet訪問(wèn)設(shè)備大數(shù)據(jù)

大型客戶數(shù)據(jù)量超過(guò)50PB企業(yè)數(shù)據(jù)庫(kù)數(shù)據(jù)每年增長(zhǎng)45%云80%的新應(yīng)用程序及其數(shù)據(jù)規(guī)制到2015年，

存檔數(shù)據(jù)將達(dá)300EB社交業(yè)務(wù)

到2015年，年交易額將達(dá)300億當(dāng)今的驅(qū)動(dòng)力新興的增長(zhǎng)因素管理存儲(chǔ)面臨的挑戰(zhàn)在不影響性能的情況下壓縮數(shù)據(jù)在不產(chǎn)生額外成本的情況下管理更多的數(shù)據(jù)根據(jù)使用情況分層和壓縮數(shù)據(jù)信息生命周期管理

在其生命周期內(nèi)管理數(shù)據(jù)

“用于從信息構(gòu)建之初到最終處置確保其業(yè)務(wù)價(jià)值與最適當(dāng)且經(jīng)濟(jì)有效的IT基礎(chǔ)架構(gòu)保持一致的策略、流程、實(shí)踐和工具?！?/p>

存儲(chǔ)聯(lián)網(wǎng)行業(yè)協(xié)會(huì)(SNIA)數(shù)據(jù)管理論壇$$$總擁有成本(TCO)?$$$高價(jià)值中等價(jià)值低價(jià)值風(fēng)險(xiǎn)值數(shù)據(jù)壓縮減少存儲(chǔ)占用空間，更快速地讀取壓縮數(shù)據(jù)熱數(shù)據(jù)版權(quán)所有

?2012，Oracle和/或其分支機(jī)構(gòu)。保留所有權(quán)利。機(jī)密－

Oracle保密信息8溫?cái)?shù)據(jù)存檔數(shù)據(jù)113倍

高級(jí)行壓縮10倍

列查詢壓縮15倍

列存檔壓縮OracleAdvancedCompression

透明、更小、更快100%對(duì)應(yīng)用程序透明跨CPU、DRAM、閃存、磁盤(pán)和網(wǎng)絡(luò)的端到端成本/性能優(yōu)勢(shì)更快地運(yùn)行：OLTP應(yīng)用（事務(wù)和分析）和DW減少數(shù)據(jù)庫(kù)占用空間節(jié)省資本支出和運(yùn)營(yíng)支出通過(guò)減少數(shù)據(jù)庫(kù)在DRAM內(nèi)存中占用的空間來(lái)增加云的ROIOracleAdvancedCompression

新特性、新特性名稱(chēng)OracleAdvancedCompressionOracleDatabase11gOracleDatabase12cOLTP壓縮高級(jí)行壓縮安全文件壓縮高級(jí)LOB壓縮安全文件重復(fù)消除高級(jí)LOB重復(fù)消除混合列壓縮混合列壓縮新特性熱圖（對(duì)象和行級(jí)別）新特性自動(dòng)數(shù)據(jù)優(yōu)化新特性臨時(shí)優(yōu)化了解數(shù)數(shù)據(jù)使使用模模式數(shù)據(jù)庫(kù)庫(kù)“熱熱圖””100111101001111011000101101001011000100111101001111000100111100001110011010101100001011011100100111001111000100111101001111000100111000001111001100100111001111000100101101001010011000101101001011011100100111001111000100110111001111000100111100001110011010101100001011011100100111001111000100111101001111000100111000001111001000101101001011011100100111001111000000101101001011011100111101001111000100101101001010011100100111001111000100111111001111000100111101001111011100110111001111000100100111001111000100111111001111000100111101001111011100110111001111000100111101001111000111110010011100111100010010011100111101001111010011110100100111001111000100100111001111000100111101001111000100111100001110011010101100001011011100100111001111000100111101001111000100111000001111001100100111001111000100101101001010011000101101001011011100100111001111000000101101001011011100111101001111000100101101001010011100100111001111000100111101001111000100111100001110011010101100001011011100100111001111000100111101001111000000101101001011011100111101001111000100101101001010011000101101001011011100100111001111000100111101001111000100111100001110011010101100001011011100100111001111000100111101001111000000101101001011011100111101001111000100101101001010011000101101001011011100100111001111000100111100001110011010101100001011011100100111001111000100111101001111000100111000001111001000101101001011011100100111001111000100111111001111000100111101001111011100110111001111000100111101001111000100111101001111000100110111001111000100100111001111000100111111001111000100111101001111011100110111001111000了解數(shù)數(shù)據(jù)使使用模模式數(shù)據(jù)庫(kù)庫(kù)“熱熱圖””100111101001111011000101101001011000100111101001111000100111100001110011010101100001011011100100111001111000100111101001111000100111000001111001100100111001111000100101101001010011000101101001011011100100111001111000100110111001111000100111100001110011010101100001011011100100111001111000100111101001111000100111000001111001000101101001011011100100111001111000000101101001011011100111101001111000100101101001010011100100111001111000100111111001111000100111101001111011100110111001111000100100111001111000100111111001111000100111101001111011100110111001111000100111101001111000111110010011100111100010010011100111101001111010011110100100111001111000100100111001111000100111101001111000100111100001110011010101100001011011100100111001111000100111101001111000100111000001111001100100111001111000100101101001010011000101101001011011100100111001111000000101101001011011100111101001111000100101101001010011100100111001111000100111101001111000100111100001110011010101100001011011100100111001111000100111101001111000000101101001011011100111101001111000100101101001010011000101101001011011100100111001111000100111101001111000100111100001110011010101100001011011100100111001111000100111101001111000000101101001011011100111101001111000100101101001010011000101101001011011100100111001111000100111100001110011010101100001011011100100111001111000100111101001111000100111000001111001000101101001011011100100111001111000100111111001111000100111101001111011100110111001111000100111101001111000100111101001111000100110111001111000100100111001111000100111111001111000100111101001111011100110111001111000熱圖跟蹤目目標(biāo)“熱圖圖”跟跟蹤數(shù)據(jù)庫(kù)庫(kù)級(jí)熱熱圖展展示被使用的的表和分區(qū)塊級(jí)熱熱圖展展示塊塊級(jí)的最新新修改改全面性性段級(jí)同時(shí)展展示讀讀取和和寫(xiě)入入將索引引查詢?cè)兒腿頀邟呙鑵^(qū)區(qū)分開(kāi)開(kāi)來(lái)自動(dòng)排排除統(tǒng)統(tǒng)計(jì)信信息收收集、、DDL、、表重重定義義等高性能能無(wú)需任任何成成本的的對(duì)象象級(jí)塊級(jí)成成本<5%活躍頻繁訪問(wèn)偶爾訪問(wèn)休眠積極更新不常更新，但頻繁查詢不常查詢也很少更新長(zhǎng)期分析和合規(guī)性熱冷熱圖EnterpriseManager存檔數(shù)據(jù)自動(dòng)數(shù)據(jù)據(jù)優(yōu)化基于使用用情況的的數(shù)據(jù)壓壓縮版權(quán)所有

?2012，Oracle和/或其分支機(jī)構(gòu)。保留所有權(quán)利。機(jī)密－

Oracle保密信息15熱數(shù)據(jù)3倍

高級(jí)行壓縮溫?cái)?shù)據(jù)10倍

列查詢壓縮15倍倍列存檔壓壓縮簡(jiǎn)單的聲明式式SQL擴(kuò)擴(kuò)展自動(dòng)數(shù)據(jù)優(yōu)化化ALTERTABLEsalesILMadd活躍頻繁訪問(wèn)偶爾訪問(wèn)休眠

OLTP壓縮（2至4倍）僅影響候選行在DRAM和閃存中緩存rowstorecompressadvancedrowafter2daysofnoupdate數(shù)據(jù)倉(cāng)庫(kù)壓縮（10倍）高性能存儲(chǔ)compressforquerylowafter1weekofnoupdate數(shù)據(jù)倉(cāng)庫(kù)壓縮（10倍）低成本的存儲(chǔ)tiertoSATA

Tablespace存檔壓縮（15至50倍）存檔存儲(chǔ)compressforarchivehighafter6monthsnoaccess自動(dòng)數(shù)據(jù)優(yōu)化化向表添加壓縮縮和分層策略略版權(quán)所有?2012，Oracle和/或其分支機(jī)構(gòu)。保留所有權(quán)利。17按時(shí)間分區(qū)最舊數(shù)據(jù)最新數(shù)據(jù)如果分區(qū)在30天內(nèi)未修改，則使用行壓縮來(lái)壓縮分區(qū)如果分區(qū)在180天內(nèi)未修改，則使用列壓縮來(lái)壓縮分區(qū)自動(dòng)數(shù)據(jù)優(yōu)化化跟蹤段和塊活活動(dòng)的熱圖版權(quán)所有?2012，Oracle和/或其分支機(jī)構(gòu)。保留所有權(quán)利。18按時(shí)間分區(qū)最舊數(shù)據(jù)最新數(shù)據(jù)自動(dòng)數(shù)據(jù)優(yōu)化化策略會(huì)自動(dòng)應(yīng)應(yīng)用到表版權(quán)所有?2012，Oracle和/或其分支機(jī)構(gòu)。保留所有權(quán)利。19按時(shí)間分區(qū)最舊數(shù)據(jù)最新數(shù)據(jù)自動(dòng)數(shù)據(jù)優(yōu)化化策略會(huì)自動(dòng)應(yīng)應(yīng)用到表版權(quán)所有?2012，Oracle和/或其分支機(jī)構(gòu)。保留所有權(quán)利。20按時(shí)間分區(qū)最舊數(shù)據(jù)最新數(shù)據(jù)自動(dòng)數(shù)據(jù)優(yōu)化化策略會(huì)自動(dòng)應(yīng)應(yīng)用到表版權(quán)所有?2012，Oracle和/或其分支機(jī)構(gòu)。保留所有權(quán)利。21按時(shí)間分區(qū)最舊數(shù)據(jù)最新數(shù)據(jù)自動(dòng)數(shù)據(jù)優(yōu)化化減少存儲(chǔ)占用用空間，更快快速地讀取壓壓縮數(shù)據(jù)版權(quán)所有?2012，Oracle和/或其分支機(jī)構(gòu)。保留所有權(quán)利。機(jī)密－Oracle保密信息22按時(shí)間分區(qū)最舊數(shù)據(jù)最新數(shù)據(jù)自動(dòng)數(shù)據(jù)優(yōu)化化將數(shù)據(jù)自動(dòng)分分層至成本較較低的存儲(chǔ)版權(quán)所有?2012，Oracle和/或其分支機(jī)構(gòu)。保留所有權(quán)利。23按時(shí)間分區(qū)最舊數(shù)據(jù)最新數(shù)據(jù)第1層存存儲(chǔ)第2層存存儲(chǔ)如果表格空間接近全滿，則使用存檔壓縮將最舊的分區(qū)進(jìn)行壓縮，并且將其移動(dòng)至第2層存儲(chǔ)自動(dòng)數(shù)據(jù)優(yōu)化化本季度今年此前幾年針對(duì)快速OLTP的行存儲(chǔ)針對(duì)快速分析的壓縮列存儲(chǔ)10倍壓縮縮15倍壓縮縮數(shù)據(jù)使用逐漸漸減少后，高高級(jí)數(shù)據(jù)優(yōu)化化會(huì)自動(dòng)將數(shù)數(shù)據(jù)轉(zhuǎn)換為列列壓縮的在線數(shù)據(jù)針對(duì)最大壓縮縮的存檔壓縮列存存儲(chǔ)報(bào)表合規(guī)性和報(bào)表OLTP強(qiáng)大的策略規(guī)規(guī)范自動(dòng)數(shù)據(jù)優(yōu)化化聲明式策略規(guī)規(guī)范：條件動(dòng)作altertablesalesilmaddpolicyrowstorecompressadvancedsegmentafter3daysofnomodification;條件為數(shù)據(jù)創(chuàng)創(chuàng)建、訪問(wèn)、、修改后的時(shí)時(shí)段動(dòng)作為壓縮分分層或表格空空間分層策略繼承自表表格空間或表表格新表格繼承自自表格空間；；也可以應(yīng)用用于現(xiàn)有表格格新分區(qū)（包括括間隔分區(qū)））繼承自表格格最多可將占用用空間縮小15倍，，加快查詢速速度行壓縮和存檔檔壓縮補(bǔ)充了了高級(jí)行壓縮縮最佳實(shí)踐：第1步：：針對(duì)整個(gè)DB使用高高級(jí)行壓縮，然后第2步：：更新逐漸減少少后，ADO自動(dòng)將數(shù)數(shù)據(jù)轉(zhuǎn)換為列列壓縮，主要用于報(bào)表=>列查詢?cè)兯俣群涂s小小10倍倍的占用空間間第3步步：：數(shù)據(jù)據(jù)使使用用進(jìn)進(jìn)一一步步減減少少后后，，ADO自自動(dòng)動(dòng)將將其其轉(zhuǎn)轉(zhuǎn)換換為為存存檔檔壓壓縮縮，不不再再頻頻繁繁查查詢?cè)?>占占用用空空間間縮縮小小15至至50倍倍針對(duì)對(duì)OLTP的的自自動(dòng)動(dòng)數(shù)數(shù)據(jù)據(jù)優(yōu)優(yōu)化化基于于熱熱圖圖優(yōu)優(yōu)化化數(shù)數(shù)據(jù)據(jù)針對(duì)對(duì)DW的的自自動(dòng)動(dòng)數(shù)數(shù)據(jù)據(jù)優(yōu)優(yōu)化化數(shù)據(jù)據(jù)通通常常通通過(guò)過(guò)批批量量加加載載進(jìn)進(jìn)入入負(fù)載載主主要要來(lái)來(lái)自自于于查查詢?cè)儯?，甚甚至至在在加加載載時(shí)時(shí)也也是是如如此此第1步步：：批量量加加載載直直接接進(jìn)進(jìn)入入列列壓壓縮縮縮小小10倍倍的的占占用用空空間間，，列列查查詢?cè)兯偎俣榷鹊?步步：：當(dāng)數(shù)數(shù)據(jù)據(jù)不不常常查查詢?cè)儠r(shí)時(shí)，，ADO自自動(dòng)動(dòng)將將其其轉(zhuǎn)轉(zhuǎn)換換為為存存