Razvoj jezika za iskanje, povezovanje in predstavitev podatkov

ŠTUKELJ, ERNEST (author), Dobravec, Tomaž (mentor)

Cilj diplomske naloge je bil izboljšanje sistema Algator v delu, ki se ukvarja z analizo in predstavitvijo podatkov. Najprej smo primerjali nekaj poizvedovalnih jezikov, da bi našli čim bolj primernega za uporabo v sistemu Algator. Algator shranjuje podatke v točno določeno obliko, podatki pa se združujejo vedno na enak način, zato je lasten poizvedovalni jezik bolj primeren, ker lahko upošteva te lastnosti. Določili smo poenostavljeno sintakso SQL in jo uporabili v sistemu Algator. Za pisanje poizvedb je bil razvit uporabniški vmesnik in pretvornik poizvedb iz formata JSON v poenostavljen SQL ter obratno. Izvedba poizvedb je bila optimizirana, ker so nekatere poizvedbe trajale predolgo. Dodana je bila funkcionalnost izračunanih polj, ki omogočajo, da v rezultat poizvedb dodamo še polja, ki so izračunana iz ostalih polj.

• Language: Slovenian
• Keywords: Algator, poizvedovalni jeziki, SQL, LINQ, XQuery, optimizacija
• Work type: Undergraduate thesis
• Organization: FRI - Faculty of Computer and Information Science
• Year: 2016
• PID: 20.500.12556/RUL-85138
• Publication date in RUL: 13.09.2016

Secondary language

• Language: English
• Title: Development of query language for retrieval, integration and presentation of data

Abstract

The aim of this work was to improve the system Algator in the part, which deals with the analysis and presentation of data. First, we compared some query languages to find the most suitable for use in the system Algator. Algator stores data in a specific format, and the data are always combined in the same fashion. Therefore, special query language is more suitable because it can take advantage of these properties. We determined the simplified syntax of SQL and used in the system Algator. User interface and converter from JSON format to a simplified SQL and vice versa has been developed. Execution of queries has been optimized because some inquiries run too long. Functionality of calculated fields has been added, which allows to add additional fields that are calculated from other fields.

• Keywords: Algator, query languages, SQL, LINQ, XQuery, optimization