12c database logo Data Warehousing - Best Practices

Oracle data warehousing best practices ensure that your Oracle system will leverage the full capabilities of the Oracle database. Read on to learn more about what features you should be taking advantage of to achieve extreme performance on your data warehouse.
Technical Information Demos & How-To Presentations & Webcasts

 
Technical Information
Demo & How-To
red-arrow-box Performant and Scalable Data Loading with Oracle Database 12c red-arrow-box High-Speed Data Loading (OBE)
red-arrow-box Best Practices for a Data Warehouse on Oracle  red-arrow-box How to Use Oracle Data Warehousing Functionality (OBE)
red-arrow-box Enabling Pervasive BI through a Practical Data Warehouse Reference Architecture red-arrow-box Oracle Partitioning in the Oracle Learning Library (OBEs)
red-arrow-box Best Practices for Implementing a Data Warehouse on the Oracle Exadata Database Machine
red-arrow-box More...
Presentations & Webcasts
red-arrow-box 6-part Webinar Series on Data Warehousing Best Practices
This new six-part series on best practices for data warehousing explains in detail the technologies available in the Oracle database to optimize every aspect of your data warehouse from schema design, to data loading, and query performance.
·  Third Normal Form Schema
·  Star Schema
·  Data Loading
·  Parallel Execution
·  Optimizer and Statistics Management
·  Partitioning
red-arrow-box Best Practices for Deploying a Data Warehouse on Oracle Database 11 g (Recording)
 
Links
red-arrow-box Learn More: Training, Library, Discussion Forum - Oracle Database, Data Warehouse Insider Blog, Optimizer Blog, Data Mining Blog
red-arrow-box Related Technologies: Oracle BI Home, Oracle Exadata Storage Technology, Oracle Retail Data Model, Oracle Communications Data Model, Data Integration , Oracle OLAP, Oracle Data Mining, Oracle Statistical Functions, Oracle Information Lifecycle Management
red-arrow-box
BIWA - the Oracle BI, Data Warehousing and Analytics SIG. Join Today!
 

 

KScope 14 RHS Banner

Database Cloud Service Banner