DEVELOPMENT OF AN APPLICATION WITH THE PURPOSE OF MAINTAINING A DATABASE

Nowadays, sustainable development is the great paradigm of human development, because of that new methodologies for the planning and management of systems, specially the ones for hydric resources, are being developed, this forms of evaluation are no longer restricted to mere economic evaluation, but are also submitted to social and environmental sustainability evaluation. The use of databases is essential for the manipulation of the most diverse kinds of data and information, which can be utilized for storing historical data and other information necessary for future use. Therefore, this article focuses mainly on presenting the application developed to manipulate tables in a database, to allow and facilitate the inclusion, elimination, renaming of tables and table fields in order to substitute some SQL commands available in programs of the various available databases. Thus, this application will add value to the decision support system that is being developed by GOTA (Group of Water Total Optimization) which in many cases needs to make changes in its database for obtaining greater flexibility and data manipulation, such as register of reservoirs, irrigated perimeters, meteorological stations, gauged stations, institutions, etc. This application allows an intelligent and fast manipulation of tables in a database, which the present version runs on the PostgreSQL database and was developed in Java platform, which is a platform that permits its installation in several types of operational systems and many kinds of computers.