Browse > Article

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)
Publication Information
IE interfaces / v.16, no.4, 2003 , pp. 485-495 More about this Journal
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
database; mathematical programming; decision support system; water resources system;
Citations & Related Records
연도 인용수 순위
  • Reference
1 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
2 Pourer, R.(1997), Database structures for mathematical programming models, Decision Support Systems, 20, 317-344
3 Kim, S. K. (1988), Methodologies for Reservoir Operation (Bibliographical Review), Journal of Korean Association of Hydrological Sciences, 21(1), 16-24
4 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
5 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
6 Steuer, R.E.(1986), Multiple Criteria Optimization: Theory, Computation, and Application, John Wiley & Sons
7 ReVelle, C.(2000). Research challenges in environmental management, European Journal of Operational Research, 121(2), 218-231
8 Klein, D. and Hannan, E.(1982), An Algorithm for the Multiple objective Integer Linear Programming Problem, European Journal of Operational Research, 9, 378-385
9 MOCT (Ministry of Construction & Transportation) (2002), http://www.moct.go.kr/DH/mct_hpg/mcthpg_wa/mcthp_wa/mcthpm4.htm
10 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
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 CPLEX Division (2000), CPLEX 7.0 Users Manual, lLOG, Incline Village, NV
13 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
14 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
15 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