Usporedba sustava Elasticsearch i SQL Server kod pohrane i dohvata podataka

master's thesis

• Title (english): Comparison of Elasticsearch and SQL Server in storing and retrieving data
• Author: Fran Hercigonja
• Mentor: Boris Vrdoljak (mentor)
• Committee member: Boris Vrdoljak (predsjednik povjerenstva)
• Committee member: Mario Brčić (član povjerenstva)
• Committee member: Marina Bagić Babac (član povjerenstva)
• Granter: University of Zagreb; Faculty of Electrical Engineering and Computing; Zagreb
• Defense date and country: 2020-07-09, Croatia
• Scientific / art field, discipline and subdiscipline: TECHNICAL SCIENCES; Computing

Abstract

U radu je provedena usporedba sustava SQL Server i Elasticsearch u radu s podacima iz domene metalske industrije i zapisima dnevnika. Opisana je arhitektura pojedinog sustava, zatim pohrana i dohvat podataka te usluge koje sustavi pružaju. Implementirana je programska podrška za Elasticsearch u .NET okruženju kojom se može manipulirati podacima. Podrška se koristi u usporedbi dvaju sustava za koju su definirani parametri usporedbe te opisno i grafički izneseni rezultati. Na kraju rada provedena je analiza korištenih sustava i predložene su situacije i načini upotrebe korištenih sustava.

Abstract (english)

The thesis compares SQL Server and Elasticsearch in working with metal industry domain and log data. The architecture of both systems is described, as well as the storage and retrieval of data and the services provided by the systems. Program support for Elasticsearch for dana manipulation has been implemented in a .NET environment. It is used in the comparison of two systems for which the parameters of the comparison are defined and the results are described descriptively and graphically. At the end of the paper, an analysis of the used systems was performed and situations and ways of using the used systems were proposed.

• Keywords: Elasticsearch; C#; SQL Server; .NET; usporedba; zapisi dnevnika; Nest; spajanja
• Keywords (english): Elasticsearch; C#; SQL Server; .NET; comparison; logging; Nest; joins
• Language: croatian
• URN:NBN: urn:nbn:hr:168:744195
• 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-01-13 12:24:22