Applying Genetic Algorithms to Test JUH DBs Exceptions

Database represents an essential part of software applications. Many organizations use database as a repository for large amount of current and historical information. With this context testing database applications is a key issue that deserves attention. SQL Exception handling mechanism can increase the reliability of the system and improve the robustness of the software. But the exception handling code that is used to respond to exceptional conditions tends to be the source of the systems failure. It is difficult to test the exception handling by traditional methods. This paper presents a new technique that combines mutation testing and global optimization based search algorithm to test exceptions code in Jordan University Hospital (JUH) database application. Thus, using mutation testing to speed the raising of exception and global optimization technique in order to automatically generate test cases, we used fitness function depends on range of data related to each query. We try to achieve the coverage of three types of PL/SQL exceptions, which are No_Data_Found (NDF), Too_Many_Rows (TMR) and Others exceptions. The results show that TMR exception is not always covered this due to existence of primary key in the query, also uncovered status appear in nested exceptions.

@article{Alshraideh2013,
  title     = {Applying Genetic Algorithms to Test JUH DBs Exceptions},
  journal   = {International Journal of Advanced Computer Science and Applications},
  volume    = {4},
  number    = {7},
  year      = {2013},
  publisher = {The Science and Information Organization},
  author    = {Mohammad Alshraideh and Ezdehar Jawabreh and Basel A. Mahafzah and Heba M. AL Harahsheh},
  doi       = {10.14569/IJACSA.2013.040702},
  url       = {https://doi.org/10.14569/IJACSA.2013.040702}
}