基于ArcSDE的DEM空间数据库的设计与实现
|
摘要
数字高程模型(DEM)是进行三维分析的核心数据,其在诸多领域起着辅助设计与决策的作用。随着多尺度DEM数据的急剧增多,要求对DEM数据进行高效存储与管理,同时对DEM数据的安全、快速、实时的多用户访问提出了要求,空间数据库的管理模式是适应这种要求的最佳解决方案。对多尺度DEM数据库内容进行了详细分析;通过对空间数据库技术的各类方案进行对比,选用ArcSDE for SQL Server进行建库工作,实现了空间数据与属性数据的统一存储;采用Arc Engine(AE)开发方式开发了数据库管理系统,并以实验地区的DEM数据库系统建设为例,完成了数据库基本操作功能模块的开发与设计,实现了各类数据的查询、浏览和管理功能。
Digital elevation model(referred to as DEM) is core data of three-dimensional analysis,which in many areas of design and decision-making plays an auxiliary role.DEM data and the current scale type and increasing the amount of data on the DEM data storage management have become increasingly demanding,but also the functions of security of data,rapid,real-time,multi-user access were required,so the spatial database management system the best solution is to adapt to this request.Spatial database technology comprise of three main points:Spatial data model is the core of spatial database,and at the same time it is the basis of other technology of spatial database;Spatial index which is the clue of spatial data query based on spatial data model;spatial data query language provides a method of spatial data accessing and operation.With the combination of these three areas,the traditional relational database extended to spatial databases,and also makes it possible to deal with complex spatial data easily and flexibly.In accordance with different scales in different parts of the building DEM database,the text database content is included in a detailed analysis;through comprising various types of spatial database technology programs,selecting ArcSDE for SQL Server technology building a database,the spatial data and attribute data in unified storage were realized;Arc Engine(AE) development methods were used to develop a database management system,and taking some areas of the DEM database systems as an example,the database development and function design has been finished,implementation the various types of the data query,browsing and management were realized.
Digital elevation model(referred to as DEM) is core data of three-dimensional analysis,which in many areas of design and decision-making plays an auxiliary role.DEM data and the current scale type and increasing the amount of data on the DEM data storage management have become increasingly demanding,but also the functions of security of data,rapid,real-time,multi-user access were required,so the spatial database management system the best solution is to adapt to this request.Spatial database technology comprise of three main points:Spatial data model is the core of spatial database,and at the same time it is the basis of other technology of spatial database;Spatial index which is the clue of spatial data query based on spatial data model;spatial data query language provides a method of spatial data accessing and operation.With the combination of these three areas,the traditional relational database extended to spatial databases,and also makes it possible to deal with complex spatial data easily and flexibly.In accordance with different scales in different parts of the building DEM database,the text database content is included in a detailed analysis;through comprising various types of spatial database technology programs,selecting ArcSDE for SQL Server technology building a database,the spatial data and attribute data in unified storage were realized;Arc Engine(AE) development methods were used to develop a database management system,and taking some areas of the DEM database systems as an example,the database development and function design has been finished,implementation the various types of the data query,browsing and management were realized.
引文
[1]熊丽华,杨峰.基于ArcSDE的空间数据库技术的应用研究[J].计算机应用,2004,24(3):90-96.
[2]范志坚.基于ArcSDE for Oracle的1:1万基础地理信息空间数据库的设计与实现[D].昆明:昆明理工大学,2006.
[3]胡仪员.基于ArcSDE for Oracle的地震灾害紧急救援队数据库系统建设[D].成都:西南交通大学,2008.
[4]ESRI.Understanding_ArcSDE[M].ESRIPress,2004.
[5]傅俊,刘南,刘仁义.实现ArcSDE向Oracle9iSpatial空间数据的转换[J].计算机应用,2003,(12):99-101.
[6]ESRI.ArcSDE_guide_Sqlserver[M].ESRIPress,2004.
[7]ESRI.Building_a_Geodatabase[M].ESRIPress,2004.
[8]ESRI.ArcSDE_Config_GD_Oracle[M].ESRIPress,2004.
[9]叶乘鸾.基于ArcSDE的佛山市地下管网空间数据库的研究和设计[D].长沙:中南大学,2005.
[10]Kenward T,Lettenmaier D P,Wood E F,eta l.Effects of digit-al elevation model accuracy on hydrologic predictions[J].RemoteSensing of Environment,2000,74(3):432-444.
[2]范志坚.基于ArcSDE for Oracle的1:1万基础地理信息空间数据库的设计与实现[D].昆明:昆明理工大学,2006.
[3]胡仪员.基于ArcSDE for Oracle的地震灾害紧急救援队数据库系统建设[D].成都:西南交通大学,2008.
[4]ESRI.Understanding_ArcSDE[M].ESRIPress,2004.
[5]傅俊,刘南,刘仁义.实现ArcSDE向Oracle9iSpatial空间数据的转换[J].计算机应用,2003,(12):99-101.
[6]ESRI.ArcSDE_guide_Sqlserver[M].ESRIPress,2004.
[7]ESRI.Building_a_Geodatabase[M].ESRIPress,2004.
[8]ESRI.ArcSDE_Config_GD_Oracle[M].ESRIPress,2004.
[9]叶乘鸾.基于ArcSDE的佛山市地下管网空间数据库的研究和设计[D].长沙:中南大学,2005.
[10]Kenward T,Lettenmaier D P,Wood E F,eta l.Effects of digit-al elevation model accuracy on hydrologic predictions[J].RemoteSensing of Environment,2000,74(3):432-444.
版权所有：© 2023 中国地质图书馆 中国地质调查局地学文献中心