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)將其作為購買決策的依據(jù)。此處所述有關(guān)Oracle產(chǎn)品的任何特性或功能的開發(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訪問設(shè)備大數(shù)據(jù)

大型客戶數(shù)據(jù)量超過50PB企業(yè)數(shù)據(jù)庫數(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、閃存、磁盤和網(wǎng)絡(luò)的端到端成本/性能優(yōu)勢(shì)更快地運(yùn)行：OLTP應(yīng)用（事務(wù)和分析）和DW減少數(shù)據(jù)庫占用空間節(jié)省資本支出和運(yùn)營支出通過減少數(shù)據(jù)庫在DRAM內(nèi)存中占用的空間來增加云的ROIOracleAdvancedCompression

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

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

Tablespace存檔壓縮（15至50倍）存檔存儲(chǔ)compressforarchivehighafter6monthsnoaccess自動(dòng)數(shù)據(jù)優(yōu)優(yōu)化向表添加壓壓縮和分層層策略版權(quán)所有?2012，Oracle和/或其分支機(jī)構(gòu)。保留所有權(quán)利。17按時(shí)間分區(qū)區(qū)最舊數(shù)據(jù)最新數(shù)據(jù)如果分區(qū)在30天內(nèi)未修改，則使用行壓縮來壓縮分區(qū)如果分區(qū)在180天內(nèi)未修改，則使用列壓縮來壓縮分區(qū)自動(dòng)數(shù)據(jù)優(yōu)優(yōu)化跟蹤段和塊塊活動(dòng)的熱熱圖版權(quán)所有?2012，Oracle和/或其分支機(jī)構(gòu)。保留所有權(quán)利。18按時(shí)間分區(qū)區(qū)最舊數(shù)據(jù)最新數(shù)據(jù)自動(dòng)數(shù)據(jù)優(yōu)優(yōu)化策略會(huì)自動(dòng)動(dòng)應(yīng)用到表表版權(quán)所有?2012，Oracle和/或其分支機(jī)構(gòu)。保留所有權(quán)利。19按時(shí)間分區(qū)區(qū)最舊數(shù)據(jù)最新數(shù)據(jù)自動(dòng)數(shù)據(jù)優(yōu)優(yōu)化策略會(huì)自動(dòng)動(dòng)應(yīng)用到表表版權(quán)所有?2012，Oracle和/或其分支機(jī)構(gòu)。保留所有權(quán)利。20按時(shí)間分區(qū)區(qū)最舊數(shù)據(jù)最新數(shù)據(jù)自動(dòng)數(shù)據(jù)優(yōu)優(yōu)化策略會(huì)自動(dòng)動(dòng)應(yīng)用到表表版權(quán)所有?2012，Oracle和/或其分支機(jī)構(gòu)。保留所有權(quán)利。21按時(shí)間分區(qū)區(qū)最舊數(shù)據(jù)最新數(shù)據(jù)自動(dòng)數(shù)據(jù)優(yōu)優(yōu)化減少存儲(chǔ)占占用空間，，更快速地地讀取壓縮縮數(shù)據(jù)版權(quán)所有?2012，Oracle和/或其分支機(jī)構(gòu)。保留所有權(quán)利。機(jī)密－Oracle保密信息22按時(shí)間分區(qū)區(qū)最舊數(shù)據(jù)最新數(shù)據(jù)自動(dòng)數(shù)據(jù)優(yōu)優(yōu)化將數(shù)據(jù)自動(dòng)動(dòng)分層至成成本較低的的存儲(chǔ)版權(quán)所有?2012，Oracle和/或其分支機(jī)構(gòu)。保留所有權(quán)利。23按時(shí)間分區(qū)區(qū)最舊數(shù)據(jù)最新數(shù)據(jù)第1層層存儲(chǔ)第2層層存儲(chǔ)如果表格空間接近全滿，則使用存檔壓縮將最舊的分區(qū)進(jìn)行壓縮，并且將其移動(dòng)至第2層存儲(chǔ)自動(dòng)數(shù)據(jù)優(yōu)優(yōu)化本季度今年此前幾年針對(duì)快速OLTP的行存儲(chǔ)針對(duì)快速分析的壓縮列存儲(chǔ)10倍壓壓縮15倍壓壓縮數(shù)據(jù)使用逐逐漸減少后后，高級(jí)數(shù)數(shù)據(jù)優(yōu)化會(huì)會(huì)自動(dòng)將數(shù)數(shù)據(jù)轉(zhuǎn)換為為列壓縮的的在線數(shù)據(jù)針對(duì)最大壓壓縮的存檔壓縮列列存儲(chǔ)報(bào)表合規(guī)性和報(bào)報(bào)表OLTP強(qiáng)大的策略略規(guī)范自動(dòng)數(shù)據(jù)優(yōu)優(yōu)化聲明式策略略規(guī)范：條條件動(dòng)作altertablesalesilmaddpolicyrowstorecompressadvancedsegmentafter3daysofnomodification;條件為數(shù)據(jù)據(jù)創(chuàng)建、訪訪問、修改改后的時(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ìn)一一步減少后，，ADO自自動(dòng)將其轉(zhuǎn)換換為存檔壓縮縮，不再頻繁查查詢=>占用空空間縮小15至50倍針對(duì)OLTP的自動(dòng)動(dòng)數(shù)據(jù)優(yōu)化基于熱圖優(yōu)化化數(shù)據(jù)針對(duì)DW的的自動(dòng)數(shù)據(jù)據(jù)優(yōu)化數(shù)據(jù)通常通過過批量加載進(jìn)