Project Risk Management
Oracle Tips by Burleson Consulting
The Data Warehouse Development Life Cycle
Risk Management And Data Warehouse Projects
Data managers must always be cognizant that estimates of resources
for a data warehouse project are only estimates, and that a certain
element of risk is involved in any estimation. In the following
example, you can see that the addition of human resources to a
specific programming task has been estimated. You know, of course,
that each marginal resource assigned to a project will increase the
costs, and you can also safely assume that at some point, adding
another resource will increase costs, without necessarily improving
delivery dates (see Figure 2.7).
Figure 2.7 Risk and project management.
As you can see from Table 2.6, the data warehouse
project manager must understand how to add additional human
resources to a task in order to maximize delivery time. Just about
any task that falls in the critical path of a project can be crashed
by adding more resources, but, as mentioned earlier, there is a
point of diminishing returns. This concept is especially true for
data warehouse development, because many programming tasks cannot
easily be partitioned into pieces that can be concurrently
$700 (Best for a non-critical task)
Joe and Francis
Joe and Sam
$900 (Maximum crash point)
Joe, Sam, and Francis 4 days
Table 2.6 A comparison of resources to assign to a specific task.
The project manager must also be able to make conscious tradeoffs
when assigning programming resources to data warehouse tasks. As you
can see in Table 2.7, there is often a tradeoff between programmer
experience and programmer productivity. The real test is to weigh
the additional costs for experienced programmers with their
productivity. Table 2.7 demonstrates that while experienced
programmers may cost more than naive programmers, they are often a
Years Of Experience
Table 2.7 A comparison of cost per line of computer code.
The point here is very simple; the duration of a task is a function
of both the amount of resources allocated to the task and the
productivity of the resource that has been assigned to the task.
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.