Journal of Software Engineering and Applications

Volume 6, Issue 2 (February 2013)

ISSN Print: 1945-3116   ISSN Online: 1945-3124

Google-based Impact Factor: 1.22  Citations  h5-index & Ranking

Using Genetic Algorithm as Test Data Generator for Stored PL/SQL Program Units

HTML  Download Download as PDF (Size: 394KB)  PP. 65-73  
DOI: 10.4236/jsea.2013.62011    5,406 Downloads   10,421 Views  Citations

ABSTRACT

PL/SQL is the most common language for ORACLE database application. It allows the developer to create stored program units (Procedures, Functions, and Packages) to improve software reusability and hide the complexity of the execution of a specific operation behind a name. Also, it acts as an interface between SQL database and DEVELOPER. Therefore, it is important to test these modules that consist of procedures and functions. In this paper, a new genetic algorithm (GA), as search technique, is used in order to find the required test data according to branch criteria to test stored PL/SQL program units. The experimental results show that this was not fully achieved, such that the test target in some branches is not reached and the coverage percentage is 98%. A problem rises when target branch is depending on data retrieved from tables; in this case, GA is not able to generate test cases for this branch.

Share and Cite:

M. Alshraideh, B. Mahafzah, H. Salman and I. Salah, "Using Genetic Algorithm as Test Data Generator for Stored PL/SQL Program Units," Journal of Software Engineering and Applications, Vol. 6 No. 2, 2013, pp. 65-73. doi: 10.4236/jsea.2013.62011.

Cited by

[1] Integrated multistage supply chain inventory model of multiple retailers with imperfect production and inspection systems
Soft Computing, 2022
[2] A Comprehensive Review Of Software Testing Methodologies Based On Search-Based Software Engineering
Webology (ISSN: 1735-188X), 2022
[3] Hybrid harmony search algorithm for social network contact tracing of COVID-19
2021
[4] AFSA-WOA Variants for Enhanced Global Optimization
2021
[5] Medical Content Processing in Intelligent System of District Therapist.
IDDM, 2020
[6] Mutation operators for Genetic Programming using Monte Carlo Tree Search
2020
[7] Humpback whale optimization algorithm based on vocal behavior for task scheduling in cloud computing
2019
[8] Paper_48-Sea_Lion_Optimization. pdf
2019
[9] Sea Lion Optimization Algorithm
2019
[10] manuscript-v3-i3-99-190. pdf
2019
[11] A Genetic Algorithm Based Feature Selection for Handwritten Digit Recognition
2019
[12] A Fusion Algorithm of Gravitational Search and Tabu Search
2019
[13] A memetic grouping genetic algorithm for cost efficient VM placement in multi-cloud environment
Cluster Computing, 2019
[14] Most valuable player algorithm for solving minimum vertex cover problem
International Journal of …, 2019
[15] Performance evaluation of meta-heuristics in energy-aware real-time scheduling problems
2016
[16] A review of applications of search based software engineering techniques in last decade
2016
[17] Brain Images Classifier: A Hybrid Approach Using Decision Trees and Genetic Algorithms
Journal of Next Generation Information Technology, 2016
[18] PERFORMANCE EVALUATION OF META-HEURISTICS IN ENERGY AWARE REAL-TIME SCHEDULING PROBLEMS
2016
[19] Model Based Test Case Generation and Optimization Using Intelligent Optimization Agent
Information Systems Design and Intelligent Applications, 2015
[20] Multiple-Population Genetic Algorithm for Solving Min-Max Optimization Problems
2015
[21] Analysis of meta-heuristics performance in energy aware scheduling of real-time embedded systems
Applied Electrical Engineering and Computing Technologies (AEECT), 2015 IEEE Jordan Conference on, 2015
[22] Multi-objective Ranking based Non-Dominant Module Clustering
International Journal of Innovative Research in Science, Engineering and Technology, 2014
[23] The genetic algorithm optimize computing applications in computer network reliability analysis
2014
[24] BRANCH COVERAGE TESTING USING ANTI-RANDOM TECHNIQUE.
HJ HASAN, MA ALSHRAIDEH, BA MAHAFZAH - Journal on Software Engineering, 2013
[25] A FRAMEWORK FOR TEST DATA GENERATORS ANALYSIS
ECONOMIC COMPUTATION AND ECONOMIC CYBERNETICS STUDIES AND RESEARCH, 2013
[26] Applying Genetic Algorithms to Test JUH DBs Exceptions
International Journal of Advanced Computer Science & Applications, 2013
[27] Branch Coverage Testing Using Anti-Random Technique
i-Manager's Journal on Software Engineering, 2013
[28] A FRAMEWORK FOR TEST DATA GENERATORS ANALYSIS.
… Computation & Economic Cybernetics Studies & …, 2013

Copyright © 2024 by authors and Scientific Research Publishing Inc.

Creative Commons License

This work and the related PDF file are licensed under a Creative Commons Attribution 4.0 International License.