Review article
https://doi.org/10.37023/ee.7.2.1
Efficient dam management using SQL and GIS
Mario Jancetić
; Faculty of Geotechnical Engineering, University of Zagreb, Varaždin, Croatia
Nikola Kranjčić
orcid.org/0000-0001-7219-9440
; Faculty of Geotechnical Engineering, University of Zagreb, Varaždin, Croatia
Milan Rezo
; Faculty of Geotechnical Engineering, University of Zagreb, Varaždin, Croatia
Abstract
This paper discusses use of SQL and GIS tools in nowadays dam management. Dam management requires the use of a highly-sophisticated measuring, monitoring and general management tools, since it is not only economical aspect of importance of these projects, but also about the security risks that require the highest possible caution and a precisely-developed control systems. Therefore, SQL and GIS are tools to be considered and implemented. GIS is widely used in spatial planning and connected management processes - because it allows easy way of storage, processing, analysis, modelling and display of spatial data. It has a wide range of features and is used in many areas. Structured Query Language (SQL) is a programming language for databases, written to be easy to understand and to use. SQL provides integration and presentation of data, optimization, easy reporting and analysis. In hand of trained professional analysts, SQL can make database search efficient and flexible, which is the key feature in demanding management processes as dam management.
Keywords
dams, dam management, SQL, GIS
Hrčak ID:
247259
URI
Publication date:
7.12.2020.
Visits: 1.618 *