Design and implementation of a common database

The utilisation of a Database Management System as a decision support tool for the management of water and related risks in the Balkans was identified as a key element of the Interisk project. The design and implementation of the Interisk information system was one of the main tasks of the Institute of Marine Biology of Crete. Both the Regional and Interregional components of such a system required harmonised data collection procedures. The user needs identification survey indicated several problems such as: lack of water monitoring practice in some of the participating regions, lack of harmonized data collection and/or analysis methodologies and lack of historical data.
A number of technical meetings and discussions were organized in order to establish harmonized data collection and analysis procedures as well as data collection forms. The design of the system is based on the originally proposed concept, providing the users, the facilities to use it either as regional or as an interregional system. Data sharing on interregional level has to respect transnational regulations decided by national authorities of the countries involved. The need of the national authorization and the lack of the regional autonomy on interregional water management issues caused limitations on the valorization of the interregional part of the database (Data sharing among partners).
The system developed, consists of three main datasets: the Local, the Regional and the Interregional database. All the three databases are identical in terms of internal structure. The system manager can easily establish layers according to the desired system set up. Data can be transferred from the local system to the regional one or even to the interregional system and vice versa. The Interisk database consists of the following elements:
 
  • Reference database
  • Inventory database
  • Monitoring database
  • Documentation database
  •  
    The Reference database consists of a set of data tables containing standard encoded reference information. This information is not changing frequently and is used to accelerate data entry. The Inventory database consists of a set of data tables containing inventory data strictly related to each region. The Monitoring database is the place where the actual measurements of all monitored parameters are stored. The Documentation database contains bibliographic and legislative information.