Design of Database on North Shore of Dianchi Lake Based on Oracle and ArcSDE and Its Application
YANG Min,XU Xiao-mei,ZHOU Hong-bin,HE Jia,ZHANG Li-ping,LI Wei,WANG Li
DOI: https://doi.org/10.3969/j.issn.1003-6504.2013.07.034
IF: 11.4
2013-01-01
Environmental Science & Technology
Abstract: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.