Database Testing: Lookout for ACID-ity

The concept of performing ACID testing on Databases have been theoretically emphasized over the years, but I have often noticed that this dimension is not an evident driver when it comes to strategizing testing of application.

Testers these days have failed to look beyond the conventional classroom wisdom imparted about software testing. The testing for ACID properties is highly essential for any system/application that has a back end.

Conventional test strategies emphasize on achieving 100% test coverage. This will provide proof for functional correctness of the system. Post deployment when a system encounters real user/transactional volumes you may be surprised to find crashes, inconsistencies of data served. These can be traced to overlooking the testing of ACID properties.

For those of you who are wondering whats the concept this would be a good place to start looking: http://en.wikipedia.org/wiki/ACID

The crux of the matter lies in incorporating sections to include strategies to test for acidity and translate that to specific test cases to target these scenarios.
Post a reply to gain further insights into ACID testing…

If you enjoyed this post, make sure you subscribe to my RSS feed!

Related posts