Browse > Article
http://dx.doi.org/10.7851/ksrp.2013.19.4.319

Development of Relational Database Management System for Agricultural Non-point Source Pollution Control  

Park, Jihoon (Department of Landscape Architecture and Rural System Engineering, Seoul National University)
Kang, Moon Seong (Department of Rural Systems Engineering, Seoul National University, Research Institute for Agricultural and Life Sciences, Seoul National University)
Song, Inhong (Research Institute for Agriculture and Life Sciences, Seoul National University)
Hwang, Soon Ho (Department of Landscape Architecture and Rural System Engineering, Seoul National University)
Song, Jung-Hun (Department of Landscape Architecture and Rural System Engineering, Seoul National University)
Jun, Sang Min (Department of Landscape Architecture and Rural System Engineering, Seoul National University)
Publication Information
Journal of Korean Society of Rural Planning / v.19, no.4, 2013 , pp. 319-327 More about this Journal
Abstract
The objective of this research was to develop a relational database management system(RDBMS) to collect, manage and analyze data on agricultural non-point source(NPS) pollution. The system consists of the relational database for agricultural NPS data and data process modules. The data process modules were composed of four sub-modules for data input, management, analysis, and output. The data collected from the watershed of the upper Cheongmi stream and Geunsam-Ri were used in this study. The database was constructed using Apache Derby with meteorological, hydrological, water quality, and soil characteristics. Agricultural NPS-Data Management System(ANPS-DMS) was developed using Oracle Java. The system developed in this study can deal with a variety of agricultural NPS data and is expected to provide an appropriate data management tool for agricultural NPS studies.
Keywords
Agricultural Non-Point Source Pollution; Data Management System; Database; Data Processing;
Citations & Related Records
Times Cited By KSCI : 2  (Citation Analysis)
연도 인용수 순위
1 강문성, 박승우, 임상준, 2001, 소유역에서의 수계환경관리 및 평가시스템의 개발(I) -시스템의 개발 및 구성-, 한국농촌계획학회논문집 7(1), 3-13.   과학기술학회마을
2 강문성, 박승우, 허용구, 2001, 소유역에서의 수계환경관리 및 평가시스템의 개발(II) -시스템의 운용과 적용-, 한국농촌계획학회논문집 7(1), 15-25.   과학기술학회마을
3 관계부처합동, 2012, 제2차 비점오염원관리 종합대책.
4 국토교통부, 2013a, 국가수자원관리종합정보시스템, http://www.wamis.go.kr.
5 국토교통부, 2013b, 하천관리지리정보시스템, http://www.river.go.kr.
6 김학관, 김상민, 박승우, 2006, 관계형 데이터베이스를 이용한 수문자료 관리시스템 개발, 한국수자원학회논문집 39(10), 855-866.   과학기술학회마을   DOI   ScienceOn
7 농림축산식품부, 2013, 농촌용수종합정보시스템, https://rawris.ekr.or.kr.
8 이길성, 김영오, 양정석, 정은성, 과학기술부, 서울대학교, 웹솔루스, 부경대학교, 한국건설기술연구원, 2004, 이길성안양천 유역의 물순화 건전화 기술적용. 교육부.
9 조명희, 김경준, 김현정, 2013, 선진화된 하천측량자료 활용 및 관리를 위한 하상변동 자료관리 프로그램 기반의 하도유지관리체계 개선에 관한 연구, 한국지리정보학회논문집 16(3), 115-125.   과학기술학회마을   DOI   ScienceOn
10 한국건설기술연구원(KICT), 2004, 지표수 조사기술 개발.
11 환경부, 2006, 물환경관리 기본계획.
12 환경부, 2013, 물환경정보시스템, http://water.nier.go.kr.
13 Carleton, C.J., Dahlgren, R.A., and Tate, K.W., 2005, A relational database for the monitoringand analysis of watershed hydrologic functions: I. Database design and pertinent queries, Computers & Geosciences 31, 393-402.   DOI   ScienceOn
14 Kang, M.S., Srivastava, P., Tyson, T., Fulton, J.P., Owsley, W.F., and Yoo, K.H., 2008, A comprehensive GIS-based poultry litter management system for nutrient management planning and litter transportation, Journal of Computers and Electronics in Agriculture 64(2), 212-224.   DOI   ScienceOn
15 Nemes, A., Schaap, M.G., Leij, F.J., and Wosten, J.H.M., 2001, Description of the unsaturated soil hydraulic database UNSODA verstion 2.0, Journal of Hydrology 251, 151-162.   DOI   ScienceOn