Best Practices for a Data Warehouse on Oracle Database 11g
Increasingly companies are recognizing the value of an Enterprise Data Warehouse (EDW). A true EDW provides a single 360-degree view of the business and a powerful platform for a wide spectrum of business intelligence tasks ranging from predictive analysis to near real-time strategic and tactical decision support throughout the organization. In order to ensuring the EDW will get the optimal performance and will scale as data set grows one needs to get three fundamental things correct, the hardware configuration, the data model and the data loading process. By designing these three corner stones correctly one can seamlessly scale out EDW without having to constantly tune or tweak the system.