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 115
- Downloads 0
An Efficient Design of RPL Objective Function for Routing in Internet of Things using Fuzzy Logic
The nature of the Low power and lossy networks (LLNs) requires having efficient protocols capable of handling the resource constraints. LLNs consist of networks that connect different type of devices which has constraint...
Object Conveyance Algorithm for Multiple Mobile Robots based on Object Shape and Size
This paper describes a determination method of a number of a team for multiple mobile robot object conveyance. The number of robot on multiple mobile robot systems is the factor of complexity on robots formation and moti...
Insights on Error-Resilient Image Transmission Schemes on Wireless Network
Usage of image as data (or signal) is quite frequent in majority of the user-centric application. However, transmission of image over non-concrete communication medium like air is still vulnerable due to inherent weaknes...
Circular Calibration of Depth Extraction in Stereo Configuration
Lens distortion is defined as departure from rectilinear projection of an imaging system which affects the accuracy of almost all vision applications. This work addresses the problem of distortion with investigating the...
Performance Testing, and Evaluation for the Voipv6 Network Related Functions, (Sendto and Receivefrom)
(The network related functions (Sendto, and Receivefrom) in VoIPv6, are needed to obtain the communication socket in both UDP, and TCP before the communication can take place between the sending and receiving ends. The i...