SQL vs NoSQL: a spatial benchmark for selected NoSQL and relational database management systems
dc.contributor.advisor
Gittings, Bruce
en
dc.contributor.author
Hammersley, Benjamin
en
dc.date.accessioned
2019-02-25T14:23:29Z
dc.date.available
2019-02-25T14:23:29Z
dc.date.issued
2018-11-29
dc.description.abstract
GIS applications are used to capture, store, manipulate, analyse, manage and present geographical data (Longley, 2005). These applications require functional and spatially enabled databases to operate. Relational database management systems (RDBMS) have been at the forefront in this field for an excess of 40 years. Over this time period, the demands on database management systems (DBMS) have changed, especially regarding the recent proliferation of Big Data and spatial data. The relational model is not perfect and often struggles to manage large, unstructured and highly related data. NoSQL DBMS have increased in popularity over the past two decades as a potential answer to some of the short comings of RDBMS. This investigation presents a scalable spatial database performance benchmark comparing two RDBMS (Oracle and PostgreSQL) with a document DBMS (MongoDB) and a graph DBMS (Neo4j). Findings show that the RDBMS are overall superior although MongoDB scales better than RDBMS when data is retrieved from disk output.
en
dc.identifier.uri
http://hdl.handle.net/1842/35474
dc.language.iso
en
dc.publisher
The University of Edinburgh
en
dc.relation.references
McCarthy, C., 2014. Does NoSQL have a place in GIS? – An open-source spatial database performance comparison with proven RDBMS (Masters Thesis)
en
dc.relation.references
Baas, B.L.P., 2012. NoSQL spatial–Neo4j versus PostGIS(Master's thesis).
en
dc.subject
NoSQL
en
dc.subject
Relational database management system
en
dc.subject
SQL
en
dc.subject
Database management system
en
dc.subject
Spatial data
en
dc.subject
Performance
en
dc.subject
Benchmark
en
dc.subject
MSc Geographical Information Science
en
dc.subject
GIS
en
dc.title
SQL vs NoSQL: a spatial benchmark for selected NoSQL and relational database management systems
en
dc.type
Thesis or Dissertation
en
dc.type.qualificationlevel
Masters
en
dc.type.qualificationname
MSc Master of Science
en
dcterms.accessRights
RESTRICTED ACCESS
en
Files
This item appears in the following Collection(s)