基于数据库查询过程优化设计

在大型关系数据库管理与开发中,优化设计极大地提高数据库的性能。通过对一大型数据库查询语句执行过程的讨论,提出了对同一表格进行多个选择运算的优化、多个表格的选择运算的优化、多个表格的联结兼选择运算的优化、应用窗口优化和索引优化设计方法,经实际应用验证,其优化过程简便、有效,可达到减少计算量和内存需求,提高了查询响应的速度,极大地改善数据库性能,具有较强的实用性。

Introducing an Optimized Design in Database Query Process

In the management and development of large-scaled database, optimized design can improve its functions greatly. According to the discussion on performing query language of a large-scaled database, the authors propose an optimized design-optimizing multi-choice operation on the same form, choice operation on multi-forms, connection & choice operation on multi -forms, the using window and index. In practical application, the process of optimization, which is simple and effective, can decrease the amount of counting and internal storage, can speed up query execution and performance and has a stronger usage.