Comparison of relational, NoSQL and NewSQL databases

The thesis deals with the newest area of databases that are NewSQL database. The aim of the thesis is to describe NoSQL and NewSQL databases and compare them with relational database. NewSQL database is using the same language SQL as relational databases, with ACID support for transactions same as a relational database, while NoSQL database follow the CAP theorem, in accordance with the principle of BASE. NewSQL database also as NoSQL database are horizontally scalable. The �rst chapter is an introduction to the study, followed by an introduction to databases and description of relational databases. The third and the fourth chapter presents NoSQL and NewSQL database. We presented what these bases, their characteristics, categorize and describe examples of NewSQL databases. We made a comparison between the relational, NoSQL and NewSQL databases. The last two chapters describe the preparation of test databases and testing respectively measurement runtime of databases. The �nal section presents conclusions about the studied databases and makes some predictions about their future.