Question

In: Computer Science

Topic: Database testing techniques Write a research paper on this topic but task is that i...

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

Solutions

Expert Solution

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.


Related Solutions

Write the scope of research paper about database testing techniques where we provide comparisons with different...
Write the scope of research paper about database testing techniques where we provide comparisons with different techniques. Take 8 research papers ( 4 from 2016) and write a scope through these papers which are selected or downloaded from the web. The main topic is database testing techniques and we have to generate a comparison between these testing techniques and write down a scope.
Choose a topic to write a research paper on. Your topic must be related to any...
Choose a topic to write a research paper on. Your topic must be related to any aspect of childhood development. Some example topics include (but are not limited to): The social, emotional, and cognitive aspects development and growth in _______________ age group The reproductive system The advantages or disadvantages of Preschool The role of genetics in conception Sexual Behavior in adolescence and emerging adults Step 2: Write your research paper. Include: Your research paper should be 4-5 pages in length...
a) Write a proposal of research paper, for the topic below: "The impact of COVID19 on...
a) Write a proposal of research paper, for the topic below: "The impact of COVID19 on the mental health status;(stress & resistance to work), of frontlineir nurses in emergency departments". b) Attach a suggested survey or questionnaire to support this study proposal.
research paper: I need to write a research paper about the importance of the 4 amendment...
research paper: I need to write a research paper about the importance of the 4 amendment and how the search warrants help or hurt the law system. The paper will be no less than 1500 words and have a minimum of 6 academic quality references. The grading rubric for this assignment may be viewed in the Research Paper submission link in Blackboard. o Websites such as Wikipedia, blogs, and social networking forums, are not to be used. Depending on your...
Write a research paper of at least 1500 words on a topic of yourchoice. You...
Write a research paper of at least 1500 words on a topic of your choice. You can select any topic which might be of interest to you provided that you can find the required resources to list in your paper. Your research paper should include the following sections: Introduction Literature Review Methodology Results and Discussion Conclusion References In your research paper you need to follow the APA documentation style to ensure avoiding plagiarism and the correct use of in-text citation...
Select a research paper topic and develop an abstract. Write 150 word topic proposal for your...
Select a research paper topic and develop an abstract. Write 150 word topic proposal for your final project. Your topic needs to focus on a critical challenge in cybersecurity facing National Security Professionals. This challenge can come from technology, policy, international relations, economics, or any of the fields where the digital world brings its effects to bear. Think about recent cybersecurity incidents and events. What research question comes to mind when you think of cybersecurity challenges? Your topic proposals need...
I have a paper to write on the following topic would a price floor such as...
I have a paper to write on the following topic would a price floor such as minimum wage result in a surplus of labor and hence unemployment? two typed pages 12 point font with sources I need help please?
For university, I have to write a Research paper and i want to examine whether there...
For university, I have to write a Research paper and i want to examine whether there is a relationship (correlation)between hours worked in a Country per week and the Happiness Index points as the dependent variable. However, it has to be a mutiple linear regression model but I struggle with finding more independent variables. Can somebody help me here?
Hi! I am having a difficult time thinking of a topic for my research paper if...
Hi! I am having a difficult time thinking of a topic for my research paper if anyone is able to help out that would be appreciated! One challenge is defining a specific topic. For example, the topic "Federal Reserve" is far too broad. Here are considerations and suggestions for you in defining your research topic: 1. Start by review the major topics of the course. See how the textbook is organized, and flip through the various chapters to identify potential...
research paper: each student will be responsible for writing an argumentative research paper discussion a topic...
research paper: each student will be responsible for writing an argumentative research paper discussion a topic that is relevant to the field of management ( The table of contents for our book is a great place to start). this paper will be a minimum of 8 complete papers and maximum of 10.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT