文献类型：期刊文献

中文题名：森林资源数据库系统查询效率分析

英文题名：Analysis of query efficiency of forest resources database system

作者：张茂震[1] 唐小明[2] 谢阳生[2] 丁丽霞[1]

第一作者：张茂震

机构：[1]浙江林学院环境科技学院,浙江临安311300;[2]中国林业科学研究院资源信息研究所,北京100091

年份：2009

卷号：26

期号：2

起止页码：149-154

中文期刊名：浙江林学院学报

外文期刊名：Journal of Zhejiang Forestry College

收录：CSTPCD;;北大核心:【北大核心2008】；CSCD:【CSCD_E2011_2012】；

基金：“十一五”国家科学技术支撑项目(2006BAD23B0204-4);浙江林学院科学研究发展基金资助项目(2006FR058);浙江省林业厅资助项目(07A16)

语种：中文

中文关键词：森林经理学;森林资源;数据库系统;查询优化

外文关键词：forest management; forest resources; database system; query optimization

分类号：S757

摘要：对森林资源数据库系统的查询特点及效率进行了分析,提出了森林资源数据库应用系统的4种应用查询模式及其制约查询效率的关键因素。实例分析证明:数据库管理系统(DBMS)参数配置、数据库逻辑和物理设计、SQL查询表达以及应用程序设计都是影响查询效率的关键因素。改进森林资源数据库系统查询优化应充分考虑不同查询应用模式的特点,分别从不同角度采用不同的优化方法和策略。对于以网络传输为主要特征的浏览查询,查询算法和数据组织是优化的关键;对于计算密集的统计分析查询,则应优先考虑数据库调整和使用中间表、聚簇等措施。
Analyzed the query characteristics and its efficiency on forest resources database system, proposed that all the queries on forest resources database can be divided into 4 types, and showed the key factors affecting the query efficiency for each type. It is evident that DBMS parameters, the logical and physical design of database, the SQL expression, and the application system design are all the key factors affecting the system efficiency. The optimization of forest resources database application system should give full consideration to the characteristics of each query type. The policy should be made according to their query characteristics by choosing different optimizing method from different angle of view. For the type of browsing queries through network, the query algorithm and the data organizing are most important for query optimization. For the type of query of statistics and the analyzing, the priority should be given to database tuning, using of middle table and cluster indexing etc. [Ch, 3 fig. 4 tab. 14 ref.]