QUERY OPTIMIZATION BY GENETIC ALGORITHM

Abstract

Genetic Algorithms are a powerful search technique based on the mechanics of natural selection and natural genetics that are used successfully to solve problems in many different disciplines. In this paper we present genetic algorithms in one of the most important optimization problems in computer science, database query optimization for large join query. Current query optimization techniques are inadequate to support some of the emerging database application. In this paper, we outline a database query optimization problem and describe the adaptation of genetic algorithm. And comparison between simple SQL queries having five join and same query using genetic approach. And also give basic overview of the Carquinyoli Genetic Optimizer based on Genetic Programming.

Authors and Affiliations

Pavlo Sevidov

Keywords

Related Articles

DIDACTIC BASES OF DEVELOPMENT OF CRETIVE ABILITIES OF FUTURE ARCHITECTS DURING THEIR EDUCATION DESCRIPTIVE GEOMETRY

The work is dedicated to the effectiveness of instructional techniques gradual transformation amateurish way of thinking of the future architects in the beginning of his system in the study of descriptive geometry, which...

DIRECTIONS OF IMPROVING THE ORGANIZATIONAL COMPONENT OF THE STATE-PRIVATE PARTNERSHIP IN UKRAINE

In the article the peculiarities of formation and development of public-private partnership in Ukraine, and justifies the conceptual framework of the PPP in the activity of subjects of economy of Ukraine.

DESIGNING THE PLANT FOR OBTAINING OF PETROLEUM VAPORS FROM GASOLINE STAND

Capture the vapors from gasoline station by condensation with solar cooling plant is offered.

FORMATION OF FUTURE SPECIALISTS IN AUTOMOBILE AND ROAD BRANCH OF POSITIVE MOTIVATION TO IMPLEMENTATION OF PROFESSIONAL AND PERSONAL SELF-DEVELOPMENT

In article the author pays attention of influence of positive motivation to professional and personal self-development of future specialists in automobile and road branch. It is certain that professional and personal sel...

PEDAGOGICAL IMAGEOLOGY THE DEPENDENCE OF THE FORMATION OF SUCCESSFUL PROFESSIONAL IMAGE OF THE TEACHER

In the article the aspects of introduction of imidzheologii are considered as a component of educational process in higher educational establishments. Essence and functions of concepts of image is exposed and pedagogical...

Download PDF file
  • EP ID EP235861
  • DOI -
  • Views 96
  • Downloads 0

How To Cite

Pavlo Sevidov (2016). QUERY OPTIMIZATION BY GENETIC ALGORITHM. Международный научный журнал "Интернаука", 1(6), 106-112. https://europub.co.uk/articles/-A-235861