A Hybrid Swarm Intelligence Model for Efficient Query Optimization in Distributed Databases Using Genetic and Ant Colony Algorithms

Optimisation of queries in distributed databases is more imperative to enhance the processing rate and use of resources with limited computational abilities. This work presents a novel GA-ACO hybrid swarm intelligence model to address the query optimization problem. The optimization effort of the proposed model starts with GA for an initial population of probable paths for query execution which uses the concept of evolution to select diverse solutions. After that, ACO strengthens this set by the application of pheromone-based reinforcement that allows adjusting of a query paths toward the best solution or its approximation with the following number values. In this way the enhancement of the convergence rates and the scalability of the proposed solution when distributed databases are used can be explained. The model was tested with artificial query logs with DEAP being used for the implementation of the genetic algorithm while ant colony operations were implemented using Python built ACO libraries. Performance analysis shows the success of the developed model in decreasing query response time as follows: This essentially complex hybrid mechanism shows potential for future use in other areas with large data sets and efficient query handling.