A Performance Comparison of SQL and NoSQL Database Management Systems for 5G Radio Base Station Configuration

Sammanfattning

The need to store large amounts of data is always increasing and this requires better solutions for storing and managing the data. This is often done using a Database Management System (DBMS) which helps manage all data. There are a lot of different options to use today, where all serve a different purpose. This means that it is important to choose the right DBMS for the data that you have. Furthermore, it is not enough to just choose the best DBMS, the database then needs to be designed so that the data can be stored in a structured way. This can be done in many ways. Ericsson wants to implement a database solution in one of their systems to make the workflow more efficient. The system is used to store data for configuring 5G nodes in testing environments. To do this, an investigation about which DBMS fits this data best is to be done. For this purpose, the PostgreSQL database is chosen to represent SQL databases and MongoDB is chosen to represent NoSQL databases. Additionally, proposed designs for each DBMS are produced. These designs are compared with regards to their response time for common queries, as well as in a load test with an expected load on the database. The results show that the two DBMS are good in different aspects. For example, PostgreSQL is faster when relationships between different tables are used, but MongoDB is faster when querying only one document. In conclusion, both implementations serve their purpose and do have their benefits, but MongoDB is chosen to be the better one given the knowledge of how the system is to be used.