Database testing – Data Quality

As I was saying…

One overlooked area is probably data quality testing.

In fact, from some of the schema designs I’ve seen over the years, I’m sure it is.
Notably in missing primary/foreign/unique keys and other constraints.

To what extent can or should we be testing whether the implementation of a data model enforces the rules, relationships and constraints that it should?

Can any “is”/”has” statements be validated against it?

How should we best go about this?

And are there any tools that can help us do this?

This is definitely needed. And it’s not just one off testing either, because data models evolve constantly and we want to check that a release does not degrade the quality of our data – that
a dropped unique key/index is OK, that a relaxed constraint does not compromise our data.

Aptly, when doing a bit of searching just earlier, I noted that Scott Ambler was
writing about testing the very same


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: