Oracle DBMS based forest resources spatial database storage

ZHANG Mao-zhen; TANG Xiao-ming; WANG Ya-xin; ZHANG Huai-qing; WU Dong-liang

Volume 25 Issue 4

Aug. 2008

Turn off MathJax

Article Contents

Article Navigation > Journal of Zhejiang A&F University > 2008 > 25(4): 411-416

ZHANG Mao-zhen, TANG Xiao-ming, WANG Ya-xin, ZHANG Huai-qing, WU Dong-liang. Oracle DBMS based forest resources spatial database storage[J]. Journal of Zhejiang A&F University, 2008, 25(4): 411-416.

Citation:

ZHANG Mao-zhen, TANG Xiao-ming, WANG Ya-xin, ZHANG Huai-qing, WU Dong-liang. Oracle DBMS based forest resources spatial database storage[J]. Journal of Zhejiang A&F University, 2008, 25(4): 411-416.

Oracle DBMS based forest resources spatial database storage

1.
School of Environmental Science and Technology, Zhejiang Forestry College, Lin’an 311300， Zhejiang, China;
2.
Research Institute of Resources Information, The Chinese Academy of Forestry, Beijing 100091, China;
3.
School of Tourism, Beijing Union University, Beijing 100101, China

More Information

Corresponding author: ZHANG Mao-zhen
Publish Date: 2008-08-20

Abstract

To cope with the system efficiency problems caused by mass-data and the centralized management in the forest resources database, the paper analyzed the spatial data management mechanism of ArcSDE spatial engine and worked out the optimization strategies for Oracle DBMS based spatial database system from four perspectives including database design, DBMS configuration, ArcSDE configuration and database maintenance. The provincial level forest resources spatial database of Fujian Province was taken as an example to validate the main optimization strategies. The results indicated that the rational adjustment of the parameters of DBMS and ArcSDE engine（Oracle SGA size, ArcSDE index size and MAXBUFSIZE）, optimization of the database design and adoption of the middle table technique could all improve the query efficiency significantly. For optimizing forest resources database, efficient logical database structure and distributed physical database structure should both be considered. ［Ch, 5 fig. 1 tab. 12 ref.］
- forest management,
- ArcSDE,
- Oracle DBMS,
- spatial database,
- system optimization

Relative Article

[1]	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
[2]	CHEN Dong, WU Baoguo, LIU Jiancheng, LU Yuanchang. Design and implementation of forest management knowledge service system based on frame representation . Journal of Zhejiang A&F University, 2017, 34(3): 491-500. doi: 10.11833/j.issn.2095-0756.2017.03.015
[3]	LIU Jiancheng, WU Baoguo, CHEN Dong. Research and construction of web crawler based forest management knowledge collection system . Journal of Zhejiang A&F University, 2017, 34(4): 743-750. doi: 10.11833/j.issn.2095-0756.2017.04.022
[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]	ZHOU Keyu, XU Aijun, LI Huixia, XIA Kai. Design and implementation of the forestry data acquisition system . Journal of Zhejiang A&F University, 2015, 32(4): 491-496. doi: 10.11833/j.issn.2095-0756.2015.04.001
[6]	SHEN Zhenming, WANG Yixiang, WU Tianhang, PAN Weihua, TONG Zhipeng, ZHANG Huafeng. A target tree management assistant decision-making system based on GIS . Journal of Zhejiang A&F University, 2013, 30(5): 633-639. doi: 10.11833/j.issn.2095-0756.2013.05.001
[7]	REN Junjun, FANG Luming, TANG Lihua. Design and stability of a forestry field information collection system . Journal of Zhejiang A&F University, 2013, 30(2): 234-239. doi: 10.11833/j.issn.2095-0756.2013.02.012
[8]	WANG Ni, PENG Shi-kui, LI Ming-shi. High-resolution remote sensing of textural images for tree species classification . Journal of Zhejiang A&F University, 2012, 29(2): 210-217. doi: 10.11833/j.issn.2095-0756.2012.02.010
[9]	HU Yun, FANG Lu-ming. A method of avoiding crack for compressing polygon data by topological data conversion . Journal of Zhejiang A&F University, 2011, 28(4): 597-600. doi: 10.11833/j.issn.2095-0756.2011.04.012
[10]	HUANG Shui-sheng, XIE Yang-sheng, TANG Xiao-ming, WANG Jin-zeng. Research and implementation of cooperative information system for forest and greening inventory in Beijing . Journal of Zhejiang A&F University, 2011, 28(6): 884-892. doi: 10.11833/j.issn.2095-0756.2011.06.008
[11]	WANG Yi-xiang, CHEN Yong-gang, TANG Meng-ping, HONG Min, CHEN Hai-feng, CHEN De-hu. A plugin analysis system for forest spatial structure based on GIS and .NET . Journal of Zhejiang A&F University, 2011, 28(5): 720-726. doi: 10.11833/j.issn.2095-0756.2011.05.006
[12]	LIU Xiao-shuang, HUANG Jian-wen, JU Hong-bo. Research progress in the methods and applications of individual tree crown’s automatic extraction by high spatial resolution remote sensing . Journal of Zhejiang A&F University, 2010, 27(1): 126-133. doi: 10.11833/j.issn.2095-0756.2010.01.021
[13]	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
[14]	LI Yi-ping, XU Ai-jun, YANG Shao-qin. Research on key technologies of GIS-based low hilly woodland management system . Journal of Zhejiang A&F University, 2009, 26(4): 554-560.
[15]	ZHANG Guang-qun, WANG Bao-ping, WANG Hang-jun. MapX-based processing of spatial data inconsistent problems . Journal of Zhejiang A&F University, 2009, 26(4): 587-591.
[16]	BEY-FANANIE Fauzan Mulia, ZHOU Guo-mo, CHIRKO Charles. A GIS-based information system for forest resource management in Parung Panjang Forest Farm，Indonesia . Journal of Zhejiang A&F University, 2009, 26(3): 375-383.
[17]	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.
[18]	ZHANG Mao-zhen, TANG Xiao-ming, XIE Yang-sheng, DING Li-xia. Analysis of query efficiency of forest resources database system . Journal of Zhejiang A&F University, 2009, 26(2): 149-154.
[19]	WU Da-sheng, HUANG Mei-li, CHEN Fei. Integration of distributed data of timber transportation licence . Journal of Zhejiang A&F University, 2006, 23(4): 435-438.
[20]	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.

References
Proportional views

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

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

Get Citation

PDF

XML

Article views(5606) PDF downloads(266) Cited by()

Proportional views

Oracle DBMS based forest resources spatial database storage

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

2. Research Institute of Resources Information, The Chinese Academy of Forestry, Beijing 100091, China;

3. School of Tourism, Beijing Union University, Beijing 100101, China

Corresponding author: ZHANG Mao-zhen

Publish Date: 2008-08-20

Key words:

Abstract: To cope with the system efficiency problems caused by mass-data and the centralized management in the forest resources database, the paper analyzed the spatial data management mechanism of ArcSDE spatial engine and worked out the optimization strategies for Oracle DBMS based spatial database system from four perspectives including database design, DBMS configuration, ArcSDE configuration and database maintenance. The provincial level forest resources spatial database of Fujian Province was taken as an example to validate the main optimization strategies. The results indicated that the rational adjustment of the parameters of DBMS and ArcSDE engine（Oracle SGA size, ArcSDE index size and MAXBUFSIZE）, optimization of the database design and adoption of the middle table technique could all improve the query efficiency significantly. For optimizing forest resources database, efficient logical database structure and distributed physical database structure should both be considered. ［Ch, 5 fig. 1 tab. 12 ref.］

Oracle DBMS based forest resources spatial database storage

Abstract

References

Proportional views

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

Related

Proportional views