SQL White Box Testing

by Andrew S
The article talks about how SQL software testing techniques do not address some of the important key features of SQL.  And then goes on to present a set of guidelines for designing white-box tests to exercise the way an SQL query processes its stored data.  White-box testing is a way of testing SQL software in order to check for test-set size and fault detecting ability.  The author claims that the process of writing and testing database queries must have some distinguishing particularities in order to create a thorough testing software.  As a result, there are specific guidelines that must be followed when developing a software testing technique.  These guidelines can help achieve more complete unit tests for queries and be used in the task of writing and testing SQL.

I thought that this article is related to the lecture topics of the week because for an SQL software to be useful and applicable to real time use, it must be thoroughly completed with little or no room for error.  One way to take care of this problem is through SQL white-box testing.  In the article, the author talks about certain guidelines that must be followed to ensure a good SQL software.  He explores the main problems of SQL testing and then goes into detail on how to fix these problems.

I found this article to be very interesting because since we are learning about SQL in class, I thought it was necessary to explore areas in which to find fault and fix these problems.  Since SQL is such a widely used database management system, it is important to know the ins and outs of the program.  This includes making sure that there are no errors when the software is running.  With that in mind, the guidelines in the article can be followed to ensure a complete and fully functional SQL database.

Tuya, J. (2006, April). A Practical Guide to SQL White-Box Testing. ACM Sigplan Newsletter

One thought on “SQL White Box Testing

  • November 11, 2012 at 8:45 pm

    Nice post! We definitely need to take care when building our databases but no matter how careful we are there will always be mistakes as we are human. From reading your post white-box testing seems like a great way to test the databases. Just like it states we need to map out what our tests are going to be that way we know what the results should be.

Comments are closed.