12c实现自动化信息生命周期管理

1、利用OracleDatabase12c 实现现自动化化信息生生命周期期管理Oracle系系统技技术产品管理理高级总总监KevinJernigan以下内容容旨在概概述产品品的总体体发展方方向。该内容仅仅供参考考，不可纳纳入任何何合同。本演示不不承诺提提供任何何材料、代码或或功能，也不应应将其作作为购买买决策的的依据。此处所所述有关关 Oracle产产品的任任何特性性或功能能的开发发、发布布以及相相应的日程安排排均由Oracle 自行行决定。议题数据增长长热图自动数据据优化热图和ADO 的优优势数据多样样性和使使用量不不断增加加2011 年数数据量达达 1,800 EB，到2020年年将增长长 2

2、0 倍移动到 2013年年，移移动设备备将成为为第一大大 Internet 访问问设备大数据大型客户户数据量量超过50PB企业数据库数数据每年增长长 45%云80%的的新应用程序序及其数据据规制到 2015年年，存档数据据将达300 EB社交业务务到 2015年年，年年交易额额将达300 亿当今的驱驱动力新兴的增增长因素素管理存储储面临的的挑战在不影响响性能的的情况下下压缩数数据在不产生生额外成成本的情情况下管管理更多多的数据据根据使用用情况分层和压压缩数据据信息生命命周期管管理在其生命命周期内内管理数数据“用于从从信息构构建之初初到最终终处置确确保其业业务价值值与最适适当且经经济有效效的IT

3、基基础架构构保持一一致的策策略、流流程、实实践和工工具。”存储联网网行业协协会(SNIA)数数据管管理论坛坛$总拥有成本 (TCO)$高价值中等价值低价值风险值数据压缩缩减少存储储占用空空间，更更快速地地读取压压缩数据据热数据版权所有 2012，Oracle 和/或其分支机构。保留所有权利。机密 Oracle 保密信息8温数据存档数据据11101010101010100110101010101101000101101100011010010100000100111000101010110100101101001011000101001001111100100100001000101010110

4、10001010101011101010011010111000010100010110111010101001010010010000100010101011010010110100111000010100100101000010010000100010101011100110103 倍高级行压缩101010101110101001101011100001010001011011101010100101001001000010001010101101001011010011100001010010010100001001000010001010101101001101010101110101

5、0011010111000010100010110111010101001010010010000100010101011010010110100111000010100100101000010010000100010101011100110111001100011101010 倍列查询压缩1010101011101010011010111000010100010110111010101001010010010000100010101011010010110100111000010100100101000010010000100010101011010011010101011101010011

6、0101110000101000101101110101010010100100100001000101010110100101101001110000101001001010000100100001000101010111001101110015 倍列存档压缩OracleAdvancedCompression透明、更更小、更快100% 对应应用程序序透明跨 CPU、DRAM、闪存存、磁盘盘和网络络的端到到端成本本/性能能优势更快地运运行：OLTP 应用用（事务务和分析析）和DW减少数据据库占用用空间节省资本本支出和和运营支支出通过减少少数据库库在DRAM 内存存中占用用的空间间来增加加云的R

7、OIOracleAdvancedCompression新特性、新特性性名称Oracle Advanced CompressionOracle Database 11gOracle Database 12cOLTP 压缩高级行压缩安全文件压缩高级 LOB 压缩安全文件重复消除 高级 LOB 重复消除混合列压缩混合列压缩新特性 热图 （对象和行级别）新特性自动数据优化新特性临时优化了解数据据使用模模式数据库“热图”100111101001111011000101101001011000100111101001111000100111100001110011010101100001011011100

8、100111001111000100111101001111000100111000001111001100100111001111000100101101001010011000101101001011011100100111001111000100110111001111000100111100001110011010101100001011011100100111001111000100111101001111000100111000001111001000101101001011011100100111001111000000101101001011011100111101001111

9、000100101101001010011100100111001111000100111111001111000100111101001111011100110111001111000100100111001111000100111111001111000100111101001111011100110111001111000100111101001111000111110010011100111100010010011100111101001111010011110100100111001111000100100111001111000100111101001111000100111100

10、001110011010101100001011011100100111001111000100111101001111000100111000001111001100100111001111000100101101001010011000101101001011011100100111001111000000101101001011011100111101001111000100101101001010011100100111001111000100111101001111000100111100001110011010101100001011011100100111001111000100

11、111101001111000000101101001011011100111101001111000100101101001010011000101101001011011100100111001111000100111101001111000100111100001110011010101100001011011100100111001111000100111101001111000000101101001011011100111101001111000100101101001010011000101101001011011100100111001111000100111100001110

12、011010101100001011011100100111001111000100111101001111000100111000001111001000101101001011011100100111001111000100111111001111000100111101001111011100110111001111000100111101001111000100111101001111000100110111001111000100100111001111000100111111001111000100111101001111011100110111001111000了解数据据使用模模

13、式数据库“热图”1001111010011110110001011010010110001001111010011110001001111000011100110101011000010110111001001110011110001001111010011110001001110000011110011001001110011110001001011010010100110001011010010110111001001110011110001001101110011110001001111000011100110101011000010110111001001110011110001001

14、111010011110001001110000011110010001011010010110111001001110011110000001011010010110111001111010011110001001011010010100111001001110011110001001111110011110001001111010011110111001101110011110001001001110011110001001111110011110001001111010011110111001101110011110001001111010011110001111100100111001

15、111000100100111001111010011110100111101001001110011110001001001110011110001001111010011110001001111000011100110101011000010110111001001110011110001001111010011110001001110000011110011001001110011110001001011010010100110001011010010110111001001110011110000001011010010110111001111010011110001001011010

16、010100111001001110011110001001111010011110001001111000011100110101011000010110111001001110011110001001111010011110000001011010010110111001111010011110001001011010010100110001011010010110111001001110011110001001111010011110001001111000011100110101011000010110111001001110011110001001111010011110000001

17、011010010110111001111010011110001001011010010100110001011010010110111001001110011110001001111000011100110101011000010110111001001110011110001001111010011110001001110000011110010001011010010110111001001110011110001001111110011110001001111010011110111001101110011110001001111010011110001001111010011110

18、00100110111001111000100100111001111000100111111001111000100111101001111011100110111001111000热图跟踪目标标“热图”跟踪数据库级级热图展展示被使用的表表和分区块级热图图展示块块级的最新修修改全面性段级同时展示示读取和和写入将索引查查询和全全表扫描描区分开开来自动排除除统计信信息收集集、DDL、表表重定义义等高性能无需任何何成本的的对象级级块级成本本 列列查询速速度和缩缩小10倍倍的占用用空间第 3步步：数据使用用进一步步减少后后，ADO自自动将其其转换为为存档压压缩，不再频频繁查询询=占占用空间间缩小15至至50倍倍针对OLTP 的自自动数据据优化基于热图图优化数数据针对DW的的自动数数据优化化数据通常常通过批批量加载载进入负载主要要来自于于查询，甚至在在加载时时也是如如此第 1步步：批量加载载直接进进入列压压缩缩小10倍倍的占用用空间，列查询询速度第 2步步：当数据不不常查询询时，ADO自自动将将其转换换为存档档压缩，并将其其移动至至成本较较低的存存储数据保持持在线，占用空空间缩小小 15 至50倍倍，同同时降低低存储成成本针对列的的快速、灵活加加载和查查询采用未压压缩、最最快速的的列查询询，实现现最为快快速的加加载混合负载载通常使使用Java 应用用或第3方方工具插插入并更