dc.contributor.author | Sveen, Atle Frenvik | |
dc.date.accessioned | 2019-11-22T07:58:39Z | |
dc.date.available | 2019-11-22T07:58:39Z | |
dc.date.created | 2019-11-21T13:31:43Z | |
dc.date.issued | 2019 | |
dc.identifier.issn | 2196-1115 | |
dc.identifier.uri | http://hdl.handle.net/11250/2629960 | |
dc.description.abstract | The no-schema approach of NoSQL document stores is a tempting solution for importing heterogenous geospatial data to a spatial database. However, this approach means sacrificing the benefits of RDBMSes, such as existing integrations and the ACID principle. Previous comparisons of the document-store and table-based layout for storing geospatial data favours the document-store approach but does not consider importing data that can be segmented into homogenous datasets. In this paper we propose “The Heterogeneous Open Geodata Storage (HOGS)” system. HOGS is a command line utility that automates the process of importing geospatial data to a PostgreSQL/PostGIS database. It is developed in order to compare the performance of a traditional storage layout adhering to the ACID principle, and a NoSQL-inspired document store. A collection of eight open geospatial datasets comprising 15 million features was imported and queried in order to compare the differences between the two storage layouts. The results from a quantitative experiment are presented and shows that large amounts of open geospatial data can be stored using traditional RDBMSes using a table-based layout without any performance penalties. | nb_NO |
dc.language.iso | eng | nb_NO |
dc.publisher | Springer Verlag | nb_NO |
dc.rights | Navngivelse 4.0 Internasjonal | * |
dc.rights.uri | http://creativecommons.org/licenses/by/4.0/deed.no | * |
dc.title | Efficient storage of heterogeneous geospatial data in spatial databases | nb_NO |
dc.type | Journal article | nb_NO |
dc.type | Peer reviewed | nb_NO |
dc.description.version | publishedVersion | nb_NO |
dc.source.journal | Journal of Big Data | nb_NO |
dc.identifier.doi | https://doi.org/10.1186/s40537-019-0262-8 | |
dc.identifier.cristin | 1750497 | |
dc.description.localcode | © The Author(s) 2019. This article is distributed under the terms of the Creative Commons Attribution 4.0 International License (http://creativecommons.org/licenses/by/4.0/), which permits unrestricted use, distribution, and reproduction in any medium, provided you give appropriate credit to the original author(s) and the source, provide a link to the Creative Commons license, and indicate if changes were made. | nb_NO |
cristin.unitcode | 194,64,91,0 | |
cristin.unitname | Institutt for bygg- og miljøteknikk | |
cristin.ispublished | true | |
cristin.fulltext | original | |
cristin.qualitycode | 1 | |