校园网数据库性能优化技术

校园网中数据库有异构、数据量大、多媒体、查询频繁等特点,怎样实施校园网数据库优化以提高数据库的服务性能,具有非常重要的意义。本文主要是在数据库逻辑设计方面着手,进行优化分析,以使数据库结构设计符合第三范式标准。为了避免密集运用聚集函数,降低数据库多表连接,提出了采用反范式的设计方法,实施采用结构化数据组建的校园网数据库的优化。实践表明,该方法性能良好,操作简单,有效地提升了校园网的数据库性能。

Campus Network Database Performance Optimization Technology

The campus network databases are heterogeneous,large amount of data,multimedia,query frequency and other characteristics,how to implement the campus network database optimization services to improve the database performance,has very important significance.This paper is set in the logical database design,optimization analysis,in order to meet the third normal form database design standards.To avoid the intensive use of aggregate functions,reducing the database multi-table joins,this paper presents the design method using anti-paradigm,the implementation of structured data organized by the campus network database optimization.Experimental results show that the method of switching to good performance,simple operation,effectively improve the campus network of the database performance.