eprintid: 12169 rev_number: 2 eprint_status: archive userid: 1 dir: disk0/00/01/21/69 datestamp: 2023-11-10 03:26:43 lastmod: 2023-11-10 03:26:43 status_changed: 2023-11-10 01:17:03 type: article metadata_visibility: show creators_name: Abubakar Imam, A. creators_name: Basri, S. creators_name: Ahmad, R. creators_name: González-Aparicio, M.T. title: Literature Review on Database Design Testing Techniques ispublished: pub keywords: Application programs; Computer software selection and evaluation; Database systems; Durability; Query processing; Testing, Conference articles; Literature reviews; Nosql database; Software applications; Software Quality; Software testing techniques; SQL database; Testing technique, Software testing note: cited By 1; Conference of 8th Computer Science On-line Conference, CSOC 2019 ; Conference Date: 24 April 2019 Through 27 April 2019; Conference Code:225859 abstract: 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. date: 2019 publisher: Springer Verlag official_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 id_number: 10.1007/978-3-030-19807-7₁ full_text_status: none publication: Advances in Intelligent Systems and Computing volume: 984 pagerange: 1-13 refereed: TRUE isbn: 9783030198060 issn: 21945357 citation: 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. ISSN 21945357