Usluga za spremanje i dohvaćanje vremenskih sljedova pomoću baze podataka Timescale

undergraduate thesis

• Title (english): A service for saving and retrieving time series data using the Timescale database
• Author: Ivan Žgela
• Mentor: Mario Kušek (mentor)
• Committee member: Mario Kušek (predsjednik povjerenstva)
• Committee member: Krunoslav Tržec (član povjerenstva)
• Committee member: Ivan Kralj (član povjerenstva)
• Granter: University of Zagreb; Faculty of Electrical Engineering and Computing; Zagreb
• Defense date and country: 2023-07-06, Croatia
• Scientific / art field, discipline and subdiscipline: TECHNICAL SCIENCES; Computing

Abstract

Rad se dotaknuo teme mikroservisne arhitekture. Objašnjana je glavna razlika između
sinkrone i asinkrone mikroservisne arhitekture.
Za potrebe dohvata podataka senzora koristili smo posrednik poruka RabbitMQ te objasnili
protokol AMQP na kojem se temelji razmjena podataka, razmjene kao cjeline, redova i
poveznica između njih.
Kratko je opisan proces parsiranja dobivenih podataka kako bi se „nerazumljivi“ podatci
pretvorili u stvarne dobivene vrijednosti senzora.
Na samom kraju su parsirani podatci pripremljeni za njihovo spremanje i spremljeni u bazu
podataka Timescale, gdje su spremni za pregled i dohvat u bilo kojem trenutku.

Abstract (english)

The article discussed the topic of microservices architecture. It explained the main
difference between synchronous and asynchronous microservices architecture.
For the purpose of retrieving sensor data, we utilized the message broker RabbitMQ and
explained the AMQP protocol that forms the basis of data exchange, including exchanges
as units, queues and the bindings between them.
The process of parsing the received data to transform „unreadable“ data into actual sensor
data was briefly described.
Finally, the parsed data was prepared for storage and saved in the Timescale database,
where it is available for viewing and retrieval at any time.

• Keywords: Mikroservisna arhitektura; RabbitMQ; TimescaleDB
• Keywords (english): Microservice architecture; RabbitMQ; TimescaleDB
• Language: croatian
• URN:NBN: urn:nbn:hr:168:854486
• Study programme: Title: Computing; Study programme type: university; Study level: undergraduate; Academic / professional title: sveučilišni/a prvostupnik/ prvostupnica (baccalaureus/baccalaurea) inženjer/inženjerka računarstva (sveučilišni/a prvostupnik/ prvostupnica (baccalaureus/baccalaurea) inženjer/inženjerka računarstva)
• Type of resource: Text
• File origin: Born digital
• Access conditions: Closed access
• Created on: 2023-07-13 10:42:28