12c database logo

Library: Oracle Database for Data Warehousing

 

This page provides a library of white papers and other collateral about Oracle Database 12c features enabling data warehousing and business intelligence.

Overview
·  Oracle Database 12c for Big Data and Data Warehousing
Best Practices
·  Performant and Scalable Data Loading with Oracle Database
·  6-part Webinar series (Oracle Database 11g, applicable to Oracle Database 12c):
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
·  Conducting a Data Warehousing Benchmark
· Leveraging Oracle Advanced Compression for Information Lifecycle Management
Parallelism and Scalability
·  Parallel Execution and Workload Management for an Operational Data Warehouse
·  Parallel Execution Fundamentals in Oracle Database
Partitioning
·  Partitioning with Oracle Database 12c
·  Oracle Partitioning in the Oracle Learning Library (OBEs)
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
·  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
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
·  Hybrid Columnar Compression
Advanced Analytics
OLAP
 
Links
 Learn More: Training, Discussion Forum - Oracle Database, Data Warehouse Insider Blog, Optimizer Blog, Data Mining Blog

BIWA - the Oracle BI, Data Warehousing and Analytics SIG. Join Today!

 


In-Memory Replay Banner