Підвищення ефективності обчислювальних систем на основі генетичної оптимізації sql-запитів до баз даних

Abstract

We consider the problem of increasing the efficiency of computing systems integrated into computer networks in a databases area. The solution based of automatic optimization of SQL-queries in the form of modifying the structure queries using genetic algorithms is suggested. Optimization task is formalized and proposed structural diagram of optimization system is suggested, query object model is elaborated. Genetic algorithm for optimization and its implementation are showed, the results of a pilot study confirming the practical value of the proposed approach are given.