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 69
- Downloads 0
Web and Telco Service Integration: A Dynamic and Adaptable Approach
The current evolution of the Web, known as Web 2.0 and characterized by providing a diverse global service ecosystem, has marked a change in the role played by telecom operators. In order to maintain high competitive mar...
A Machine Learning Approach for Predicting Nicotine Dependence
An examination of the ability of machine learning methodologies in classifying women Waterpipe (WP) smoker’s level of nicotine dependence is proposed in this work. In this study, we developed a classifier that predicts t...
Testing the Use of the Integrated Model in Designing the Management Information Systems by Using the Mathematical Probability Theories
The integrated model is a new model that is recently developed to decrease from the classical approach weaknesses and problems in building the management information systems (MIS’s) that are used to solve the management...
Crypt-Tag Authentication in NFC Implementation for Medicine Data Management
This study focus on the implementation of expiry date detection for medicine using RFID in the health care industry. The motivation for doing this research is the process of searching for the expired medicine is a time c...
A Hybrid Framework using RBF and SVM for Direct Marketing
One of the major developments in machine learning in the past decade is the ensemble method, which finds highly accurate classifier by combining many moderately accurate component classifiers. This paper addresses using...