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 ensure the EDW will get the optimal performance and will scale as your data set grows you need to get three fundamental things correct, the hardware configuration, the data model and the data loading process. By designing these three corner stones correctly you can seamlessly scale out your EDW without having to constantly tune or tweak the system.

The paper is divided into four sections:

The first section deals with the key aspects of configuring your hardware platform of choice to ensure optimal performance.

The second briefly describes the two fundamental logical models used for database warehouses.
The third outlines how to implement the physical model for these logical models in the most optimal manner in an Oracle database.
Finally the fourth section covers system management techniques including workload management and database configuration.

Vendor:: Oracle Corporation
Posted:: Feb 8, 2021
Published:: Jan 19, 2009
Format:: PDF
Type:: White Paper

Already a Bitpipe member? Log in here

Download this White Paper!

Corporate Email Address:
You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

Please provide a Corporate Email Address.

This email address is already registered. Please log in.
First Name:
You forgot to provide your first name.
Last Name:
You forgot to provide your last name.
Company Name:
You forgot to provide a company name.
Job Title:
You forgot to provide a job title.
Seniority:
You forgot to select your seniority.
Job Function:
You forgot to select your job function.
# of employees:
You did not select the number of employees at your company.
Industry:
You did not select which industry you are in.
Sub-Industry:
You did not select which industry you are in.
Address 1:
You did not provide a full local address.
Address 2:
City/Town:
You did not provide a full local address.
Country:
You did not select the country you are from.
State/Province:

You did not provide a full local address.
Zip/Postal Code:
You did not provide a full local address.
Phone:
You forgot to provide a phone number.

This phone number format is not recognized. Please check the country and number.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.