Analiza učinkovitosti i integracija sustava za raspodijeljeno izvođenje SQL upita

master's thesis

• Title (english): Performance Analysis and Integration of Distributed SQL Query Engine
• Author: Bruno Marović
• Mentor: Klemo Vladimir (mentor)
• Committee member: Klemo Vladimir (predsjednik povjerenstva)
• Committee member: Marin Šilić (član povjerenstva)
• Committee member: Goran Delač (član povjerenstva)
• Granter: University of Zagreb; Faculty of Electrical Engineering and Computing; Zagreb
• Defense date and country: 2023-07-04, Croatia
• Scientific / art field, discipline and subdiscipline: TECHNICAL SCIENCES; Computing

Abstract

Trino je sustav za raspodijeljeno izvođenje SQL upita otvorenog koda, osmišljen za brzu i interaktivnu analizu podataka. Ključna snaga Trinoa leži u njegovoj sposobnosti rukovanja velikom obradom podataka i pružanja odgovora na upite u stvarnom vremenu, što ga čini popularnim izborom za organizacije koje žele izvući uvide iz golemih količina podataka. U ovom radu napravljena je analiza učinkovitosti sustava za nekoliko različitih slučaja upotrebe te je ostvaren pokazni primjer integracije Trinoa u moderni podatkovni cjevovod. Dobiveni rezultati i zaključci doprinose boljem razumijevanju karakteristika Trinoa i pružaju dragocjene uvide za optimizaciju cjevovoda za obradu podataka u modernim podatkovnim arhitekturama.

Abstract (english)

Trino is an open-source distributed SQL query engine designed for fast and interactive data analysis. Trino's key strength lies in its ability to handle large data processing and provide real-time query responses, making it a popular choice for organizations looking to extract insights from vast amounts of data. In this paper, an analysis of the system's performance was made for several different use cases, and a demonstrative example was presented of the integration of Trino into a modern data pipeline. The obtained results and conclusions contribute to a better understanding of the characteristics of Trino and provide valuable insights for the optimization of data processing pipelines in modern data architectures.

• Keywords: sustav za izvođenje SQL upita; raspodijeljeni sustav; obrada podataka; podatkovni cjevovod; analiza učinkovitosti
• Keywords (english): SQL query engine; distributed system; data processing; data pipeline; performance analysis
• Language: croatian
• URN:NBN: urn:nbn:hr:168:779527
• 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: 2023-10-11 09:43:30