Analysis and comparison of database characteristics aimed for real-time applications

Tradicionalni relacijski sustavi baza podataka pružaju učinkovitu pohranu informacija i manipulaciju istima. Integrirani sustav koji uz sistematičnu i organiziranu manipulaciju podatcima provodi i određena vremenska ograničenja, naziva se sustavom baza podataka u stvarnom vremenu. Primjena ovakvih sustava u modernim aplikacijama koje rade s velikim količinama ulaznih podataka promjenjive prirode predstavlja brojne izazove. Vrednovanje PostgreSQL i RethinkDB baza podataka temelji se na usporedbi raznih načela i protokola koji predstavljaju temeljne zahtjeve razvoja sustava potpore upravljanju podatcima. Opisani su načini upravljanja istodobnim pristupom transakcija, distribuirane obrade, skalabilnost sustava, praćenje promjena u podatcima, arhitektura baze podataka i brojni drugi, te njihova implementacija u navedenim bazama podataka. Analizom rezultata usporedbe tradicionalne relacijske baze podataka s novom tehnologijom stvarnovremenske baze, predloženo je prikladno rješenje za sustav praćenja industrijske proizvodnje i obrade materijala.Traditional relational database systems provide an effective way of storing information and manipulating it. An integrated system that, along with systematic and organized data manipulation, also implements certain time constraints, is referred to as a real-time database system. The use of such systems in modern applications that work with large volumes of input data of temporal nature presents a number of challenges. Evaluation of PostgreSQL and RethinkDB databases is based on a comparison of various principles and protocols that represent the underlying requirements for developing a data management support system. Concurrency control, distributed processing, system scalability, data change tracking, database architecture and many others are described, as well as their implementation in the mentioned databases. By analyzing the results of comparison of the traditional relational database with the new technology of the real-time database, a suitable solution for monitoring industrial production and material processing was proposed