Applying Genetic Algorithms to Test JUH DBs Exceptions
Journal Title: International Journal of Advanced Computer Science & Applications - Year 2013, Vol 4, Issue 7
Abstract
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.
Authors and Affiliations
Mohammad Alshraideh, Ezdehar Jawabreh, Basel Mahafzah, Heba Harahsheh
Keywords
Related Articles
- EP ID EP93419
- DOI 10.14569/IJACSA.2013.040702
- Views 111
- Downloads 0
Image Sharpness Metric Based on Algebraic Multi-grid Method
In order to improve Mean Square Error of its reliance on reference images when evaluating image sharpness, the no-reference metric based on algebraic multi-grid is proposed. The proposed metric first reconstructs the ori...
Passenger and Luggage Weight Monitoring System for Public Transport based on Sensing Technology: A Case of Zambia
The prevalence of overloading, which is exceeding the maximum load weight, on public buses in Zambia is very rampant because there is currently no system to measure and monitor load weight at bus stations, apart from wei...
An Innovative Cognitive Architecture for Humanoid Robot
Humanoid robot is appearing as most popular research tool and emerging research field. The greatest challenge in the development of robot is cognition, advancement and the understanding in the human like cognition. Human...
An Efficient Method For Multichannel Wireless Mesh Networks With Pulse Coupled Neural Network
Multi cast communication is a key technology for wireless mesh networks. Multicast provides efficient data distribution among a group of nodes, Generally sensor networks and MANETs uses multicast algorithms which...
Performance Analysis of Security Mechanism for Automotive Controller Area Network
Connectivity of modern cars has led to security issues. A number of contributions have proposed the use of cryptographic algorithms in order to provide automotive Controller Area Network (CAN) security. However, due to C...