QUERY OPTIMIZATION BY GENETIC ALGORITHM
Journal Title: Международный научный журнал "Интернаука" - Year 2016, Vol 1, Issue 6
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
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...