Data Warehouse Project Model Oracle Tips  by Burleson Consulting

The Data Warehouse Development Life Cycle

Warehouse Project Model

As mentioned, the critical path is a task(s), which, if delayed, puts the delivery of the finished project behind schedule. While both PERT and CPM allow for critical paths to be identified and tracked as the status of the projects are updated, these techniques also allow for modeling how human resources can be re-allocated among the tasks. The re-allocation of human resources enables managers to shift time requirements and re-compute the critical paths. Both PERT and CPM allow crashing techniques used to accelerate delivery times.
Contingency modeling is another popular feature, whereby the manager may create artificial scenarios and use their model to predict the overall impact on the project.

The most effective project management tools contain the following features:

* A central data repository that can be accessed and updated by remote sub-project managers. Ideally, the software includes the ability to notify top manager of any sub-managers who have failed to update their current project status.

* A time-based “versioning” facility, whereby the status of a project at any given time can be created.

* The ability to “drill-down” into increasing levels of detail regarding task and status information.

---

This is an excerpt from "High Performance Data Warehousing", copyright 1997.

If you like Oracle tuning, you may enjoy the book Oracle Tuning: The Definitive Reference , with over 900 pages of BC's favorite tuning tips & scripts.  You can buy it directly from the publisher and save 30%, and get instant access to the code depot of Oracle tuning scripts.