摘要
针对滇池北岸排水系统与污染源信息数据库的需求,以ArcSDE空间引擎作为中间插件,建立北岸属性数据与空间数据统一存储于面向对象的关系型数据库(Oracle 11g)。在设计的基础上,实现北岸基础数据库的快速查询、分析、编辑等功能,提高数据存储和管理,为其他数据管理平台及用户提供访问接口。同时,文章通过实例展示了此数据库技术在应用系统开发中的实用性和可操作性。该数据库的设计与开发为流域管理和决策者提供了科学的决策依据,并有助于提高相关工作者的管理效率。
To meet the demand of constructing sewage and drainage systems and creating a pollution source information database in the watershed of the north shore of Dianchi Lake in Kunming city,an object-oriented/relational database（Oracle 11g）was set up by use of ArcSDE spatial engine as an intermediate plug-in.This paper elaborated on design process of the database and the realization of the functions such as fast query,analysis,editing,data storage,all the data related to the north shore of Dianchi Lake,the data management,as well as access to the other data management platform and user interface.Applications of the database enumerated in this paper included the connection of attribute data with spatial data,presentation of various data,e.g.pollution sources,drainage system and river system of the watershed,data query/analysis,and statistical analysis of attribute data and analysis of spatial data.With design and development of the database,the managerial staff are provided with a scientific decision-making tool which will lend help to efficient management of the watershed.
出处
《环境科学与技术》
CAS
CSCD
北大核心
2013年第7期168-171,194,共5页
Environmental Science & Technology
基金
国家水体污染控制与治理科技重大专项滇池项目(2009ZX07102-002)
