Journal of Korean Society of Rural Planning (농촌계획)

Korean Society of Rural Planning (한국농촌계획학회)
권호 표지
DOI QR코드

DOI QR Code

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)
  • 박지훈 (서울대학교 생태조경.지역시스템공학부) ;
  • 강문성 (서울대학교 조경.지역시스템공학부, 서울대학교 농업생명과학연구원) ;
  • 송인홍 (서울대학교 농업생명과학연구원) ;
  • 황순호 (서울대학교 생태조경.지역시스템공학부) ;
  • 송정헌 (서울대학교 생태조경.지역시스템공학부) ;
  • 전상민 (서울대학교 생태조경.지역시스템공학부)
  • Received : 2013.11.25
  • Accepted : 2013.12.05
  • Published : 2013.12.30
Download PDF
⟨ Previous Next ⟩

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

References

  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. https://doi.org/10.3741/JKWRA.2006.39.10.855
  7. 농림축산식품부, 2013, 농촌용수종합정보시스템, https://rawris.ekr.or.kr.
  8. 이길성, 김영오, 양정석, 정은성, 과학기술부, 서울대학교, 웹솔루스, 부경대학교, 한국건설기술연구원, 2004, 이길성안양천 유역의 물순화 건전화 기술적용. 교육부.
  9. 조명희, 김경준, 김현정, 2013, 선진화된 하천측량자료 활용 및 관리를 위한 하상변동 자료관리 프로그램 기반의 하도유지관리체계 개선에 관한 연구, 한국지리정보학회논문집 16(3), 115-125. https://doi.org/10.11108/kagis.2013.16.3.115
  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. https://doi.org/10.1016/j.cageo.2004.10.007
  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. https://doi.org/10.1016/j.compag.2008.05.013
  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. https://doi.org/10.1016/S0022-1694(01)00465-6

Cited by

  1. Web-Based Data Processing and Model Linkage Techniques for Agricultural Water-Resource Analysis vol.57, pp.5, 2015, https://doi.org/10.5389/KSAE.2015.57.5.101
  2. Design and Implementation of Reference Evapotranspiration Database for Future Climate Scenarios vol.22, pp.4, 2016, https://doi.org/10.7851/ksrp.2016.22.4.071
  3. 웹 GIS기반의 건축문화재 홍수위험관리 시스템 개발에 관한 연구 vol.31, pp.1, 2013, https://doi.org/10.5659/jaik_sc.2015.31.1.45
  4. 계절예측 정보 기반 APEX-Paddy 모형 적용성 평가 vol.24, pp.4, 2013, https://doi.org/10.7851/ksrp.2018.24.4.099