A Brief Introduction to Database Testing

DATABASE TESTING: DB testing is also known as backend testing or data testing.DB testing deals in internal process and storage and we used for DB Oracle,SQL Server,MySql etc.In Database, testing tester validates the schema, stored procedures, triggers,database tables and validating data duplication.

Database Testing Validations:

There are the following verifications are carried out during database testing:

• Verify the data Mapping.
• Validate ACID properties (Atomicity, Consistency, Isolation, Durability)
• Validate Data Integrity
• Validate according to Business rules 

Database testing is of three types:

1. Structural Testing

2. Functional testing

3. Non-functional testing

1. Structural Database Testing: In this, the validation of the database server is also very important in these types of testing and testers used for testing SQL queries.

2. Funtional Database Testing: In functional testing testers test the specific requirements to ensure transactions and operations as performed by the end users.

Need full conditions for database validation testing: 

• Verify the field is mandatory while allowing NULL values on that field.
• Verify the length of each field is of sufficient size?
• Verify all similar fields have the same names across tables?
• Verify there are any computed fields present in the Database?

The tester test a particular process to validate the field mappings from the viewpoint of the end-user side.

3.Non-functional Database Testing: Nonfunctional testing in the type of database testing and it can be categorized into various categories according to the business requirements.These are load testing, Stress Testing, Security Testing, Usability Testing, and Compatibility Testing etc.

When an application is under testing, the tester mainly utilizes the ‘CRUD’ operations facilitated by the database Tool.

C: Create – When the tester/user ‘Save’ any new transaction, ‘Create’ operation is performed by the DB.
R: Retrieve – When the tester/user ‘Search’ or ‘View’ any saved transaction in the application, ‘Retrieve’ operation is performed.
U: Update – When the tester/user ‘Edit’ or ‘Modify’ an existing record in the application, the ‘Update’ operation of DB is performed.
D: Delete – When the tester/user ‘Remove’ any record from the application, ‘Delete’ operation of DB is performed.