FREE DM Review Site Registration!
Sign-up today and access DM Review on the Web!

Your FREE registration entitles you to:

FREE email newsletters

FREE access to all DM Review content

FREE access to web seminars, resource portals, our white paper library and more!

   

We're having trouble deciding just who does what and when they do it in the development life cycle.

Q:

I believe this is primarily a process or methodology question. It has to do with responsibilities of the data administrator on a software development project. In our rather small shop, programmers have traditionally acted as business analysts as well, gathering business/functional requirements from users. Our data administrator (DA) creates a logical data model based on requirements, but then wishes to review the model and requirements with the business users. Shouldn't the data administrator be able to glean data requirements from documented functional requirements rather than having to essentially re-interview the business folks? Also, does the logical model really need to be reviewed by the business area? Isn't this more of a dialog between the DA and developer to make sure that the developer can implement desired functionality based on the data modeled?

A:

Chuck Kelley's Answer: It sounds like you are mixing logical and physical. You are correct if the physical model is what has been developed (I find that lots of folks pass the physical as the logical model!). I think that the DA is trying to do the correct process, if it is a logical model. We should always make sure that the logical model is a true representation of the business. While the functional specifications may be correct, I would like to see sign-off on the logical model with the business community so that they can validate the functional requirements one last time. This should be a review session, not a requirements session. Once this is agreed upon, then the physical model needs to be developed. If the DA is responsible for that, then after it is completed, then the DA should work with the developers so that they understand the physical implementation and make sure that the development process goes smoothly.

Les Barbusinski's Answer: Developers are process oriented, and all of the questions they ask a user are process oriented. This perspective frequently masks the real needs of the application and/or enterprise. In most applications the data is the object of the process ... not a by-product of the process (as most developers would see it). Data always has a life cycle. If you approach it from a process-oriented perspective, you'll often miss key business rules as well as whole stages in the life cycle and short change the design of the application ... causing costly rework at some future point of time (if not an actual loss of business for the enterprise).

My advice would be to include the DA in all your requirements-gathering sessions with the end users. This will minimize the impact on the users, and ultimately lead to a better design and a better product. Hope this helps.


Chuck Kelley is an internationally known expert in database and data warehousing technology. He has 30 years of experience in designing and implementing operational/production systems and data warehouses. Kelley has worked in some facet of the design and implementation phase of more than 50 data warehouses and data marts. He also teaches seminars, co-authored four books on data warehousing and has been published in many trade magazines on database technology, data warehousing and enterprise data strategies. He can be contacted at chuckkelley@usa.net.

Les Barbusinski is vice president of technology and co-founder of Digital Symmetry, LLC, a consulting firm that specializes in the design and development of data warehousing and business intelligence solutions. He has more than 20 years of experience in data warehouse and operational systems development and provides hands-on expertise in data warehouse design, development and project management. Les can be reached at dwexpert@dsym.com.

For more information on related topics, visit the following channels:



Industry Vendors