Multimedia database development for innovative application about fish fauna for inland water ecosystem management

Authors

  • Konstandinos Panitsidis Faculty of Forestry and Natural Environment, School of Agriculture, Forestry & Natural Environment Aristotle University of Thessaloniki http://orcid.org/0000-0001-8299-1511
  • Zacharoula Andreopoulou Laboratory of Forest Informatics, Faculty of Forestry and Natural Environment, School of Agriculture, Forestry & Natural Environment Aristotle University of Thessaloniki
  • Antonios Kokkinakis Laboratory of Wild Life and Freshwater Fisheries, Faculty of Forestry and Natural Environment, School of Agriculture, Forestry & Natural Environment Aristotle University of Thessaloniki

DOI:

https://doi.org/10.17700/jai.2017.8.3.406

Abstract

This paper describes the development of an innovative application with a multimedia database, concerning the management of fresh water fish fauna in the inland water ecosystems of Greece. This database is a baseline for keeping descriptive information of fresh water fish fauna and bibliographic spread reports. The database has provision for both descriptive and geographic mapping (GIS). The sources of the data used for the database population were from a) The Red Book of Endangered Animals of Greece b) IUCN (International Union for Conservation of Nature and c) Ministry of Environment & Energy (Study 6: Supervision and Evaluation of the Conservation status of fish species of Community interest in Greece). A detailed description will be made for the development of the stages of the database (Conceptual - Logical - Physical Design). The database management system was developed in Microsoft Access and in pgAdmin, which is an open source administration and development platform for PostgreSQL. In addition, we will mention the filling of the database and the Entity - Relationship Model. The database due to its structure and data it will be able to provide answers to hypothetical scenarios to the application that will use it. Furthermore, the aim of this project is to construct a database that will provide ichthyologic and environmental data. The main advantage is the compatibility with various software platforms and that it can be easily expanded.

Downloads

Published

2017-11-21

How to Cite

Panitsidis, K., Andreopoulou, Z., & Kokkinakis, A. (2017). Multimedia database development for innovative application about fish fauna for inland water ecosystem management. Journal of Agricultural Informatics, 8(3). https://doi.org/10.17700/jai.2017.8.3.406

Issue

Section

Journal of Agricultural Informatics