Computer Aided System For Managing, Controlling And Analyzing Data From Hydroelectric Plants

This paper presents a computer aided system for managing, controlling and analyzing data from hydroelectric plants. The proposed system consists of three modules. The first is a relational database that organizes, standardizes and manages data from hydroelectric plants. The second module allows a user to build, store and manage advanced queries on this or certain other databases. The third is a simulator of the hydroelectric plants operation which can be used for planning the future operation or reproducing the past operation. The computational implementation of these modules uses the Object-Oriented Paradigm, the C++ Programming Language and the Structured Query Language (SQL). The data manager, the queries builder and the simulator were tested with data from Brazilian hydroelectric plants and the results show the potential of this system for the analysis and consistency evaluation of data from hydroelectric plants. © 2009 ASCE.34247494757Arce, A., Ohishi, T. and Soares, S. (2002). Optimal dispatch of generating units of the Itaipu hydroelectric plant. J. IEEE Transactions on Power Delivery, 17(1)Barros, M.T.L., Tsai, F.T.-C., Yang, S.-L., Lopes, J.E.G., Yeh, W.W.-G., Optimization of large-scale hydropower system operations (2003) J. of Water Resources Planning and Management, 129 (3), pp. 178-188Bowman, J.S., Emerson, S.L., Darnovsky, M., The practical SQL handbook - Using Structured Query Language (1996) Addison Wesley Professional, , MA, EUACicogna, M.A., Model for energetic operation planning of hydrothermal systems using object oriented programming (1999), MS thesis, State University of Campinas, SP, BrazilCicogna, M.A., Support decision system to short and long term planning of hydroelectric power system (2003), Ph.D thesis, State University of Campinas, SP, BrazilCicogna, M. A., Fontane D. G., Hidalgo, I. G and Lopes, J. E. G. (2009). Multiple Reservoir Simulation Using Multi-Criterion Restrictions and Object-Oriented Software Design. Accepted for the World Environmental & Water Resources Congress (ASCE-2009), Kansas City, Missouri, USAHidalgo, I.G., Search system for data analysis from hydroelectric plants (2004), MS thesis, State University of Campinas, SP, BrazilElmasri, R., Navathe, S., Fundamentals of database systems (2000) Addison Wesley Professional, , MA, EUAHorstmann, C.S., Practical object-oriented development in C++ and Java (1997) John Wiley & Sons, Inc, , NY, EUAHollingworth, J., Butterfield, D., Swart, B., Allsop, J., C++ Builder 5 developer's guide (2001) Sams Publishing, , EUAJosuttis, N.M., The C++ standard library - A tutorial and reference (1999) Addison Wesley Professional, , MA, EUALind, D.A., Marchal, W.G., Wathen, S.A., Statistical techniques in business and economic (2006) McGraw-Hill College, , MA, EUAPereira, M.V.F., Pinto, L.M.V.G., Stochastic optimization of a multireservoir hydroelectric system: A decomposition approach (1985) J. Water Resources Research, 21 (6), pp. 779-792Vinhal, C.D.N., Decision support system for energetic operation planning of electrical systems (1998), PhD thesis, State University of Campinas, SP, Brazi