Comparison of Database Management Systems. A comparison of common Database Management Systems

Data can be referred to as objects or events stored on digital media. The evolution of IT solutions has sprung an interest in developing systems to store this type of data more efficiently. The modern method of storing general data is by utilizing a database, which is an organized collection of logically related data.

Different types of databases suit various needs, therefore the purpose of this project is to compare the leading database solutions with each other. The databases chosen
for this project are: MySQL, Neo4j and MongoDB.

Furthermore we collaborate with two companies in order to acquire hands-on information of how companies work with data. This is done by developing modules for their web applications. The insight and data obtained through these companies is used to create test cases which is then benchmarked on the different database management systems.

The test results indicates that MongoDB has overall the best performance. However, during a few complex test cases MongoDB lacks in performance. Neo4j performs worse on more test cases than MongoDB, and MySQL is by far the most consistent of these three technologies. The outcome is similar to our expectations and confirms parts of the related work that has been researched.

BibTeX @misc{Arneson2016,author={Arneson, Simon and Berntsson, Joakim and Larsson, Victor and Takman, Simon Larsson and Nordmark, Erik and Talebi, Pedram},title={Comparison of Database Management Systems. A comparison of common Database Management Systems},abstract={Data can be referred to as objects or events stored on digital media. The evolution of IT solutions has sprung an interest in developing systems to store this type of data more efficiently. The modern method of storing general data is by utilizing a database, which is an organized collection of logically related data. <br><br>
Different types of databases suit various needs, therefore the purpose of this project is to compare the leading database solutions with each other. The databases chosen
for this project are: MySQL, Neo4j and MongoDB. <br><br>
Furthermore we collaborate with two companies in order to acquire hands-on information of how companies work with data. This is done by developing modules for their web applications. The insight and data obtained through these companies is used to create test cases which is then benchmarked on the different database management systems. <br><br>
The test results indicates that MongoDB has overall the best performance. However, during a few complex test cases MongoDB lacks in performance. Neo4j performs worse on more test cases than MongoDB, and MySQL is by far the most consistent of these three technologies. The outcome is similar to our expectations and confirms parts of the related work that has been researched. },publisher={Institutionen för data- och informationsteknik (Chalmers), Chalmers tekniska högskola},place={Göteborg},year={2016},keywords={database, benchmarking, test cases, company analysis, nosql, dbms, relational},note={73},}

RefWorks RT GenericSR ElectronicID 245125A1 Arneson, SimonA1 Berntsson, JoakimA1 Larsson, VictorA1 Takman, Simon LarssonA1 Nordmark, ErikA1 Talebi, PedramT1 Comparison of Database Management Systems. A comparison of common Database Management SystemsYR 2016AB Data can be referred to as objects or events stored on digital media. The evolution of IT solutions has sprung an interest in developing systems to store this type of data more efficiently. The modern method of storing general data is by utilizing a database, which is an organized collection of logically related data. <br><br>
Different types of databases suit various needs, therefore the purpose of this project is to compare the leading database solutions with each other. The databases chosen
for this project are: MySQL, Neo4j and MongoDB. <br><br>
Furthermore we collaborate with two companies in order to acquire hands-on information of how companies work with data. This is done by developing modules for their web applications. The insight and data obtained through these companies is used to create test cases which is then benchmarked on the different database management systems. <br><br>
The test results indicates that MongoDB has overall the best performance. However, during a few complex test cases MongoDB lacks in performance. Neo4j performs worse on more test cases than MongoDB, and MySQL is by far the most consistent of these three technologies. The outcome is similar to our expectations and confirms parts of the related work that has been researched. PB Institutionen för data- och informationsteknik (Chalmers), Chalmers tekniska högskola,PB Institutionen för data- och informationsteknik (Chalmers), Chalmers tekniska högskola,PB Institutionen för data- och informationsteknik (Chalmers), Chalmers tekniska högskola,PB Institutionen för data- och informationsteknik (Chalmers), Chalmers tekniska högskola,PB Institutionen för data- och informationsteknik (Chalmers), Chalmers tekniska högskola,PB Institutionen för data- och informationsteknik (Chalmers), Chalmers tekniska högskola,LA engLK http://publications.lib.chalmers.se/records/fulltext/245125/245125.pdfOL 30