Managing the Data Warehouse

After the data warehouse environment is built and users rely on it for their data analysis needs, you must be prepared to manage the environment like any other mission-critical application. Managing implies creating a systems management plan for the data warehouse that should include the plans to support the following.

Operations

• 24 x 7 support (help desk)

• Automation

• Chargeback

• Capacity planning

• Securing access

Administration

• Maintenance of database structures

• Data availability

• Backup and recovery

Performance Management

• Proactive automation

• Predictive performance modeling

• Server performance optimization

• Network performance optimization

• Database performance optimization

Additionally, you should manage change throughout the application life cycle for operational systems that can affect the warehouse because they are data sources, as well as for any application that accesses warehouse data directly.