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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Tsumura, K., Washizaki, H., Fukazawa, Y., Oshima, K., Mibe, R.: Pairwise coverage-based testing with selected elements in a query for database applications. In: 2016 IEEE Ninth International Conference on Software Testing, Verification and Validation Workshops, pp. 92–101 (2016)
Inflectra, B.: Software Testing Methodologies (2016). https://www.inflectra.com/Ideas/Topic/Testing-Methodologies.aspx. Accessed 01 Jan 2016
Reza, H., Zarns, K.: Testing relational database using SQLLint. In: Proceedings - 2011 8th International Conference on Information Technology: New Generations, ITNG 2011, pp. 608–613 (2010)
Sree, U.: Software Testing Life Cycle: Defects and Bugs (2016). https://olaiainforarch.wordpress.com/. Accessed 11 July 2016
Berger, D., Fröhlich, P.: Software testing techniques. Power Point Lecture, 20 pages (2016)
Marin, M.: A data-agnostic approach to automatic testing of multi-dimensional databases. In: Proceedings of - IEEE 7th International Conference on Software Testing, Verification and Validation, ICST 2014, pp. 133–142 (2014)
Ron, A., Shulman-Peleg, A., Puzanov, A.: Analysis and mitigation of NoSQL injections. IEEE Secur. Priv. 14(2), 30–39 (2016)
Chan, M.Y., Cheung, S.C.: Testing database applications with SQL semantics. In: Proceedings of 2nd International Symposium on Cooperative Database Systems for Advanced Applications, March, pp. 363–374 (1999)
Hamlin, A., Herzog, J.: A test-suite generator for database systems (2014)
Setiadi, R., Lau, M.F.: Identifying data inconsistencies using after-state database testing (ASDT) framework. In: Proceedings of the International Conference on Quality Software, pp. 105–110 (2014)
Zou, J.: Research and application of testing technology of the cloud computing database. In: Proceedings - 2014 IEEE Workshop on Electronics, Computer and Applications, IWECA 2014, pp. 699–702 (2014)
Sarkar, T., Basu, S., Wong, J.: IConSMutate: concolic testing of database applications using existing database states guided by SQL mutants. In: Proceedings of 11th International Conference on Information Technology: New Generations, ITNG 2014, pp. 479–484 (2014)
Setiadi, R., Lau, M.F.: A structured model of consistency rules in After-State Database Testing. In: 38th IEEE International Computer Software and Applications Conference Workshops, no. 2, pp. 650–655 (2014)
Grechanik, M., Hossain, B.M.M., Buy, U.: Testing database-centric applications for causes of database deadlocks. In: Proceedings - IEEE 6th International Conference on Software Testing, Verification and Validation, ICST 2013, vol. 191242, pp. 174–183 (2013)
Pan, K., Wu, X., Xie, T.: Automatic test generation for mutation testing on database applications. In: 8th International Workshop on Automation of Software Test (AST), pp. 111–117 (2013)
McCormick II, D.W., Frakes, W.B., Anguswamy, R., McCormick, D.W.: A comparison of database fault detection capabilities using mutation testing. In: 2012 ACM-IEEE International Symposium on Empirical Software Engineering and Measurement (ESEM), pp. 323–326 (2012)
Gonzalez-Aparicio, M.T., Younas, M., Tuya, J., Casado, R.: A new model for testing CRUD operations in a NoSQL database. In: 2016 IEEE 30th International Conference on Advanced Information Networking and Applications (AINA), vol. 6, pp. 79–86 (2016)
Bhogal, J., Choksi, I.: Handling big data using NoSQL. In: Proceedings - IEEE 29th International Conference on Advanced Information Networking and Applications Workshops, WAINA 2015, pp. 393–398 (2015)
Truica, C.O., Radulescu, F., Boicea, A., Bucur, I.: Performance evaluation for CRUD operations in asynchronously replicated document oriented database. In: Proceedings - 2015 20th International Conference on Control Systems and Computer Science, CSCS 2015, pp. 191–196 (2015)
Klein, J., Gorton, I., Ernst, N., Donohoe, P., Pham, K., Matser, C.: Performance evaluation of NoSQL databases: a case study. In: Proceedings of the 1st Workshop on Performance Analysis of Big Data Systems, pp. 5–10 (2015)
Abramova, V., Bernardino, J., Furtado, P.: Testing cloud benchmark scalability with cassandra. In: 2014 IEEE World Congress on Services, pp. 434–441 (2014)
Naheman, W.: Review of NoSQL databases and performance testing on HBase. In: 2013 International Conference on Mechatronic Sciences, Electric Engineering and Computer, pp. 2304–2309 (2013)
Cai, L., Huang, S., Chen, L., Zheng, Y.: Performance analysis and testing of HBase based on its architecture. In: IEEE 12th International Conference on Computer and Information Science (ICIS), 2013 IEEE/ACIS, pp. 353–358 (2013)
Henry, K.: Database System Concepts. Macgraw-Hill, New York (2010)
Silberschatz, S., Korth, Sudarshan: Database System Concept: Homogeneous Distributed Databases. Cent. Wiskd. Inform., pp. 19.3–19.125 (2007)
Abramova, V., Bernardino, J.: NoSQL databases: MongoDB vs cassandra. In: Proceedings of the International C* Conference on Computer Science and Software Engineering ACM 2013, pp. 14–22 (2013)
Brewer, E.: CAP twelve years later: how the ‘rules’ have changed. Comput. (Long. Beach. Calif) 45(2), 23–29 (2012)
Acknowledgment
This paper/research was fully supported by Ministry of Higher Education Malaysia, under the Fundamental Research Grant Scheme (FRGS) with Ref. No. FRGS/1/2018/ICT04/UTP/02/04.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2019 Springer Nature Switzerland AG
About this paper
Cite this paper
Abubakar Imam, A., Basri, S., Ahmad, R., González-Aparicio, M.T. (2019). Literature Review on Database Design Testing Techniques. In: Silhavy, R. (eds) Software Engineering Methods in Intelligent Algorithms. CSOC 2019. Advances in Intelligent Systems and Computing, vol 984. Springer, Cham. https://doi.org/10.1007/978-3-030-19807-7_1
Download citation
DOI: https://doi.org/10.1007/978-3-030-19807-7_1
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-030-19806-0
Online ISBN: 978-3-030-19807-7
eBook Packages: Intelligent Technologies and RoboticsIntelligent Technologies and Robotics (R0)