Research On Technique And Strategy Of Query Optimization On Forest Resources Database

Query is the only method for user to get information from database, as well as the main function of the database application system. In forest resources database, the query efficiency is the main index for the database system performance. Query optimization is a key issue in database system design and its implementation. Based on the application condition of the forest resources database and the features of the data processing, this paper studied the query optimization techniques and the practical methods that suitable for the forest resources database application systems. The study results in the following:(1) The forest resources database system, resulting from the analysis of features and process of data collection, storage, processing and retrieving, belongs to the type of Decision Support System (DSS). Forest database system includes four levels. The user can be divided into 15 groups by administrative section and 56 groups. by functionality. The efficiency in each level and the amount of users are all the factors affecting the query response time. Among them, the huge data size and the inadequate query policy is one of the main factors which caused the low query efficiency.(2)Query optimization can be done by adjusting DBMS parameters,optimizing database design, refining SQL syntax and optimizing source code of the application system. The principle and strategy of the optimization are Forest resources databases. For forest resources databases, which represented here by the second level inventory database, optimization on database design has the greatest potential for increasing the query speed, while the DBMS parameter adjustment has relatively low effect on query optimization, except the user defined cache system.(3)In forest resources database, the logical design and the physical storage of the data has deep impact on query efficiency. Organizing the data according to the subject-oriented...