Oracle数据库中的海量数据处理

Agenda ·数据仓库系统的特点 ·Oracle数据仓库简介 ·使用Oracle数据仓库管理海量数据 ·Oracle Database Machine,硬件级数据仓库支持 DRACL∈

<Insert Picture Here> Agenda • 数据仓库系统的特点 • Oracle 数据仓库简介 • 使用Oracle 数据仓库管理海量数据 • Oracle Database Machine，硬件级数据仓库支持

Oracle数据仓库的发展.. ·数据仓库的开发从Oracle7.0就开始了 ·主要侧重于性能和扩展性 ·在Oracle8i中增加了可管理性和对Bl的支持 ·满足数据仓库的需求 ·高效的ETL功能 ·管理大数据量 管理各种用户请求 。 查询的快速响应 ·支持大量用户并发 ·易于使用，易于管理 无需特殊培训，统一管理界面 DRACL∈

Oracle 数据仓库的发展… • 数据仓库的开发从Oracle 7.0就开始了 • 主要侧重于性能和扩展性 • 在Oracle8i 中增加了可管理性和对BI 的支持 • 满足数据仓库的需求 • 高效的ETL功能 • 管理大数据量 • 管理各种用户请求 • 查询的快速响应 • 支持大量用户并发 • 易于使用，易于管理 • 无需特殊培训，统一管理界面

Oracle数据仓库的发展 Oracle 7.3 不断创新 Oracle 8n Oracle8i Partitione s Partition Hash and Oracle9i Parallel Ir Parallel Ir Resource Progress Parallel B Adaptive Parallel A Serverbe List and Ran Parallel C Materiallz Table Comp Oracle10g Server Ma Transpor Point-in-T Direct Lo Bitmap Join Functfoni Self-Tuning SQL Access Advisor Partition New Analyti Security Grouping Se .Automatic Storage Manager 0 External Tab Self-tuning Memory MERGE 0 Change Data Capture Multi-TableI SQL Models Proactive Q 。SQL Frequent Itemsets System Man .SQL Partition Outer Joins Statistical functions 0 Faster sort/aggregation 0 Multi-dimensional part.pruning and much more

Oracle 7.3 Oracle 7.3 z Partitioned Tables and Indexes z Partition Pruning z Parallel Index Scans z Parallel Insert, Update, Delete z Parallel Bitmap Star Query z Parallel ANALYZE z Parallel Constraint Enabling z Server Managed Backup/Recovery z Point-in-Time Recovery z Partitioned Tables and Indexes z Partition Pruning z Parallel Index Scans z Parallel Insert, Update, Delete z Parallel Bitmap Star Query z Parallel ANALYZE z Parallel Constraint Enabling z Server Managed Backup/Recovery z Point-in-Time Recovery Oracle 8.0 Oracle 8.0 z Hash and Composite Partitioning z Resource Manager z Progress Monitor z Adaptive Parallel Query z Server-based Analytic Functions z Materialized Views z Transportable Tablespaces z Direct Loader API z Functional Indexes z Partition-wise Joins z Security Enhancements z Hash and Composite Partitioning z Resource Manager z Progress Monitor z Adaptive Parallel Query z Server-based Analytic Functions z Materialized Views z Transportable Tablespaces z Direct Loader API z Functional Indexes z Partition-wise Joins z Security Enhancements Oracle9 Oracle9 i z List and Range-List Partitioning z Table Compression z Bitmap Join Index z Self-Tuning Runtime Memory z New Analytic Functions z Grouping Sets z External Tables z MERGE z Multi-Table Insert z Proactive Query Governing z System Managed Undo z List and Range-List Partitioning z Table Compression z Bitmap Join Index z Self-Tuning Runtime Memory z New Analytic Functions z Grouping Sets z External Tables z MERGE z Multi-Table Insert z Proactive Query Governing z System Managed Undo Oracle8 Oracle8ii Oracle10 Oracle10g z SQL Access Advisor z Automatic Storage Manager z Self-tuning Memory z Change Data Capture z SQL Models z SQL Frequent Itemsets z SQL Partition Outer Joins z Statistical functions z Faster sort/aggregation z Multi-dimensional part. pruning z and much more ... z SQL Access Advisor z Automatic Storage Manager z Self-tuning Memory z Change Data Capture z SQL Models z SQL Frequent Itemsets z SQL Partition Outer Joins z Statistical functions z Faster sort/aggregation z Multi-dimensional part. pruning z and much more ... Oracle 数据仓库的发展 不断创新

Oracle数据仓库的发展 Oracle11g新特性 Oracle Warehouse Builder ·基本数据库特性 ·企业级ELT选项 ·数据质量选项 ·连接器选项 ·基于OLAP的物化视图及查询重写 ·增强的分区功能，数据压缩技术和并行技术 ·集成的分析处理技术，数据挖掘技术和信息统计技术 DRACL∈

Oracle 数据仓库的发展 Oracle 11g新特性 • Oracle Warehouse Builder • 基本数据库特性 • 企业级ELT选项 • 数据质量选项 • 连接器选项 • 基于OLAP的物化视图及查询重写 • 增强的分区功能，数据压缩技术和并行技术 • 集成的分析处理技术，数据挖掘技术和信息统计技术 • ……

数据仓库市场的领导者 SAS Other Teradata 5.6% 5.2% IBM 5.9% 31.0% Microsoft 16.5% Oracle 35.8% Source:IDC,Worldwide Data Warehousing Tools 2004-2008 Forecast The market share of Oracle grows up to nearly 40%in 2007. -Gartner,2008 ORACL∈

数据仓库市场的领导者 Teradata 5.9% SAS 5.6% Other 5.2% IBM 31.0% Microsoft 16.5% Oracle 35.8% Source: IDC, Worldwide Data Warehousing Tools 2004-2008 Forecast The market share of Oracle grows up to nearly 40% in 2007. —Gartner, 2008