关系数据库中地理空间数据存储优化研究  

Research on Geospatial Data Storage Optimization in Relational Database

作　　者：李思卓 赵辉 耿晓燕 张颜秋 樊琦 LI Sizhuo;ZHAO Hui;GENG Xiaoyan;ZHANG Yanqiu;FAN Qi(Geodetic Data Processing Centre,Ministry of Natural Resources,Xi′an 710054,China)

机构地区：[1]自然资源部大地测量数据处理中心,陕西西安710054

出　　处：《测绘与空间地理信息》2023年第4期158-161,共4页Geomatics & Spatial Information Technology

摘　　要：针对地理空间数据存储总量增大导致的系统空间查询性能下降的问题,本文详细分析了不同数据的存储特征,将关系数据库的分区技术应用到地理空间数据存储管理系统的存储优化领域。采用合适的分区策略,选择合理的分区键和分区索引来帮助管理大容量的地理空间数据,有效缩短了系统查询的响应时间,对地理空间数据的存储与管理具有优化作用。Aiming at the problem that the spatial query performance of the system decreases due to the increase of the total storage amount of geospatial data,this paper analyzes the storage characteristics of different data in detail and applies the partitioning technology of relational database to the storage optimization of geospatial data storage management system.Using a proper partitioning strategy,selecting the right partitioning keys and partitioning indexes to help manage large volumes of geospatial data,effectively shorten the response time of system query,and optimize the storage and management of geospatial data.

关 键 词：地理空间数据 存储特征 分区技术 存储优化 分区索引 

分 类 号：P208[天文地球—地图制图学与地理信息工程]