Database Testing

 

Database Testing
 
At Sapple Systems, we believe in providing an all round testing – both front end and backend. We use common quality techniques for data inspection tools to examine existing data within a database. You might use something as simple as a SQL-based query tool to select a subset of the data within a database to visually inspect the results. For example, you may choose to view the unique values in a column to determine what values are stored in it, or compare the row count of a table with the count of the resulting rows from joining the table with another one. If the two counts are the same then you don't have an RI problem across the join.
 
Data inspection is more of a debugging technique than it is a testing technique. It is clearly an important technique, but it's not something that will greatly contribute to your efforts to ensure data quality within your organization.