This week I was invited to the 129th EuroSDR Board Members committee for presenting our latest research work on geospatial databases. It was a technical presentation focused on the usability gap of the Geospatial Reference Information compiled and published by the SDIs.
In the slides we present a case study on Land Occupation databases which use an object-oriented data model following the INSPIRE technical specifications. In this case the usability gap consists on the object-relational impedance mismatch. This happens when an object-oriented data model has to be stored in a relational database.
In the second section of this presentation we describe a computational experiment for testing if there are any benefits in storing land use (LU) and land cover (LC) data in a document store database. In this experiment we used the LU/LC database of Spain (SIOSE).
The results showed that there are some benefits in terms of throughput capacity and response times for certain thematic queries. Based on these results we propose some additional improvements that could provide even better results.
This experiment was performed using the dockers containerization technology, so the experiment is completely reproducible in less than eight hours (it took weeks to prepare the experiment) by executing a few lines of code. As a suggestion, the dockers technology could be used as a way for sharing Geospatial Reference Information databases with companies or advanced users willing to use this data for research or business.
This research is going to be continued in a research project starting in 2017 and funded by the Spanish Ministry of Economy and Competitiveness.