Analysis of query efficiency of forest resources database system

ZHANG Mao-zhen; TANG Xiao-ming; XIE Yang-sheng; DING Li-xia

PDF
Cite
Share

facebook

twitter

google

linkedin

Volume 26 Issue 2

Apr. 2009

Turn off MathJax

Article Contents

Article Navigation > Journal of Zhejiang A&F University > 2009 > 26(2): 149-154

ZHANG Mao-zhen, TANG Xiao-ming, XIE Yang-sheng, DING Li-xia. Analysis of query efficiency of forest resources database system[J]. Journal of Zhejiang A&F University, 2009, 26(2): 149-154.

Citation:

ZHANG Mao-zhen, TANG Xiao-ming, XIE Yang-sheng, DING Li-xia. Analysis of query efficiency of forest resources database system[J]. Journal of Zhejiang A&F University, 2009, 26(2): 149-154.

Analysis of query efficiency of forest resources database system

1.
School of Environmental Science and Technology，Zhejiang Forestry College，Lin’an 311300，Zhejiang，China;
2.
Research Institute of Fores Resource Information Techniques，The Chinese Academy of Forestry，Beijing 100091，China

More Information

Corresponding author: ZHANG Mao-zhen
Publish Date: 2009-04-20

Abstract

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.］
- forest management,
- forest resources,
- database system,
- query optimization

Relative Article

[1]	ZHU Chenghao, WANG Jianwu, XIE Binglou, WU Xiaonan, LUO Yibo. City-county synchronized assessing and accuracy control of forest ecosystem services . Journal of Zhejiang A&F University, 2022, 39(2): 430-437. doi: 10.11833/j.issn.2095-0756.20210328
[2]	ZHANG Shujing, TANG Lihua, ZHAO Kai. Dynamic relationship between forest resources and forestry industry: an empirical analysis based on environmental Kuznets curve model . Journal of Zhejiang A&F University, 2018, 35(5): 885-891. doi: 10.11833/j.issn.2095-0756.2018.05.013
[3]	MO Qin, CHEN Zhibo, XIE Shiqin, CHEN Mingjian, XIA Chaozong. Developing a system for monitoring high resolution forestry ecological projects . Journal of Zhejiang A&F University, 2017, 34(4): 737-742. doi: 10.11833/j.issn.2095-0756.2017.04.021
[4]	LAI Chao, FANG Luming, LI Ji, ZHOU Changhe. Design and implementation of an integrated forest resources information system . Journal of Zhejiang A&F University, 2015, 32(6): 890-896. doi: 10.11833/j.issn.2095-0756.2015.06.010
[5]	WANG Xue, BAI Jiang-li, LI Chen, LIN Pei-yan. Construction criteria framework of forest resources management information system . Journal of Zhejiang A&F University, 2010, 27(1): 116-120. doi: 10.11833/j.issn.2095-0756.2010.01.019
[6]	WANG Bin, YANG Xiao-sheng, ZHANG Biao, LIU Mou-cheng. Dynamics of ecosystem services in China during 1973 - 2003 . Journal of Zhejiang A&F University, 2009, 26(5): 714-721.
[7]	ZENG -wei, LI Guang-hui, HU Hai-gen, TANG Jian-feng. Design and implementation of personal digital assistant （PDA） based information collection system for forest resources . Journal of Zhejiang A&F University, 2009, 26(1): 111-115.
[8]	ZHANG Mao-zhen, TANG Xiao-ming, WANG Ya-xin, ZHANG Huai-qing, WU Dong-liang. Oracle DBMS based forest resources spatial database storage . Journal of Zhejiang A&F University, 2008, 25(4): 411-416.
[9]	WUDa-sheng, FANG Lu-ming, XUAi-jun. Development of forest resources transfer office system . Journal of Zhejiang A&F University, 2007, 24(2): 130-134.
[10]	BAI Jiang-li, PENG Dao-li, YANG Fu-ning. Information classification and code of forest resources . Journal of Zhejiang A&F University, 2007, 24(3): 326-330.
[11]	GE Wen-ning. Alteration of property right of state-owned forest in Zhejiang Province . Journal of Zhejiang A&F University, 2006, 23(3): 338-341.
[12]	LIU An-xing. Design of dynamic forest resources monitoring system of Zhejiang Province . Journal of Zhejiang A&F University, 2005, 22(4): 449-453.
[13]	CAI Liang-liang, CAI Xia, ZHU Hong-wei. Problems and solutions in the implementation of forest resources dynamic information system at the county level . Journal of Zhejiang A&F University, 2004, 21(2): 228-230.
[14]	WU Da-sheng, FANG Lu-ming, TANG Li-hua, LIU Li-juan. Discussion of XML in heterogeneous data integration of forest resources management information systems . Journal of Zhejiang A&F University, 2003, 20(4): 403-407.
[15]	LOU Tao, WEI Xin-liang, LIN Xiang-jian, TANG Mei-qin, YE Zhu-hui. Effect and mechanism of forest resource utilization innovation . Journal of Zhejiang A&F University, 2002, 19(1): 63-67.
[16]	Wu Yanxiong, Zhou Guomo, Guo Renjian. Early-warning analysis on regional forest resources sustainable development . Journal of Zhejiang A&F University, 1999, 16(1): 55-60.
[17]	Wu Yanxiong, Chen Meilan, Zhou Guomo, Guo Renjian. Probing into synthetic appraisal of regional forest resources . Journal of Zhejiang A&F University, 1999, 16(1): 80-84.
[18]	Wu Yanxiong, Zhou Guomo, Guo Renjian. ActiveX and its application in regional forest resources early warning technical system . Journal of Zhejiang A&F University, 1999, 16(1): 100-106.
[19]	Wu Yanxiong, Zhou Guomo, Guo Renjian. Three new views on regional forest resources system . Journal of Zhejiang A&F University, 1999, 16(1): 34-40.
[20]	Fang Luming. Necessity and Feasibility to Study and Establish the Microcomputer Management System of Forest Reserves for County Standard in Zhejiang . Journal of Zhejiang A&F University, 1993, 10(2): 209-215.

References
Proportional views

通讯作者: 陈斌, bchen63@163.com

1.
沈阳化工大学材料科学与工程学院沈阳 110142

Get Citation

PDF

XML

Article views(4428) PDF downloads(150) Cited by()

Proportional views

Analysis of query efficiency of forest resources database system

1. School of Environmental Science and Technology，Zhejiang Forestry College，Lin’an 311300，Zhejiang，China;

2. Research Institute of Fores Resource Information Techniques，The Chinese Academy of Forestry，Beijing 100091，China

Corresponding author: ZHANG Mao-zhen

Publish Date: 2009-04-20

Key words:

Abstract: 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.］

ZHANG Mao-zhen, TANG Xiao-ming, XIE Yang-sheng, DING Li-xia. Analysis of query efficiency of forest resources database system[J]. Journal of Zhejiang A&F University, 2009, 26(2): 149-154.

Citation:

ZHANG Mao-zhen, TANG Xiao-ming, XIE Yang-sheng, DING Li-xia. Analysis of query efficiency of forest resources database system[J]. Journal of Zhejiang A&F University, 2009, 26(2): 149-154.

HTML

DownLoad: Full-Size Img PowerPoint

Return

Analysis of query efficiency of forest resources database system

Abstract

References

Proportional views

通讯作者: 陈斌, bchen63@163.com

Related

Proportional views

Analysis of query efficiency of forest resources database system

1. School of Environmental Science and Technology，Zhejiang Forestry College，Lin’an 311300，Zhejiang，China;

2. Research Institute of Fores Resource Information Techniques，The Chinese Academy of Forestry，Beijing 100091，China

Corresponding author: ZHANG Mao-zhen

HTML

Catalog

Analysis of query efficiency of forest resources database system

Abstract

Relative Article

References

Proportional views

通讯作者: 陈斌, bchen63@163.com

Related

Proportional views

Analysis of query efficiency of forest resources database system

1. School of Environmental Science and Technology，Zhejiang Forestry College，Lin’an 311300，Zhejiang，China; 2. Research Institute of Fores Resource Information Techniques，The Chinese Academy of Forestry，Beijing 100091，China

Corresponding author: ZHANG Mao-zhen

HTML

Catalog

Export File

Citation

Format

Content

1. School of Environmental Science and Technology，Zhejiang Forestry College，Lin’an 311300，Zhejiang，China;

2. Research Institute of Fores Resource Information Techniques，The Chinese Academy of Forestry，Beijing 100091，China