The Current State of Data Quality Survey Results: September 2006

Scott W. Ambler + Associates
Home | Articles | Books | IT Surveys | Podcasts | Contact Us | Announcements | Site Map
How to Measure Anything 2nd Edition This survey was performed during the last week of September 2006 and there was 1,137 respondents. The survey was sent out to the Dr. Dobb's Journal mailing list.

The Survey Results

The results of this survey are summarized in the article Whence Data Quality? in the February 2007 of Dr. Dobb's Journal.



The Survey (199K)

Survey Data File

Raw Data (1 MB)

Survey Presentation

Summary Presentation (422K)

What You May Do With This Information

You may use this data as you see fit, but may not sell it in whole or in part. You may publish summaries of the findings, but if you do so you must reference the survey accordingly (include the name and the URL to this page). Feel free to contact me with questions. Better yet, if you publish, please let me know so I can link to your work.

Discussion of the Results

  1. There are significant data quality problems within many organizations, yet many organizations do not have a viable strategy for addressing them.
  2. The earlier, and more often, that you test your database in the development lifecycle, the greater the data quality.
  3. A collaborative approach to data standards/guidelines is more effective than a command-and-control approach, which in turn, is better than no approach at all.
  4. A large percentage of organizations struggle to evolve their database schema in a timely manner, thereby reducing their competitiveness.
  5. Evolutionary/agile approaches to data modeling are just as effective as traditional approaches, and both approaches correlated to improved data quality.
  6. Database service-level agreements (SLAs) are co-related to improved data quality.
  7. This survey suffers from the fundamental challenges faced by all surveys.

Links to Other Articles/Surveys

From what I can tell, nobody has ever done a similar survey to this one. However, there are some interesting resources available:

Why Share This Much Information?

I'm sharing the results, and in particular the source data, of my surveys for several reasons:

  1. Other people can do a much better job of analysis than I can. If they publish online, I am more than happy to include links to their articles/papers.
  2. Once I've published my column summarizing the data in DDJ, I really don't have any reason not to share the information.
  3. I think that it's a good thing to do and I invite others to do the same.

Disciplined Agile Delivery: The Foundation for Scaling Agile Agile Modeling: Practices for Scaling Agile Agile Data: Practices for Scaling Agile EnterpriseUP: Agility at Scale Software Development Practices Advisor Scott Ambler + Associates Follow @scottwambler on Twitter!

Copyright 2006-2014 Scott W. Ambler

This site owned by Ambysoft Inc.