IE interfaces (산업공학)

Korean Institute of Industrial Engineers (대한산업공학회)
권호 표지

Utilization of a Mathematical Programming Data Structure for the Implementation of a Water Resources Planning System

수자원 운영계획 시스템의 구현을 위한 수리계획 모형 자료구조의 활용

  • Kim, Jae-Hee (Department of Industrial Systems and Information Engineering, Korea University) ;
  • Kim, Sheung-Kown (Department of Industrial Systems and Information Engineering, Korea University) ;
  • Park, Young-Joon (Internet Economy Research Team, ETRI)
  • 김재희 (고려대학교 산업시스템정보공학과) ;
  • 김승권 (고려대학교 산업시스템정보공학과) ;
  • 박영준 (한국전자통신연구원)
  • Received : 20030200
  • Accepted : 20031000
  • Published : 2003.12.31
Download PDF
⟨ Previous Next ⟩

Abstract

This paper reports on the application of the integration of mathematical programming model and database in a decision support system (DSS) for the planning of the multi-reservoir operating system. The DSS is based on a multi-objective, mixed-integer goal programming (MIGP) model, which can generate efficient solutions via the weighted-sums method (WSM). The major concern of this study is seamless, efficient integration between the mathematical model and the database, because there are significant differences in structure and content between the data for a mathematical model and the data for a conventional database application. In order to load the external optimization results on the database, we developed a systematic way of naming variable/constraint so that a rapid identification of variables/constraints is possible. An efficient database structure for planning of the multi-reservoir operating system is presented by taking advantage of the naming convention of the variable/constraint.

Keywords

References

  1. AI-Shemmeri, T., Al-Kloub, B., and Pearman, A. (1997), Computer aided decision support system for water strategic planning in Jordan, European Journal of Operations Research, 102, 455-472
  2. Andreu, J, Capilla, J., and Sanchis, E. (1996), AQUATOOL, Ageneralized decision support system for water-resources planning and operational management, Journal of Hydrology, 177, 269-291
  3. CPLEX Division (2000), CPLEX 7.0 Users Manual, lLOG, Incline Village, NV
  4. Fedra, K. and Jamiecon, D. G. (1996), The 'WaterWare' decision-support System for river-basin planning. 2. Planning Capability, Journal of Hydrology, 177, 177-198
  5. Pourer, R.(1997), Database structures for mathematical programming models, Decision Support Systems, 20, 317-344
  6. Kim, S.K (1999), Hydro Energy from Multiple Reservoir Operation, HYDRO'S FUTURE Technology, Markers, and Policy, Proceedings of the WATERPOWER '99 Conference, Las Vega, USA, Water Resources Session 23: Decision Support System II, 2
  7. Kim, S. K. (1988), Methodologies for Reservoir Operation (Bibliographical Review), Journal of Korean Association of Hydrological Sciences, 21(1), 16-24
  8. Kim, S. K. and Park, Y. J. (1998), A Mathematical Model for Coordinated Multi-reservoir Operation, Journal of Korea Water Resources Association, 31(6), 777-791
  9. Klein, D. and Hannan, E.(1982), An Algorithm for the Multiple objective Integer Linear Programming Problem, European Journal of Operational Research, 9, 378-385
  10. MOCT (Ministry of Construction & Transportation) (2002), http://www.moct.go.kr/DH/mct_hpg/mcthpg_wa/mcthp_wa/mcthpm4.htm
  11. PAI(Population Action International) (2000), People in the Balance: Population and Natural Resources at the Turn of the Millennium, PAI, Washington, DC., 8-9
  12. ReVelle, C.(2000). Research challenges in environmental management, European Journal of Operational Research, 121(2), 218-231
  13. Shih.J. S. and ReVelle, C(1995), Water Supply Operations during Drought: A Discrete Hedging Rule, European Journal of Operational Research, 82(1), 163-175
  14. Stam, A., Salewicz, K.A., and Aronson, J.E. (1998). An interactive reservoir management system for Lake Kariba, European Journal of Operational Research, 107(1), 119-136
  15. Steuer, R.E.(1986), Multiple Criteria Optimization: Theory, Computation, and Application, John Wiley & Sons