分布式数据库系统的查询优化技术研究

数据库数据量日益增多,造成了用户在使用数据库系统查询时费时费力,传统的查询优化方式已无法满足如今的数据查询要求,提高数据库系统优化的效率也成为计算机研究工作的热点。提出基于半连接算法的分布式查询处理技术对数据库系统进行查询优化,提出半连接操作的查询优化算法(SDD-1),并采用实验分析的方法进行验证,计算查询算法的代价。结果表明,基于半连接的研究策略的分布式数据库查询优化可以显著降低传输代价,使查询总效率得到有效提高。

Research on Query Optimization Technology of Distributed Database System

The increasing amount of data in the database makes it time-consuming and laborious for users to query using the database system. The traditional query optimization method has been unable to meet the requirements of today's data query, thus improving the efficiency of database system optimization has become a hot spot of research. In this paper, the distributed query processing tech- nology based on the semi join algorithm is proposed to optimize the database system. This paper selects the semi join algorithm to optimize the algorithm design, proposes the semi join operation query optimization algorithm (SDD-1), and verifies it by experiment to calculate the cost of the query algorithm. The results show that the query optimization strategy can significantly reduce the trans- mission cost and improve the overall efficiency of query.