Comparative experimental analysis for capacities of spatial database

Abstract

Abstract: As an important way to manage spatial data, spatial database is one core component of the GIS. After introducing the basic concepts and the history of spatial database, the performance of managing spatial data is discussed. In order to analyse the capacities that include feature class loading efficiency, features inserting efficiency and spatial computing efficiency, three experiments are designed and applied to compare these capacities.

Key words: spatial database, spatial index, spatial computing, ArcSDE, Structured Query Language（SQL） server spatial, oracle spatial, Geographic Information System（GIS）

摘要： 空间数据库是管理空间数据的重要方式，亦是GIS的重要组成部分。介绍了空间数据库的概念和发展历程，分析了影响空间数据库性能的因素，进而探讨了图层加载、要素插入和空间计算等应用性能，设计了三组空间数据库的操作实验，对目前常用的几种空间数据库管理空间数据的性能进行了对比分析。

关键词: 空间数据库, 空间索引, 空间计算, ArcSDE, SQL Server空间数据库, oracle spatial, 地理信息系统

XIAO Qiuyong, LI Guangqiang. Comparative experimental analysis for capacities of spatial database[J]. Computer Engineering and Applications, 2014, 50(21): 139-142.

肖邱勇，李光强. 空间数据库性能对比实验分析[J]. 计算机工程与应用, 2014, 50(21): 139-142.

[1]	YANG Zexue. Research on hybrid index structure in spatial database [J]. Computer Engineering and Applications, 2017, 53(20): 20-23.
[2]	CHU Longxian1，3, LI Xiaoying2，3, CHEN Xu3, CHU Chunjie4. Vector data index method supporting efficient parallel compute [J]. Computer Engineering and Applications, 2017, 53(11): 79-84.
[3]	CHEN Jing, WANG Xiaodong, HUANG Biao, DING Jiaxin. Approach for offset curves computation from boundaries on map with bounded error [J]. Computer Engineering and Applications, 2016, 52(6): 235-241.
[4]	ZHOU Yi1, YANG Zexue1，2. Research on line segment kNN query in spatial database [J]. Computer Engineering and Applications, 2015, 51(18): 131-134.
[5]	LIAO Zhifang1, PENG Yanni1, LI Yong1, ZHAO Ying2. AirVis：Web-based visualization analysis system for air quality data [J]. Computer Engineering and Applications, 2015, 51(15): 174-178.
[6]	ZHANG Liping1, LI Song1, HAO Xiaohong2, HAO Zhongxiao1. Simple continues near neighbor chain query with increase and decrease of obstacles [J]. Computer Engineering and Applications, 2015, 51(11): 99-103.
[7]	XU Hongbo1，2, YAO Nianmin2, HAN Qilong2, PAN Haiwei2. Index structure CB-tree supporting line query [J]. Computer Engineering and Applications, 2015, 51(11): 114-118.
[8]	WANG Jingbin. Optimization algorithm for R-tree combining with spatial-clusting [J]. Computer Engineering and Applications, 2014, 50(5): 112-115.
[9]	WU Chaohui1, ZHANG Hanfei2, GONG Maoyu1. Efficient viewshed computation on terrain in external memory [J]. Computer Engineering and Applications, 2014, 50(12): 48-53.
[10]	KOU Weili1，2, GAN Shu1, WANG Dandan1. Title design and implementation of model for agricultural land grading based on ArcGIS Engine/ArcSDE [J]. Computer Engineering and Applications, 2012, 48(6): 238-242.
[11]	LIN Jian, LIU Renyi, LIU Nan, ZHANG Feng. New distributed spatial query optimization approach by using query analyzer [J]. Computer Engineering and Applications, 2012, 48(22): 161-165.
[12]	ZHANG Shiliang1, YE Bixiong2, XIAO Shouzhong3. Prediction UGB based on integration of GIS/RS and radial basis function network [J]. Computer Engineering and Applications, 2012, 48(20): 227-231.
[13]	WANG Jingbin, MIAO Youmeng, PENG Zhixing. Twig pattern query algorithm over GML document [J]. Computer Engineering and Applications, 2012, 48(19): 150-156.
[14]	FENG Wenzhao, PENG Liqin, LI Wei, ZHANG Sumei. New approach for line（s） object buffer construction in GIS [J]. Computer Engineering and Applications, 2012, 48(17): 80-87.
[15]	HE Xinguang，NIE Xinyan，QIN Jianxin，XIA Weisheng. Design and realization of visual multiscale numerical simulation system for groundwater flow [J]. Computer Engineering and Applications, 2011, 47(8): 226-231.

Comparative experimental analysis for capacities of spatial database

空间数据库性能对比实验分析

PDF

Knowledge

Abstract

Cite this article

share this article

References

Related Articles 15

Recommended Articles

Metrics