Analiza i usporedba karakteristika baza podataka za rad u stvarnom vremenu

master's thesis

• Title (english): Analysis and comparison of database characteristics aimed for real-time applications
• Author: Katarina Plantić
• Mentor: Mirta Baranović (mentor)
• Committee member: Mirta Baranović (predsjednik povjerenstva)
• Committee member: Igor Mekterović (član povjerenstva)
• Committee member: Slaven Zakošek (član povjerenstva)
• Granter: University of Zagreb; Faculty of Electrical Engineering and Computing; Zagreb
• Defense date and country: 2018-07-05, Croatia
• Scientific / art field, discipline and subdiscipline: TECHNICAL SCIENCES; Computing

Abstract

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.

Abstract (english)

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.

• Keywords: relacijske baze podataka; stvarnovremenske baze podataka; PostgreSQL; RethinkDB; upravljanje istodobnim pristupom; ACID; sustavi u stvarnom vremenu; vremenska ograničenja; SQL; ReQL; skladište dokumenata
• Keywords (english): relational database systems; real-time database systems; PostgreSQL; RethinkDB; concurrency control; ACID; real-time systems; timing constraints; SQL; ReQL; document store
• Language: croatian
• URN:NBN: urn:nbn:hr:168:626884
• Study programme: Title: Computing; Study programme type: university; Study level: graduate; Academic / professional title: magistar/magistra inženjer/inženjerka računarstva (magistar/magistra inženjer/inženjerka računarstva)
• Type of resource: Text
• File origin: Born digital
• Access conditions: Closed access
• Created on: 2019-03-19 14:01:44