Anna O’Faoláin de Bhróithe’s research while affiliated with HTW Berlin - University of Applied Sciences and other places

Schema evolution is an important theme for many database users across a broad range of fields. This paper introduces a generic data management layer, GeneRelDB, which allows the schema of a relational database to evolve during run time without the need to rewrite database queries in the application code. It is designed to run as an abstraction layer, handling all communication (queries and data exchange) between the user interface and the database backend. The only restriction to the changes that can be made relate to data type conversion for existing columns in the database. Foreign key constraints are supported and referential integrity is maintained during evolution.

Flood forecasting is particularly difficult and uncertain for small drainage basins. One reason for this is due to inadequate temporal and spatial hydrological input variables for model-based flood predictions. Incorporating additional information collected by volunteers with the help of their smartphones can improve flood forecasting systems. Data collected in this way is often referred to VGI data (Volunteered Geographic Information data). This paper discusses how this information can be incorporated into a flood forecasting system to support flood management in small drainage basins on the basis of mobile VGI data. It therefore outlines the main functional components involved in such a VGI-based flood forecasting platform while presenting the component for mobile data acquisition (mobile sensing) in more detail. In this context, relevant measurement variables are first introduced and then suitable methods for recording these data with mobile devices are described. The focus of the paper lies on discussing various methods for measuring the water level using inbuilt smartphone sensors. For this purpose, three different image-based methods for measuring the water level at the banks of small rivers using a mobile device and the inbuilt orientation and camera sensors are explained in detail. It is shown that performing the measurements with the user’s help via appropriate user interaction and utilising known structures at the measuring points results in a rather robust image-based measurement of the water level. A preliminary evaluation of the methods under ideal conditions found that the developed measurement techniques can achieve both an accuracy and precision of less than 1 cm.