En prestandajämförelse av Neo4j och SQL Server utifrån spatiala användningsområden

Examensarbete på kandidatnivå

Använd denna länk för att citera eller länka till detta dokument: https://hdl.handle.net/20.500.12380/304881
Ladda ner:
Fil Beskrivning StorlekFormat 
22-16 Persson Bach.pdf1.82 MBAdobe PDFVisa
Bibliografiska detaljer
Typ: Examensarbete på kandidatnivå
Titel: En prestandajämförelse av Neo4j och SQL Server utifrån spatiala användningsområden
Författare: Persson, Max
Bach, Samuel
Sammanfattning: Värderingsdata is a company which specializes in evaluating different types of properties in Sweden. To accomplish high accuracy in their evaluations, a considerable amount of data as well as complex and time consuming queries are utilized. In an effort to remedy the time aspect, this report’s aim has been to determine the advantages and disadvantages of the currently-in-use relational database SQL Server and the graph database Neo4j. Furthermore, their individual performance is to be determined. The different advantages and disadvantages of the databases will be assessed in conjunction with tests as will their respective performance. The tests in question consist of several different queries based on three different scenarios. These are centered around retrieving a propertiey’s closest point and area of interest as well as any relevant spatial information. The results from the tests conducted showed the relational database as performing better in all scenarios. Neo4j’s lack of native support for spatial functionality was one of its downsides. This in combination with its performance compared to the relational database lead to the conclusion that Neo4j in its current state is not a viable substitution to SQL Server.
Nyckelord: Neo4j;SQL Server;comparison;spatial use cases
Utgivningsdatum: 2022
Utgivare: Chalmers tekniska högskola / Institutionen för data och informationsteknik
URI: https://hdl.handle.net/20.500.12380/304881
Samling:Examensarbeten för kandidatexamen // Bachelor Theses

Materialet i Chalmers öppna arkiv är upphovsrättsligt skyddat och får ej användas i kommersiellt syfte!