NoSQL Databases And Comparison Of Their Performance With Relational Databases

Tema ovog diplomskog rada su NoSQL baze podataka te njihova usporedba s relacijskim bazama podataka. Na samom početku rada ukratko su objašnjene osnove relacijskih baza podataka, odnosno pojam primarnog i stranog ključa, pojam RDBMS-a i SQL-a. Zatim u drugom poglavlju bavimo se NoSQL bazama podataka. Opisana su ACID i BASE svojstva te glavne karakteristike NoSQL baza podataka. Također, navedena je podjela NoSQL baza podataka na ključ-vrijednost, grafovske, dokumentne i stupčane baze podataka. Za svaku vrstu navedena su svojstva i njihova primjena. U praktičnom dijelu rada dizajnirali smo bazu podataka filmova i mali isječak baze podataka socijalne mreže u MySQL, Neo4j i MongoDB sustavu. Na bazi podataka filmova testirana je brzina izvođenja unosa, brisanja i selektiranja podataka, a na bazi podataka socijalne mreže testirani su upiti koji zahtijevaju dubinski obilazak stabla u grafovskim baza podataka.The topic of this master thesis is NoSQL databases and their comparison with relational databases. At the very beginning of this thesis, the basics of relational databases are briefly explained, that is, the concept of primary and foreign keys, the concept of RDBMS and SQL. Then in the second chapter we deal with NoSQL databases. ACID and BASE properties and the main characteristics of NoSQL databases are described. Also, the division of NoSQL databases into key-value, graph, document and column-based is specified. For each type of NoSQL database, the properties and their application are listed. In the practical part of the thesis, we designed a movie database and a small snippet of a social network database in MySQL, Neo4j and MongoDB system. The speed of inserting, deleting and selecting data was tested on the movies database, and on the social networks database queries that require an in-depth tour of the tree in the graph database