Facilitating the spread of knowledge and innovation in professional software development



Choose your language

InfoQ Homepage News Database Regression Testing: Isn't It Time to Bring Quality to Data Management?

Database Regression Testing: Isn't It Time to Bring Quality to Data Management?


In Database Regression Testing I argue that databases are often a central part of the overall information technology infrastructure with most organizations. Although developers and database administrators (DBAs) may argue over whether it is the best way to build systems, a fact of life is that mission-critical business functionality is often implemented in stored procedures and triggers within the database. The importance of your databases is further exemplified by the fact that data is an important corporate asset. Clearly your organization should have a realistic regression testing strategy in place to ensure the quality of both your databases and the data within them. Your organization does have such a strategy, doesn't it?

My experience is that database testing must be performed at two levels: Internally within the database itself and at the interface level where you put data into the database and retrieve it from the database. Both categories of testing are crucial to your success.  DB regression testing helps to improve data quality and enables evolutionary database development techniques such as database refactoring.

We need your feedback

How might we improve InfoQ for you

Thank you for being an InfoQ reader.

Each year, we seek feedback from our readers to help us improve InfoQ. Would you mind spending 2 minutes to share your feedback in our short survey? Your feedback will directly help us continually evolve how we support you.

Take the Survey

Rate this Article


Hello stranger!

You need to Register an InfoQ account or or login to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Community comments

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p


Is your profile up-to-date? Please take a moment to review and update.

Note: If updating/changing your email, a validation request will be sent

Company name:
Company role:
Company size:
You will be sent an email to validate the new email address. This pop-up will close itself in a few moments.