Abstract | Završni rad se sastoji od šest poglavlja. U prvom poglavlju napisan je zadatak završnog rada te njegov sadržaj. U drugom poglavlju je objašnjena specifičnost NewSQL baza podataka, potreba za njihovim postojanjem te su analizirane prednosti, mane i razlike u odnosu na SQL i NoSQL. U trećem poglavlju je definirana CockroachDB baza podataka ,prikazana je njena arhitektura, kompatibilnost, navedeno je tko je koristi te su analizirane njene prednost i mane u odnosu na druge baze. U četvrtom poglavlju opisana je aplikacija i korištena baza podataka. U petom poglavlju su prikazane mogućnosti NewSQL baza podataka izradom jednostavne aplikacije korištenjem Python jezika i CockroachDB baze podataka. Ispitani su načini povezivanja s bazom podataka ,testirana je otpornost baze s distribuiranim podacima, komentirani su dobiveni podatci, objašnjeni su postupci distribucije ,postupci potrebni za spajanje aplikacije, postupci unošenja te kreiranja baze podataka, postupci kreiranja korisnika, postupci dodavanja regija te postupci poboljšanja performansi upita. U završnom poglavlju je dan zaključak o NewSQL bazi podataka, njenoj specifičnosti, karakteristikama te upotrebi. |
Abstract (english) | The final thesis consists of six chapters. In the first chapter, the final paper's task and its content are written. In the second chapter, the specificity of NewSQL databases is explained, the need for their existence, and the advantages, methods, and differences compared to SQL and NoSQL are analyzed. In the third chapter, the CockroachDB database is defined, its architecture and compatibility are presented, who uses it, and its advantages and disadvantages compared to other databases are analyzed. In the fourth chapter, the application and the database used are described. In the fifth chapter, the capabilities of the NewSQL database are presented by creating a simple application using the Python language and the CockroachDB database. The methods of connecting to the database were examined, the resilience of the database with distributed data was tested, the obtained data were commented on, the distribution procedures were explained, the procedures necessary for connecting applications, the procedures for entering and creating the database, the procedures for creating users, the procedures for adding a region, and the procedures for improving query performance. The final chapter gives a conclusion about the NewSQL database, its specificity, characteristics, and use. |