Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQL Amtipatterns smoketests?

 
Steve Robillard
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Bill,

Do you have a set of smoke tests designed to alert developers/DBA's to the use of these anti patterns or is it all a matter of learning them and manually detecting/avoiding them?

Thanks,
Steve
 
Bill Karwin
author
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Steve,

Yes, in each chapter of "SQL Antipatterns" I wrote a short section on How to Recognize the Antipattern. Most of these give hypothetical quotes you might hear from your team mates.

For example:
This database is totally extensible without metadata changes. You can define new attributes at runtime.

This is a clue that the database is probably designed with the Entity-Attribute-Value antipattern. The rest of the chapter describes what exactly can go wrong when the antipattern is used, and how to design your database to avoid the antipattern.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic