Performance Evaluation Between HarperDB, Mongo DB and PostgreSQL

• Main Author: Figueiredo, Figueiredo
• Publication Date: 2023
• Other Authors: Cardoso, Filipe, Saraiva, Goncalo, Rebelo, João, Rodrigues, Ricardo, Wanzeller, Cristina, Martins, Pedro, Abbasi, Maryam
• Language: eng
• Source: Repositórios Científicos de Acesso Aberto de Portugal (RCAAP)
• Download full: http://hdl.handle.net/10400.15/4675
• topic: RDBMS; NoSQL; PostgreSQL; MongoDB; HarperDB; Performance

Several modern-day problems, like information overload and big data, need to deal with large amounts of data. As such, to meet the application requirements, for instance, performance and consistency, more and more systems are adapting to the specificities. The existing Relational Database Management System (RDBMS)’s the processing of massive data has become an issue because these databases do not deal with a massive amount of data. NoSQL is a database management system that makes processing massive and/or unstructured data easier because it uses key-value to store the data, collections or document stores instead of tables. Many companies today tend to start a project using NoSQL. However, HarperDB aims to produce a relational and nonrelational DBMS, allowing developers to choose between different solutions. This paper aims to show the most relevant differences between HarperDB, MongoDB and PostgreSQL and compare their performances. Preliminary results show that PostgreSQL performs better with structured data, but HarperDB can integrate NoSQL and SQL, which can be a significant advantage to HarperDB compared to the other solutions.