Improving of computing systems efficiency based on genetic optimization of SQL-queries for databases
Keywords:
computing systems, efficiency, sql, optimization, genetic algorithmsAbstract
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.References
1. Optimizing SELECT and Other Statements // Reference Manual for the MySQL Database System, v. 5.1. — Режим дос-тупу: http://dev.mysql.com/doc/refman/5.0/en/query-speed.html.
2. Оптимизация производительности баз данных для Web. / Ахмед Абуалсемид // Библиотека Интернет Индустрии I2R.ru. — Режим доступу: www.i2r.ru/static/480/out_11207.shtml.
3. Ротштейн А. П. Интеллектуальные технологии в идентификации / А. П. Ротштейн. — Винница: Універсум– Вінниця, 1999, — 300 c.
2. Оптимизация производительности баз данных для Web. / Ахмед Абуалсемид // Библиотека Интернет Индустрии I2R.ru. — Режим доступу: www.i2r.ru/static/480/out_11207.shtml.
3. Ротштейн А. П. Интеллектуальные технологии в идентификации / А. П. Ротштейн. — Винница: Універсум– Вінниця, 1999, — 300 c.
Downloads
-
PDF (Українська)
Downloads: 67
Abstract views: 126
Published
2010-11-12
How to Cite
[1]
Y. V. Shabatura, I. M. Shtelmakh, and M. Y. Shabatura, “Improving of computing systems efficiency based on genetic optimization of SQL-queries for databases”, Вісник ВПІ, no. 1, pp. 41–46, Nov. 2010.
Issue
Section
Information technologies and computer sciences
License
Authors who publish with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).
