Data Quality Survey Results - Ambysoft Effective Practices for 调查结果- ambysoft数据质量的有效措施.ppt

Copyright 2006 Scott W. Ambler Data Quality Survey Results Scott W. Ambler /scottAmbler.html How To Use These Slides I have provided these slides, and the raw data behind them, so that others can use them in their own work. You may reuse all, or a part of, this slide deck as long as you provide a clear reference to the source. The suggested reference is: Results from Scott Ambler’s September 2006 Data Quality Survey posted at /surveys/ The Survey Sent out to ~28,000 people 1137 Respondents September 2006 98% from North America Used Dr. Dobb’s Journal (DDJ) mailing list Results: February 2007 issue of DDJ for summary article Source data is downloadable /surveys/ Use of Color in These Slides Green is used for positive practices or results Yellow and orange are used for questionable practices or results (orange is worse than yellow) Red is used for problematic practices or results Muted colors, particularly purples and blues, are used for other practices or results Many traditional “best practices” are often rated as questionable Which Sector Do You Work In? Data Quality Current State of Data Quality Org Size and Data Quality Strategies to Address Problems Service Level Agreement (SLA) in Place? SLA and Data Quality Data Naming Conventions Naming Conventions and Data Quality Do You Have a Database Service Level Agreement (SLA) for Performance Defined? Do You Have a Database Service Level Agreement (SLA) for Availability Defined? Current State of Data Quality When Some Sort of Database SLA is Defined Data Naming Conventions and Data Quality Ability to Actually Address Database Design Problems Time to Rename a Column Renaming a Column by Org Size Database Refactoring Capability and Data Quality Database Testing Do You Test Your DB? When are You Testing? Types of Testing Types of Database Testing (% Respondents) Database Testing and Data Quality Data Modeling When Do You Data Model on App Dev Projects? Types of Structural Modeling on App Dev Projects When Do You Data M