Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: DBA not bottleneck

RE: DBA not bottleneck

From: Mark W. Farnham <>
Date: Wed, 9 Jun 2004 10:19:41 -0400
Message-ID: <>

Construct a PERT (Program Evaluation and Review Technique)chart with loops for the business analysts. In the loop structure, show a task for you "handled identified rules," followed by a business analyst task "review improved results for additional ideas." This feeds back to their task "identify business rules to be enforced." The business analyst loops only break out when they take the path "business analyst swears that is all, business analyst documents all requirements in hard copy (of which you get a signed copy.) Show final your cleansing/testing task downstream from the completion of all the loops.

Print out the CPM, and it will show that you cannot even begin your final task until the loops end, and that you cannot put a finite time span on the loops.

This has the advantage of being a pretty picture AND accurately protrays the situation you have explained.

If your management is good, this will help them understand the situation. I hope I didn't sound too snotty. In fairness to the business analysts, it really does help to see things when you're looking at a less fuzzy picture. So at the start it is as if they are too close to a Renoir and they need you to back them up from the points to see the picture. Only then do they realize they want you to fix color of the apparently purple cat.

At that point, management will have to consider whether they should put a time limit on the iterations.

Good luck.

-----Original Message-----

[]On Behalf Of
Sent: Wednesday, June 09, 2004 9:04 AM
Subject: RE:DBA not bottleneck


I am heading up a data cleansing effort.

The process goes like this:

-analysis done on current data
-users define business requirements for data transformation if necessary
-I ask questions because they often leave things out and this is what a good
DBA would do
-I write the process to clean-up data then ask users to test before we do in
-We do in production

I have been leading the meetings each day (30 min) and documenting resolutions, next actions, responsible parties, yadayada.

However, the user has come up with a number of business rules after going back and doing some analysis and saying "Well, I guess we didn't do that right the first time - and as much as I could I have been learning all the business rules and asking lots of pertinent questions" - all good everybody happy.

However, managers say "Hey, this should be done by now - not realizing the detailed analysis and testing this requires and multiple people" - so

I want to provide something back like how long it might take me to do - however, to be frank much of what I find when coding is more issues that need to be answered with a business rule that I cannot make up!!!!! So I do go the extra mile - not just fix the one thing - but also bring up pertinent and relevant issues and keep this train on track.

If they do good analysis and it takes them X number of hours to do that it doesn't take me long to turn around the fix.

If they miss something or in fixing that one thing I uncover yet something else on the system or need clarification it takes longer.

So, what do I say to these managers???? I am more help on this in all areas but since once the issues are identified (which I am one of the persons who finds and is able to generalize into a more concrete problem and find patterns across the database ), analysis is done (which I often help with), business requirements specified (which I often ask pertinent questions for to get clarification), I am the last guy holding the bag writing the clean-up process - which is actually done speedy quick - but since it is the last thing in the overall process it looks like I have had lots of time to do this.

Very frustrating. How do I help managers to understand this????

Please see the official ORACLE-L FAQ:

To unsubscribe send email to: put 'unsubscribe' in the subject line.

Archives are at FAQ is at

Please see the official ORACLE-L FAQ:

To unsubscribe send email to: put 'unsubscribe' in the subject line.

Archives are at FAQ is at
Received on Wed Jun 09 2004 - 09:22:31 CDT

Original text of this message