|
|
|
Oracle 8 Tips
by Burleson Consulting |
The Data Warehouse Development Life Cycle
Oracle Data Warehouse Design
This chapter focuses on data warehouse design techniques for
creating high-performance Oracle warehouses. While traditional
online systems design involves the design of the input screens, data
structures, and output reports, data warehouse design places the
focus on designing flexibility into the Oracle table structures and
the creation of flexible query input software. Without an effective
database design, no amount of tuning will allow the Oracle warehouse
to achieve optimal performance. Hence, it is critical to a database
design that we properly design the Oracle table structures and the
data input screens.
|