Literature Review on Database Design Testing Techniques

Database driven software applications are becoming more sophisticated and complex. The behavior of these systems solely depends on the data being used. Whereas this data has now become so massive, varyingly connected, distributed, and stored and retrieved with different velocity, era of big data. To...

Full description

Saved in:
Bibliographic Details
Main Authors: Abubakar Imam, A., Basri, S., Ahmad, R., González-Aparicio, M.T.
Format: Article
Published: Springer Verlag 2019
Online Access:https://www.scopus.com/inward/record.uri?eid=2-s2.0-85065887999&doi=10.1007%2f978-3-030-19807-7_1&partnerID=40&md5=d7e686da6680863d5156aecb04054566
http://eprints.utp.edu.my/23642/
Tags: Add Tag
No Tags, Be the first to tag this record!
id my.utp.eprints.23642
record_format eprints
spelling my.utp.eprints.236422021-08-19T08:08:45Z Literature Review on Database Design Testing Techniques Abubakar Imam, A. Basri, S. Ahmad, R. González-Aparicio, M.T. Database driven software applications are becoming more sophisticated and complex. The behavior of these systems solely depends on the data being used. Whereas this data has now become so massive, varyingly connected, distributed, and stored and retrieved with different velocity, era of big data. To make these systems operate in every anticipated environment with the required usability, durability and security, they are subjected to rigorous testing using the available Software Testing Techniques (STT). This test is described as a process of confirming correct behavior of a piece of software which consists of three parts, namely, interface (GUI), back-end (codes) and data-source (database). The purpose of this study is to identify and analyze existing STT in the context of databases design structures. Primary studies related to ST were identified using search terms with relevant keywords. These were classified under journal and conference articles, book chapters, workshops, and symposiums. Out of the search results, 23 Primary studies were selected. Database testing has been significantly discussed in the software testing domain. However, it was discovered that, existing software testing techniques suffer from several limitations which includes: incompatibility with new generation databases, lack of scalability and embedded SQL query detection issues. In addition, application of existing techniques into a full-fledged software system has not been reported yet. © 2019, Springer Nature Switzerland AG. Springer Verlag 2019 Article NonPeerReviewed https://www.scopus.com/inward/record.uri?eid=2-s2.0-85065887999&doi=10.1007%2f978-3-030-19807-7_1&partnerID=40&md5=d7e686da6680863d5156aecb04054566 Abubakar Imam, A. and Basri, S. and Ahmad, R. and González-Aparicio, M.T. (2019) Literature Review on Database Design Testing Techniques. Advances in Intelligent Systems and Computing, 984 . pp. 1-13. http://eprints.utp.edu.my/23642/
institution Universiti Teknologi Petronas
building UTP Resource Centre
collection Institutional Repository
continent Asia
country Malaysia
content_provider Universiti Teknologi Petronas
content_source UTP Institutional Repository
url_provider http://eprints.utp.edu.my/
description Database driven software applications are becoming more sophisticated and complex. The behavior of these systems solely depends on the data being used. Whereas this data has now become so massive, varyingly connected, distributed, and stored and retrieved with different velocity, era of big data. To make these systems operate in every anticipated environment with the required usability, durability and security, they are subjected to rigorous testing using the available Software Testing Techniques (STT). This test is described as a process of confirming correct behavior of a piece of software which consists of three parts, namely, interface (GUI), back-end (codes) and data-source (database). The purpose of this study is to identify and analyze existing STT in the context of databases design structures. Primary studies related to ST were identified using search terms with relevant keywords. These were classified under journal and conference articles, book chapters, workshops, and symposiums. Out of the search results, 23 Primary studies were selected. Database testing has been significantly discussed in the software testing domain. However, it was discovered that, existing software testing techniques suffer from several limitations which includes: incompatibility with new generation databases, lack of scalability and embedded SQL query detection issues. In addition, application of existing techniques into a full-fledged software system has not been reported yet. © 2019, Springer Nature Switzerland AG.
format Article
author Abubakar Imam, A.
Basri, S.
Ahmad, R.
González-Aparicio, M.T.
spellingShingle Abubakar Imam, A.
Basri, S.
Ahmad, R.
González-Aparicio, M.T.
Literature Review on Database Design Testing Techniques
author_facet Abubakar Imam, A.
Basri, S.
Ahmad, R.
González-Aparicio, M.T.
author_sort Abubakar Imam, A.
title Literature Review on Database Design Testing Techniques
title_short Literature Review on Database Design Testing Techniques
title_full Literature Review on Database Design Testing Techniques
title_fullStr Literature Review on Database Design Testing Techniques
title_full_unstemmed Literature Review on Database Design Testing Techniques
title_sort literature review on database design testing techniques
publisher Springer Verlag
publishDate 2019
url https://www.scopus.com/inward/record.uri?eid=2-s2.0-85065887999&doi=10.1007%2f978-3-030-19807-7_1&partnerID=40&md5=d7e686da6680863d5156aecb04054566
http://eprints.utp.edu.my/23642/
_version_ 1738656500954431488
score 13.211869