| Overview |
| · |
Oracle Database 11g Release 2 for Data Warehousing and Business Intelligence |
| Advanced Analytics |
| · |
Advanced Analytics Data Sheet (Feb. 2012) |
| · |
See library materials on R Enterprise |
| · |
See library materials on Data Mining |
| Best Practices |
| · |
Managing Optimizer statistics in a Data Warehouse on Oracle Database 11g (blog entry) |
| · |
Performant and Scalable Data Loading with Oracle Database 11g |
| · |
6-part webinar series: Third Normal Form Schema, Star Schema, Data Loading, Parallel Execution, Optimizer and Statistics Management, Partitioning, |
| · |
Best practices for a Data Warehouse on Oracle Database |
| · |
Best Practices for Workload Management of a Data Warehouse on the Oracle Exadata Database Machine |
| · |
Enabling Pervasive BI through a Practical Data Warehouse Reference Architecture |
| · |
Best Practices for Implementing a Data Warehouse on the Oracle Exadata Database Machine |
| · |
Best Practices for Deploying a Data Warehouse on Oracle Database 11g (Recording) |
| · |
Best Practices for Extreme Performance with Oracle Data Warehousing (OOW 2009) |
| · |
Best Practices for Deploying a Data Warehouse on Oracle Database 11g (OOW 2008) |
| · |
High-Speed Data Loading (OBE) |
| · |
How to Use Oracle Data Warehousing Functionality (OBE) |
| · |
Deep Dive on Oracle Partitioning (OBE) |
| · |
Conducting a Data Warehousing Benchmark |
| · |
Security and the Data Warehouse |
| Data Mining |
| · |
Oracle Data Mining Technical White Paper (Feb. 2012) |
| · |
Data Mining Component Sheet (Feb. 2012) |
| · |
Oracle OpenWorld '11 Presentation: Oracle In-Database Analytics |
| · |
Using Oracle Data Miner 11g Release 2 with Star Schema data - A Telco Churn Case Study |
| · |
Data Mining Algorithms |
| · |
Oracle OpenWorld '09 Presentation: Oracle Data Mining 11g Release 2 |
| · |
Overview and Demo: Oracle Data Mining 11gR2 (recording) |
| · |
Presentation: Anomaly and Fraud Detection with Oracle Data Mining 11gR2 |
| · |
Performance Improvement of Model Building in Oracle 11.1 Data Mining |
| Exadata and Database Machine |
| · |
Oracle Exadata Technical Overview: Oracle Exadata |
| · |
Overview of OracleExadata Database Machine - Extreme Performance for the Data Warehouse |
| · |
Oracle Exadata Database Machine Technical Whitepaper |
| · |
Hybrid Columnar Compression Technical White Paper |
| OLAP |
| · |
On-line Analytic Processing with Oracle Database 11g Release 2 |
| · |
OLAP Data Sheet |
| · |
Using Oracle Business Intelligence Enterprise Edition with the OLAP Option to Oracle Database 11g White Paper |
| · |
Building OLAP 11g Cubes (tutorial) |
| · |
Querying OLAP 11g Cubes (tutorial) |
| · |
Creating BI EE Metadata for OLAP 11g Cubes (tutorial) |
| · |
Querying OLAP 11g Data Using Oracle BI Answers (tutorial) |
| · |
Creating Interactive APEX Reports Over OLAP 11g Cubes (tutorial) |
| On-Time Data Warehousing |
| · |
On-Time Data Warehousing with Oracle Database 10g - Information at the Speed of your Business |
| Parallelism and Scalability |
| · |
SQL Parallel Execution in Oracle Database 11g |
| · |
Parallel Execution Fundamentals in Oracle Database 11g Release 2 |
| · |
Integrating Hadoop Data with Oracle Parallel Processing |
| · |
In-Database Map-Reduce |
| · |
Table Compression in Oracle10g Release 2 |
| Partitioning |
| · |
Partitioning with Oracle Database 11g Release 2 |
| · |
Partitioning Data Sheet |
| · |
Manipulating Partitions (tutorial) |
| · |
Using High-Speed Data Loading and Rolling Window Operations with Partitioning (tutorial) |
| Query Optimization |
| · |
SQL Plan Management in Oracle Database 12c |
| · |
SQL Plan Management in Oracle Database 11g |
| · |
Oracle Optimizer: Explain the Explain Plan |
| · |
Upgrading from Oracle Database 11g to 12c: What to expect from the Optimizer |
| · |
Upgrading from Oracle Database 10g to 11g: What to expect from the Optimizer |
| · |
Upgrading from Oracle 9i to 10g: What to Expect from the Optimizer |
| · |
Understanding Optimizer Statistics with Oracle Database 12c - Part 1 |
| · |
Best Practices for Gathering Optimizer Statistics with Oracle Database 12c - Part 2 |
| · |
Understanding Optimizer Statistics with Oracle Database 11g - Part 1 |
| · |
Best Practices for Gathering Optimizer Statistics with Oracle Database 11g - Part 2 |
| · |
Query Optimization in Oracle Database 10g Release 2 |
| · |
Comparison of Materialized Views & Analytic Workspaces in Oracle Database 11g |
| · |
Materialized Views in Oracle Database 10g |
| · |
Key Data Warehousing Features in Oracle10g: A Comparative Analysis |
| · |
DSS Performance in Oracle Database 10g Release 1 |
| R Enterprise |
| · |
R Enterprise Component Sheet (Feb. 2012) |
Database
Printer View