Data Studio enables agile data
Is "agile data" just another buzzphrase? Does it even make sense to try to apply agile development principles to the database?
An expert in agile development, Scott Ambler, sees agile data as an essential component for application development that goes against a database. You can learn more about agile data here: http://www.agiledata.org/
I think one of the classic challenges that agile data faces is about dealing with a "brittle" database. What do I mean by brittle? Basically, I am talking about how difficult and time consuming it can be to refactor the database schema to improve software. Check out the results of this survey question: "How long does it take to safely rename a column in a production database?"
Source of this survey:
Source: Data Quality Techniques survey by Ambysoft, September 2006.
The database and/or your software development techniques around the database are "brittle" if it takes longer than one week to make a simple rename change. Almost half of these respondents fell into that category. I would venture to say that more interesting refactoring would therefore take most shops much longer than a week.
Another part of the agile data challenge is about being able to quickly tell what the impact of a change is going to be. If we want to rename a column, what are all the database objects (tables spaces, views, stored procedures, etc ...) that will be impacted, and is there a tool to help me automate a script to make these changes?
If this sounds interesting to you and you want to learn more about agile data and how Data Studio can help, come listen to a replay (until May 09) of a webcast I did last week on how Data Studio can help make data more agile.
If you listen to the replay or are exploring agile data I am very curious to get your feedback. Just call me an agile guy. What do you think of applying agile techniques to the database? Are you doing it? If so, what is your experience? What tools are you using? What tools do you need?
What do you think?
-- Rafael Coss