Oblikovanje i izvođenje raspodijeljenih SQL upita u aplikacijama izvodivim na skupu računalnih oblaka

master's thesis

• Title (english): Design and Execution of Distributed SQL Queries in Multi-Cloud Applications
• Author: Iva Jurković
• Mentor: Dejan Škvorc (mentor)
• Committee member: Dejan Škvorc (predsjednik povjerenstva)
• Committee member: Stjepan Groš (član povjerenstva)
• Committee member: Krešimir Pripužić (član povjerenstva)
• Granter: University of Zagreb; Faculty of Electrical Engineering and Computing; Zagreb
• Defense date and country: 2019-07-18, Croatia
• Scientific / art field, discipline and subdiscipline: TECHNICAL SCIENCES; Computing

Abstract

Multi Cloud Rewriter je sustav za izvođenje raspodijeljenih SQL upita nad podacima
razmještenim u skupu računalnih oblaka. Prilikom dolaska upita na ulaz, sustav ga
provodi kroz interni postupak raspodjele i šalje raspodijeljene upite na fragmente. Uz
to, skuplja rezultate raspodijeljenih upita, objedinjuje ih i vraća korisniku kao da se
operacija obavila na jedinstvenom mjestu obrade. Za njegovo ostvarenje, korišten je
sustav Apache Calcite koji pomaže u posredovanju izmedđu aplikacije koja ima više
mjesta pohrane podataka, te posjeduje fleksibilan i proširiv optimizator upita.

Abstract (english)

Multi Cloud Rewriter is a system for performing distributed SQL queries over data
deployed in a multi cloud environment. When input query comes, the system pushes
it through the internal dividing process and sends distributed queries to the fragments.
Additionally, it collects the results of distributed queries, combines them and returns
them to the user as if the operation was performed at a unique processing location. For
its realization, the Apache Calcite system is used to help mediate between multiple
data storage sites and because it has a flexible and expandable query optimizer.

• Keywords: raspodijeljene baze podataka; obrada upita; raˇcunarstvo u oblaku; SQL
• Keywords (english): distributed databases; query processing; cloud computing; SQL
• Language: croatian
• URN:NBN: urn:nbn:hr:168:383821
• 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: 2020-01-07 18:54:17