|
|
| |
 |
|
Oracle Tips
by Burleson Consulting
|
The Data Warehouse Development Life Cycle
Oracle Features for the Data Warehouse
While Oracle markets itself as a generic database management system,
there are several features that greatly assist in the creation of
fast and useful data warehouses. While many of the Oracle features
are discussed throughout this text, this chapter will focus on those
features of Oracle that are designed specifically for the data
warehouse. The topics for this chapter will include managing tables,
indexes, and tablespaces in a data warehouse context. In addition,
we will cover bitmapped indexes, the table cache option, and other
indispensable concepts for the Oracle data warehouse developer.
Planning For Growth of the Data Warehouse
One of the biggest problems in data warehousing is the issue of
planning for growth and ensuring that your data warehouse continues
to perform at an acceptable level. As we know, databases run within
a well-defined domain of systems resources, and a shortage of these
system resources can lead to performance degradation. The trick is
to design a data warehouse architecture with the ability to add
resources on an as-needed basis without interrupting processing.
Growth of a database can occur in several areas. As the physical
size of the database increases, so does the need for disk storage.
As the volume of users increases, so does the need for increased
buffer and lock pool storage. As network traffic increases, an
increasing demand falls on the routers and bandwidth may need to be
increased.
 |
Expert Remote DBA
BC is America's oldest and largest Remote DBA Oracle support
provider. Get real Remote DBA experts, call
BC Remote DBA today. |
 |
|
|
|
|
