Reporting Road Problems in Smart Cities Using OpenIoT Framework - Interoperability and Open-Source Solutions for the Internet of Things - page 176

provided then data is annotated accordingly. Data can be loaded into LSM with pull-

based and push-based methods. Both mechanisms have advantages and disadvantages
and both are used in OpenIoT depending on a use case [ 28 ].
Scheduler formulates the request from user inputs. Scheduler performs the fol-
lowing functions: sensor and ICO selection, virtual sensor

-

“ indirect ” activation, request

storing and activation, service status update, access control [ 29 ].
Implementation of the storage facility for video fragments is subject to further analyses
and discussion. The decisions regarding what, when, where and how to store should be
based on the needs, relevance, capacity constraints, preservation of evidence etc.

Fig. 7. Table structure of SQLite DB

5 Conclusion and Future Work

We can think of a scenario, where people not only report problems by pressing the “ red

button ” , but, in addition, they press a “ green button ” , to appreciate things or changes

they like. These can be marked on a map, aggregated and analyzed to under-

stand, which locations in a city produce positive emotions. This can be a little step
towards improved and enhanced services and possible connections to social networks.
Moreover, creating such a

“ likes ”

“ map of feelings ” in future can be automated by gathering

and analyzing statistics about users heart rate variation and other parameters that can

be obtained via different wearable devices like smart watches or

'

tness bracelets.