遗传算法和实时数据库规则结合的数据库查询优化方案设计

Design of Database Query Optimization Scheme Based on Genetic Algorithm and Real Time Database Rules

数据库的建立是实现各种类型事务查询的关键。由于现有的查询处理系统无法满足实时数据库的需求,所以让数据库系统拥有自己的查询处理器非常重要。本文将针对嵌入式实时数据系统ERTDBMS进行分析,建立一个实时数据查询RTQP处理系统,之后探讨实时数据查询处理相关内容,重点分析遗传算法和内存代价。就是基础MMDB环境下建立的RTQP关系系统实现查询处理,将实时数据库功能和遗传算法相结合建立的优化方案[1]。

The establishment of database is the key to realize all kinds of transaction queries.Since the existing query processing system can not meet the needs of real-time database,it is very important for the database system to have its own query processor.This paper analyzes the embedded real-time data system ERTDBMS,establishes a real-time data query RTQP processing system,and then discusses the related content of real-time data query processing,genetic selective analysises algorithm and memory cost.It is the RTQP relation system based on the basic MMDB environment to realize query processing,and combines the real-time database function with the genetic algorithm to establish the optimization scheme.