本文關(guān)鍵詞：基于ArcSDE的南流江流域社會生態(tài)系統(tǒng)數(shù)據(jù)庫設(shè)計及應(yīng)用　出處：《廣西師范學院》2016年碩士論文　論文類型：學位論文

  更多相關(guān)文章： 南流江流域 社會生態(tài)系統(tǒng) 數(shù)據(jù)庫設(shè)計 脆弱性評價

【摘要】：自然的運轉(zhuǎn)與人類活動引起的環(huán)境快速變化,引發(fā)了各種環(huán)境變化的同時也導致各種災害的頻繁發(fā)生。除了自然資源面臨的嚴峻考驗,公共資源也面臨的“公地悲劇”的境遇,新的理論社會生態(tài)系統(tǒng)制度分析與框架提出是學者們開辟的一個新路徑,為流域研究提供了跟傳統(tǒng)生態(tài)研究不一樣的新視角。在學術(shù)研究上作為一個新的理論分析視角,根據(jù)框架綜合考慮自然因素和人文社會因素的影響,著重強調(diào)二者之間的交互作用及其對環(huán)境變化的共同驅(qū)動,從這種分析方法出發(fā)去研究流域,幫助人們在政治、社會、經(jīng)濟背景下挖掘社會及生態(tài)中的微觀變量進行分析,去尋找可以讓自然資源長久發(fā)展的因素,不要讓悲劇現(xiàn)在未來發(fā)展中。南流江位于廣西南部,源于大容山并獨自流入北部灣中,它的河流流程長、支流多且涉及流域面積比較廣、水資源量比較豐富。流域的豐富資源使得人類活動頻繁,經(jīng)濟快速發(fā)展,同時經(jīng)濟的發(fā)展帶來的環(huán)境犧牲使得南流江流域環(huán)境污染日益嚴重,為了避免“公地悲劇”的發(fā)生由此引入社會生態(tài)系統(tǒng)可持續(xù)框架,對南流江的環(huán)境治理與經(jīng)濟進一步發(fā)展進行起指導作用。本文結(jié)合南流江綜合管理實際,在社會生態(tài)系統(tǒng)框架指導下,建立南流江流域社會生態(tài)系統(tǒng)數(shù)據(jù)庫。結(jié)合GIS技術(shù)、空間數(shù)據(jù)庫技術(shù)、SQL Server等相關(guān)技術(shù),制定可行性設(shè)計路線。主要研究內(nèi)容包括:(1)理論基礎(chǔ):通過研究分析核心的概念——流域社會生態(tài)系統(tǒng),建立數(shù)據(jù)庫的數(shù)據(jù)分類體系;另一方面研究相關(guān)的數(shù)據(jù)庫關(guān)鍵技術(shù),包括數(shù)據(jù)庫的發(fā)展、空間數(shù)據(jù)庫的發(fā)展與模型、數(shù)據(jù)庫引擎ArcSDE以及關(guān)系數(shù)據(jù)庫系統(tǒng)。(2)從社會生態(tài)系統(tǒng)視角展開數(shù)據(jù)庫的設(shè)計,包括四個階段:需求分析、概念設(shè)計、邏輯設(shè)計、物理設(shè)計,圍繞著服務(wù)對象展開數(shù)據(jù)庫的需求分析,對不同的服務(wù)對象所需數(shù)據(jù)不同進行數(shù)據(jù)分析,采用E-R概念模型進行概念設(shè)計,基于概念設(shè)計進行邏輯分析與設(shè)計,在此基礎(chǔ)上采用Geodatabase模型進行物理設(shè)計。(3)通過ArcGIS平臺以及空間數(shù)據(jù)庫引擎ArcSDE來實現(xiàn)空間數(shù)據(jù)在關(guān)系數(shù)據(jù)庫SQL Server2008中的存儲和管理:數(shù)據(jù)通過處理之后按照流程進行分類入庫,矢量及柵格數(shù)據(jù)通過ArcCatalog實現(xiàn)入庫,其他非空間屬性數(shù)據(jù)通過SQL Server2008的導入功能進行數(shù)據(jù)的入庫,數(shù)據(jù)庫的建立為后續(xù)共享平臺的建設(shè)提供有力的基礎(chǔ)。(4)調(diào)用南流江流域社會生態(tài)系統(tǒng)數(shù)據(jù)庫中的數(shù)據(jù)進行一個簡單的應(yīng)用研究,對流域2005年、2010年、2014年三個時間結(jié)點進行水資源脆弱性評價應(yīng)用研究,得出一個相對的評價結(jié)果,除了合浦縣,大部分地區(qū)脆弱性不存在明顯的變化趨勢,絕大部分處在中脆弱狀態(tài),綜合看來南流江流域正處于中間過度的重要階段。
[Abstract]:The operation of nature and the rapid changes in the environment caused by human activities have led to various environmental changes, but also to the frequent occurrence of various disasters, in addition to the severe test of natural resources. Public resources also face the "tragedy of the Commons" situation, the new theory of social ecosystem system analysis and framework is a new path opened up by scholars. It provides a new angle of view for watershed research, which is different from the traditional ecological research. As a new theoretical analysis perspective in academic research, according to the framework of comprehensive consideration of natural factors and the impact of human and social factors. Emphasis is placed on the interaction between the two and their common drivers of environmental change. From the perspective of this analytical method, the basin is studied to help people in politics and society. Under the economic background excavate the microcosmic variable in the society and the ecology carries on the analysis to look for the factor which can let the natural resources develop for a long time does not let the tragedy present future development. The Nanliu River is located in the south of Guangxi. Originated from Dalong Mountain and flowing into the Beibu Gulf alone, it has a long river flow, many tributaries and a wide range of watershed area, the amount of water resources is relatively rich. The abundant resources in the basin make human activities frequent and economic development fast. At the same time, the environmental sacrifice brought by the economic development makes the environmental pollution of the Nanliu River basin more and more serious. In order to avoid the "tragedy of the common land", the sustainable framework of social ecosystem is introduced in order to avoid the "tragedy of the common land". It plays a guiding role in the environmental management and economic development of Nanliu River. This paper combines the reality of integrated management of Nanliujiang River under the guidance of social ecosystem framework. To establish the database of social ecosystem in Nanliujiang river basin, combining with GIS technology, spatial database technology, SQL Server and other related technologies. Make the feasible design route. The main research content includes the theory foundation of "1"): through the research and analysis of the core concept-basin social ecosystem, the database data classification system is established; On the other hand, it studies the key technologies of database, including the development of database, the development and model of spatial database. Database engine ArcSDE and relational database system. 2) from the perspective of social ecosystem, the database design includes four stages: requirement analysis, conceptual design, logical design and physical design. The database requirement analysis is carried out around the service object, the different data needed by different service object is analyzed, and the concept design is carried out by using E-R conceptual model. Logic analysis and design based on conceptual design. On the basis of this, Geodatabase model is used for physical design. The storage and management of spatial data in relational database SQL Server2008 are realized through ArcGIS platform and spatial database engine ArcSDE. After processing, the data is classified into the database according to the process. Vector and raster data are stored through ArcCatalog, and other non-spatial attribute data are imported into the database through the input function of SQL Server2008. The establishment of the database provides a powerful foundation for the subsequent construction of the shared platform. 4) calling the data in the database of social ecosystem of the Nanliujiang River basin for a simple application study on the basin in 2005. In 2010, 2014, three time points carried out the water resources vulnerability assessment application research, obtained a relative evaluation result, except Hepu County, most areas vulnerability does not have the obvious change tendency. Most of them are in the middle fragile state, and the Nanliujiang river basin is in the important stage of intermediate transition.
【學位授予單位】：廣西師范學院
【學位級別】：碩士
【學位授予年份】：2016
【分類號】：P208

【參考文獻】

相關(guān)期刊論文 前10條

1 黃瑩;胡寶清;;基于小波變換的南流江年徑流量變化趨勢分析[J];廣西師范學院學報(自然科學版);2015年03期

2 王群;陸林;楊興柱;;千島湖社會—生態(tài)系統(tǒng)恢復力測度與影響機理[J];地理學報;2015年05期

3 周玲玲;王琳;劉偉峰;余靜;;基于客觀組合賦權(quán)法的即墨市水資源可持續(xù)利用評價[J];水資源與水工程學報;2014年04期

4 余中元;李波;張新時;;社會生態(tài)系統(tǒng)及脆弱性驅(qū)動機制分析[J];生態(tài)學報;2014年07期

5 趙慶建;溫作民;;社會生態(tài)系統(tǒng)及其恢復力研究——基于復雜性理論的視角[J];南京林業(yè)大學學報(人文社會科學版);2013年04期

6 闞興龍;周永章;;北部灣南流江流域生態(tài)功能區(qū)劃[J];熱帶地理;2013年05期

7 翁建武;夏軍;陳俊旭;;黃河上游水資源脆弱性評價研究[J];人民黃河;2013年09期

8 車良革;胡寶清;李月連;;1991-2009年南流江流域植被覆蓋時空變化及其與地質(zhì)相關(guān)分析[J];廣西師范學院學報(自然科學版);2012年04期

9 黃翠秋;郭純青;代俊峰;王文君;王小剛;;南流江流域降水序列變化的特征分析[J];水電能源科學;2012年04期

10 楊大楷;李丹丹;;尋找滇池污染之痛的癥結(jié)[J];環(huán)境保護;2012年05期

相關(guān)碩士學位論文 前7條

1 侯晴川;南流江流域環(huán)境數(shù)據(jù)管理系統(tǒng)設(shè)計與實現(xiàn)[D];廣西師范學院;2015年

2 劉建偉;南流江城市河流沉積物營養(yǎng)鹽富集特征及污染評價研究[D];廣西師范學院;2015年

3 余小璐;南流江流域生態(tài)系統(tǒng)健康評價[D];廣西師范學院;2015年

4 王子;廣西南流江流域生態(tài)風險評價研究[D];廣西師范學院;2014年

5 李月連;南流江流域土地利用變化圖譜及驅(qū)動力研究[D];廣西師范學院;2013年

6 胡何男;農(nóng)村集體土地使用權(quán)流轉(zhuǎn)機制研究[D];廣西師范學院;2013年

7 侯劉起;南流江流域土壤侵蝕空間分布特征研究[D];廣西師范學院;2013年

，

本文編號：1387539