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 数据仓库的发展 不断创新