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
Keywords
Related Articles
- EP ID EP235861
- DOI -
- Views 99
- Downloads 0
ОПТИМИЗАЦИЯ РЕЖИМОВ ЭЛЕКТРИЧЕСКИХ СЕТЕЙ ПО НАПРЯЖЕНИЯМ УЗЛОВ
В статье предложен эффективный алгоритм оптимизации режимов электрических сетей по напряжениям узлов с регулируемыми реактивными мощностями. Приведены результаты исследования вычислительных качеств описанного алгоритма.
HYBRID RECOMMENDER SYSTEM BASED ON USER MEDIA PREFERENCES
Covering main problems and managing their solving methods on the base on creating the hybrid recommender system with using the data about user media preferences.
INTEREST IN THE ANGLO-AMERICAN SYSTEM OF LAW
The article explores the concept and types of legal interests in the Anglo-Saxon legal system. In particular, interests in property law and contract law are analyzed. The legal interest in the Anglo-Saxon legal system ca...
RESEARCH OF SODIUM CARBOXYMETHYLCELLULOSE ON THE HYDRATION PROPERTIES OF GLUTEN-FREE DOUGH
The theoretical and practical aspects of sodium carboxymethylcellulose on the hydration properties of gluten-free dough are investigated. Increased moisture retaining ability of the dough was established during the heat...
THE USA BORDER PROTECTION SPECIALISTS’ VOCATIONAL TRAINING DEVELOPMENT STAGES
The article deals with the investigation of vocational training development stages of the specialists in the field of the USA Border protection. The retrospective analysis of its establishing was conducted. The article s...