A Comparison of Relational and Graph Databases for CRM Systems
(2019) In LU-CS-EX 2019-09 EDAM05 20191Department of Computer Science
- Abstract
- In an age of increasing usage of heavily interconnected platforms, graph databases have increased in popularity due to their ease of modelling these systems. This thesis will evaluate if the graph database Neo4j can be used to model Lime's CRM System efficiently by comparing the performance of Neo4j and MS SQL on queries similar to those existing in Lime CRM. To benchmark the databases, they were created with the core entities of the Lime CRM system. The databases are created with the same structure and schema as in Lime CRM. Thereafter, the databases were populated with randomly generated data. These databases were then queried a large amount of times with random values in every query to prevent caching. Our results show that MS SQL was... (More)
- In an age of increasing usage of heavily interconnected platforms, graph databases have increased in popularity due to their ease of modelling these systems. This thesis will evaluate if the graph database Neo4j can be used to model Lime's CRM System efficiently by comparing the performance of Neo4j and MS SQL on queries similar to those existing in Lime CRM. To benchmark the databases, they were created with the core entities of the Lime CRM system. The databases are created with the same structure and schema as in Lime CRM. Thereafter, the databases were populated with randomly generated data. These databases were then queried a large amount of times with random values in every query to prevent caching. Our results show that MS SQL was 4-10 times faster for insertion queries. Furthermore, MS SQL was also 2-5 times more efficient at handling queries that return many rows/nodes of data. (Less)
- Popular Abstract (Swedish)
- Det finns flertal fall då grafdatabaser överträffar traditionella relationsdatabasers pre-standa. Är grafdatabaser potentiellt den nya lagringsmetoden vid stor mängd sam-mankopplad data? Vilka villkor krävs? För att sätta det på prov har vi skapat entestmiljö med en stor mängd relationsbunden data.
Please use this url to cite or link to this publication:
http://lup.lub.lu.se/student-papers/record/8987929
- author
- Winberg, Victor LU and Zubac, Jan LU
- supervisor
- organization
- course
- EDAM05 20191
- year
- 2019
- type
- H2 - Master's Degree (Two Years)
- subject
- keywords
- SQL, Neo4j, graph databases, relational databases, databases, benchmark, CRM
- publication/series
- LU-CS-EX 2019-09
- report number
- LU-CS-EX 2019-09
- ISSN
- 1650-2884
- language
- English
- id
- 8987929
- date added to LUP
- 2019-09-16 11:05:59
- date last changed
- 2019-09-16 11:05:59
@misc{8987929, abstract = {{In an age of increasing usage of heavily interconnected platforms, graph databases have increased in popularity due to their ease of modelling these systems. This thesis will evaluate if the graph database Neo4j can be used to model Lime's CRM System efficiently by comparing the performance of Neo4j and MS SQL on queries similar to those existing in Lime CRM. To benchmark the databases, they were created with the core entities of the Lime CRM system. The databases are created with the same structure and schema as in Lime CRM. Thereafter, the databases were populated with randomly generated data. These databases were then queried a large amount of times with random values in every query to prevent caching. Our results show that MS SQL was 4-10 times faster for insertion queries. Furthermore, MS SQL was also 2-5 times more efficient at handling queries that return many rows/nodes of data.}}, author = {{Winberg, Victor and Zubac, Jan}}, issn = {{1650-2884}}, language = {{eng}}, note = {{Student Paper}}, series = {{LU-CS-EX 2019-09}}, title = {{A Comparison of Relational and Graph Databases for CRM Systems}}, year = {{2019}}, }