In: Computer Science
Topic: Database testing techniques
Write a research paper on this topic but task is that i write just
scope of this paper
Brief Idea (not more than 200 words): Define scope of your
project
List of papers which u take (Minimum of 8 paper at least 4 papers
after 2016)
Kindly provide some research paper which are related with my
topic
Database Testing Techniques
Database is the collection interrelated data on a server , storing information which is not duplicate .
Which results in the implementation and integration errors while dealing with the large databases , which indirectly effect in the sytem performance .
So , their is a need of testing the database in regular intervals which satisfies the ACID properties ( Atomicity , Consistency , Isolation , Durability ) .
The main layer of the database is the data access layer , and the testing of database is done in this layer and push some data testing strategies such as quality control and quality assurance .
Testing is important as to maintain the consistency of database .
For example , if we are inserting or deleting the data without prior testing , then it will lead in the crash of database .
Database can be done in 3 ways .
1) Structural Database Testing
2) Functional Testing
3) Nonfunctional Testing
1) Structural Database Testing :
In this testing the part which is not exposed the end user is tested .
It involves all the components of repository , which are usedto store the data and are not changed by the end user .
It deals with table and column testing, schema testing, stored procedures and views testing, checking triggers, etc.
2) Functional Testing :
Functional testing is based on the point of view of end user .
i.e, the required operations that are being able to handle or not by the end users mmet their business needs .
Functional testing is of 2 types , white box and black box testing .
Black box testing :
Black Box Testing involves verifying the integration of database to check the functionality. The test cases are simple and are used to verify incoming data and outgoing data from the function.
White box testing :
White Box Testing deals with the internal structure of the database and the specification details are hidden from the users. It involves the testing of database triggers and logical views, which are going to support database refactoring.
3) Nonfunctional Testing :
Nonfunctional testing involves performing load testing, stress testing, checking minimum system requirements to meet business specification, risk finding and performance optimization of database.
Load Testing :
The primary target of load testing is to check if most running transactions have performance impact on the database.
Stress Testing :
Stress testing is performed to identify the system breakpoint. In this testing, application is loaded in such a way that the system fails at one point. This point is called the breakpoint of database system.