• Post Reply Bookmark Topic Watch Topic
  • New Topic

SQL Amtipatterns smoketests?  RSS feed

 
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.
 
Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!