Comparison of databases regarding saving JSON documents

Diplomsko delo je sestavljeno iz teoretičnega in praktičnega dela. Najprej so opisane osnove relacijskih in nerelacijskih podatkovnih baz, nato pa njihovi najbolj znani predstavniki. Nato sledi razlaga formata za izmenjavo podatkov JSON in dela z njim v podatkovnih bazah (ustvarjanje, branje, posodabljanje, brisanje podatkov). Ključni del diplomske naloge je praktično delo, kjer smo merili in analizirali podatkovne baze pri shranjevanju dokumentov JSON. Najprej opišemo implementacijo aplikacije za samodejno testiranje, kjer merimo čas in porabo pomnilnika. Testiranje je bilo izvedeno nad manjšimi in večjimi dokumenti. Testirali smo podatkovne baze MySQL, PostgreSQL in MongoDB. Na koncu analiziramo dobljene rezultate in podamo zaključne ugotovitve.The diploma thesis consists of theoretical and practical work. The basics of relational and non-relational databases are described first, followed by their most well-known representatives. This is followed by an explanation of the JSON data exchange format and working with it in databases (creating, reading, updating, deleting data). The key part of the thesis is practical work, where we measured and analyzed databases when storing JSON documents. We first describe the implementation of an automated testing application which measures time and memory consumption. Testing was performed on smaller and larger documents. We tested MySQL, PostgreSQL and MongoDB databases. Finally, we analyze the obtained results and give concluding remarks