SQL Optimization in Oracle using Hybrid Genetic and Ant Colony Algorithm

Authors

  • Rajan Kusi Department of Electronics and Computer, Institute of Engineering, Pulchowk Campus, Lalitpur
  • Kabir Kumar Sinkemana Nepal College of Information Technology, Balkumari, Lalitpur
  • Sanjeeb Prasad Pandey Department of Electronics and Computer, Institute of Engineering Pulchowk Campus, Lalitpur
  • Shashidhar Ram Joshi Department of Electronics and Computer, Institute of Engineering Pulchowk Campus, Lalitpur

DOI:

https://doi.org/10.3126/njst.v21i2.62353

Keywords:

Ant Colony, Genetic, SQL, Query Optimization, Query Execution plan

Abstract

In this paper, the input user Structured Query Language (SQL) query is converted into an optimized SQL query using a hybrid algorithm. The main aim is to reduce query execution time using PHP language and oracle database. These performance has been evaluated using different performance metrics: Cost of individuals, Query execution time. The hybrid algorithm method combines the evolutionary effect of the Genetic Algorithm (GA) and the cooperative effect of Ant Colony Optimization (ACO). A GA with a great global converging rate aims to produce an initial optimum for allocating initial pheromones of ACO. An ACO with great parallelism and effective feedback is then served to obtain the optimal solution. A fused algorithm of a GA and ACO to solve SQL optimization problems is an innovative solution that presents a clear methodological contribution to the optimization algorithm. In the simulation result, we found the algorithm of a GA and ACO to solve SQL optimization problems in Oracle. It is an innovative solution that presents a clear methodological contribution to the optimization algorithm.

Downloads

Download data is not yet available.
Abstract
116
PDF
152

Downloads

Published

2022-12-31

How to Cite

Kusi, R., Sinkemana, K. K. ., Pandey, S. P., & Joshi, S. R. (2022). SQL Optimization in Oracle using Hybrid Genetic and Ant Colony Algorithm. Nepal Journal of Science and Technology, 21(2), 21–28. https://doi.org/10.3126/njst.v21i2.62353

Issue

Section

Articles