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 112
- Downloads 0
Determining the Efficient Structure of Feed-Forward Neural Network to Classify Breast Cancer Dataset
Classification is one of the most frequently encountered problems in data mining. A classification problem occurs when an object needs to be assigned in predefined classes based on a number of observed attributes related...
SOHO: Information Security Awareness in the Aspect of Contingency Planning
This paper seeks to take general security awareness information for home and small business owners and make it understandable and accessible by looking at practical ways to keep valuable information accessible after an i...
Strategic Planning towards Automation of Fiber To The Home (FTTH) Considering Optic Access Network (OAN) Model
With the intention to meet the increasing demand of future higher bandwidth applications, fiber based Gigabit Passive Optical Network (GPON) access is considered best resolution to deliver triple play services (voice, da...
Clustering based Max-Min Scheduling in Cloud Environment
Cloud Computing ensures Service Level Agreement (SLA) by provisioning of resources to cloudlets. This provisioning can be achieved through scheduling algorithms that properly maps given tasks considering different heuris...
Quality Ranking Algorithms for Knowledge Objects in Knowledge Management Systems
The emergence of web-based Knowledge Management Systems (KMS) has raised several concerns about the quality of Knowledge Objects (KO), which are the building blocks of knowledge expertise. Web-based KMSs offer large know...