Prediction of Software Development Faults in PL/SQL Files using Genetic Nets
نویسنده
چکیده
Database applications constitute one of the largest and most important software domains in the world. Some classes or modules in such applications are responsible for database operations. Structured Query Language (SQL) is used to communicate with database middleware in these classes or modules. It can be issued interactively or embedded in a host language. This paper aims to predict the software development faults in PL/SQL files using SQL metrics. Based on actual project defect data, the SQL metrics are empirically validated by analyzing their relationship with the probability of fault detection across PL/SQL files. SQL metrics were extracted from Oracle PL/SQL code of a warehouse management database application system. The faults were collected from the journal files that contain the documentation of all changes in source files. The result demonstrates that these measures may be useful in predicting the fault concerning with database accesses. In our study, genetic net is used to evaluate the capability of this set of SQL metrics in predicting the number of faults in database applications. This genetic net combines a genetic algorithm with a statistical estimator to produce a model which also shows the usefulness of respective inputs. Key-Words: SQL Metrics, Software Prediction, Genetic Net, Software Metrics
منابع مشابه
Prediction of software development faults in PL/SQL files using neural network models
Database application constitutes one of the largest and most important software domains in the world. Some classes or modules in such applications are responsible for database operations. Structured Query Language (SQL) is used to communicate with database middleware in these classes or modules. It can be issued interactively or embedded in a host language. This paper aims to predict the softwa...
متن کاملAn Improved Approach for Generating Configuration Files from a Database
Much of our site configuration information is stored in a relational database, which means we need to extract this information in the appropriate format for servers and daemons. In the past we have done this with lots of little custom C programs and scripts. We have recently changed to a new approach of generating the files within the database itself using PL/SQL packages, and then using a gene...
متن کاملVerification of Logs - Revealing Faulty Processes of a Medical Laboratory
If there is a suspicion of Lyme disease, a blood sample of a patient is sent to a medical laboratory. The laboratory performs a number of di erent blood examinations testing for antibodies against the Lyme disease bacteria. The total number of di erent examinations depends on the intermediate results of the blood count. The costs of each examination is paid by the health insurance company of th...
متن کاملDevelopment of Lifetime Prediction Model of Lithium-Ion Battery Based on Minimizing Prediction Errors of Cycling and Operational Time Degradation Using Genetic Algorithm
Accurate lifetime prediction of lithium-ion batteries is a great challenge for the researchers and engineers involved in battery applications in electric vehicles and satellites. In this study, a semi-empirical model is introduced to predict the capacity loss of lithium-ion batteries as a function of charge and discharge cycles, operational time, and temperature. The model parameters are obtai...
متن کاملUsing Genetic Algorithm as Test Data Generator for Stored PL/SQL Program Units
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 cons...
متن کامل