Overview of Database Testing
Posted By : Kunal Sharma | 31-Dec-2017
As the number of internet users
What is Database and how to test it?
Database Testing is the process in which we test the SQL queries, database functions, triggers and hence validate the database tables, data models
It is the most common misconception about testing that it is the process of validating the information which is limited to front-end only whereas testing is also a process which involves validating every bit of data that is entered by the end user at the back-end or database.
Even though testing of UI and database are performed at the same time and they go hand in hand, they have different testing procedures.
What is the need for
AS we all know that there
1. Data Mapping: As we know that data is sent to the server from client side to retrieve, store or update information and then the data is sent back from
i. Mapping of data by the user at
ii. If the user has updated data from UI,
2. ACID Properties Validation: ACID properties are the properties of
i. Atomicity: Atomicity is typically referred to as "All or Nothing" rule as in database a transaction can either Pass or Fail but there cannot be any state where the data is partially updated.
ii. Consistency: Whenever any data transaction is done at UI, it should always have a valid entry in database
iii. Isolation: If multiple transactions are done on the database simultaneously, the state of the database should not get changed and it should remain consistent.
iv. Durability: Once a transaction is successful, then the data should not get impacted
3. Data Integrity: User interface should always show the latest information whenever the data is modified by any CRUD operation. Test cases in database testing should be written in such a way that they should validate the consistency of data on each and every screen.
4. Business Rule Conformance: There can be some complicated components like constraints, triggers etc which are basically referred as
How
The most crucial part while testing the database is to know how to start
1. Preparing the Test Environment: The first step would be to prepare a test environment where the tester can perform tests. This environment should
2. Running the Test: There should be both positive and negative test cases for every operation on the database for validating the CRUD operations on the application. After performing
3. Verifying the Test Results: It is nothing but looking into the results of SQL queries which we have hit on the database.
4. Validate: In this step, we validate whether the correct tables or columns are populated
5. Reporting the Findings: Actual and Expected results are shared with the project manager or business analyst and bugs are reported if there are some differences between the actual and expected result.
Thanks!
Cookies are important to the proper functioning of a site. To improve your experience, we use cookies to remember log-in details and provide secure log-in, collect statistics to optimize site functionality, and deliver content tailored to your interests. Click Agree and Proceed to accept cookies and go directly to the site or click on View Cookie Settings to see detailed descriptions of the types of cookies and choose whether to accept certain cookies while on the site.
About Author
Kunal Sharma
Kunal is a bright QA Engineer with skills in Manual and Automation Testing.