BT

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

by Scott Ambler on May 22, 2006 |

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.

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.

Tell us what you think

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

Email me replies to any of my messages in this thread
Community comments

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

Email me replies to any of my messages in this thread

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

Email me replies to any of my messages in this thread

Discuss

Educational Content

General Feedback
Bugs
Advertising
Editorial
InfoQ.com and all content copyright © 2006-2014 C4Media Inc. InfoQ.com hosted at Contegix, the best ISP we've ever worked with.
Privacy policy
BT