Usporedba performansi relacijskog sustava i sustava specijaliziranog za pohranu vremenskih serija u radu s podacima za dijagnostiku vibracijskog stanja rotirajućih strojeva

master's thesis

• Title (english): Performance comparison of relational databases and time series databases in handling vibration state of rotating machines
• Author: Dora Ljubas
• Mentor: Ljiljana Brkić (mentor)
• Committee member: Ljiljana Brkić (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: 2024-07-05, Croatia

Abstract

Ovaj diplomski rad bavi se usporedbom performansi relacijskog sustava MySQL i specijaliziranog sustava za pohranu vremenskih serija InfluxDB u kontekstu obrade podataka za dijagnostiku vibracijskog stanja rotirajućih strojeva. Provedena je analiza sustava AAnT razvijenog u firmi Veski. Opisuju se ključni pojmovi i koncepti u InfluxDB-u. Razvijena su četiri pristupa modeliranju podataka u InfluxDB-u te provedeni testovi performansi nad jednostavnim upitima te upitima tipičnim za promatrani sustav te doneseni zaključci o isplativosti zamjene MySQL-a s InfluxDB-om u promatranom slučaju. Na kraju je razvijena jednostavna aplikacija koja povezuje postojeće AAnT korisničko sučelje s InfluxDB bazom podataka.

Abstract (english)

This thesis focused on comparing the performance of the relational database system MySQL with the specialized time series database system InfluxDB in the context of processing data for diagnosing the vibrational condition of rotating machinery. An analysis was conducted on the AAnT system developed by the company Veski. Key concepts and principles of InfluxDB were described. Four different approaches to data modelling in InfluxDB were developed, and performance tests were conducted on both simple queries and queries typical for the observed system. Conclusions were drawn regarding the feasibility of replacing MySQL with InfluxDB in the given scenario. Finally, a simple application was developed to connect the existing AAnT user interface with the InfluxDB database.

• Keywords: MySQL; relacijske baze podataka; vremenske serije podataka; InfluxDB; testiranje performansi
• Keywords (english): MySQL; relational databases; time series data; InfluxDB; performance testing
• Language: croatian
• URN:NBN: urn:nbn:hr:168:780727
• 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: 2024-10-12 21:24:03