diplomsko delo
Nina Ramšak (Author), Marko Bajec (Mentor)

Abstract

Diplomsko delo se osredotoča na metode optimizacije poizvedb SQL. Kot uvod v optimizacijo predstavimo modeliranje s podatki in podatkovne baze. Prav tako namenimo poglavje jeziku SQL, kjer navedemo vse njegove značilnosti, sintakso in način pisanja poizvedb. V nadaljevanju preučimo številne metode za optimizacijo poizvedb SQL z vidika uporabnika, torej samo sintakso. Naredimo končen povzetek, kjer predstavimo posamezne problematične komponente poizvedb in načine, kako jih nadomestiti oziroma izboljšati uporabo. Teorijo nato preizkusimo v praksi na treh različno težavnih primerih. Podano imamo poslovno zahtevo, ki jo implementiramo v obliki poizvedbe SQL na okolju Snowflake. Prvotno poizvedbo nato poskusimo sintaktično popraviti, izboljšati tako, da se sklicujemo na predstavljeno teorijo optimizacije. Po optimizaciji se vsi trije testni primeri izvedejo hitreje, torej smo dokazali, da način pisanja poizvedb vpliva na njihovo zmogljivost.

Keywords

poizvedba;podatkovna baza;optimizacija;računalništvo in informatika;univerzitetni študij;diplomske naloge;

Data

Language: Slovenian
Year of publishing:
Typology: 2.11 - Undergraduate Thesis
Organization: UL FRI - Faculty of Computer and Information Science
Publisher: [N. Ramšak]
UDC: 004.655.3(043.2)
COBISS: 164181251 Link will open in a new window
Views: 8
Downloads: 5
Average score: 0 (0 votes)
Metadata: JSON JSON-RDF JSON-LD TURTLE N-TRIPLES XML RDFA MICRODATA DC-XML DC-RDF RDF

Other data

Secondary language: English
Secondary title: SQL Query Optimization
Secondary abstract: The diploma thesis focuses on SQL query optimization methods. As an introduction to optimization, we introduce data modeling and databases. We also dedicate a chapter to the SQL language, where we list all its features, its syntax, and the way queries are written. In the next chapter, we examine a number of methods for optimizing SQL queries from the user’s point of view, i.e., the syntax itself. We make a final summary where we present the individual problematic components of the queries and ways to replace them or improve their use. We then test the theory in practice on three different cases of varying difficulty. Given the business requirement, we implement it as an SQL query in the Snowflake environment. We then try to syntactically correct and improve the original query by referring to the presented optimization theory. After optimization, all three test cases are executed faster, so we have shown that the way queries are written affects their performance.
Secondary keywords: SQL;query;database;optimization;computer science;computer and information science;diploma;SQL (programski jezik);Računalništvo;Univerzitetna in visokošolska dela;
Type (COBISS): Bachelor thesis/paper
Study programme: 1000468
Embargo end date (OpenAIRE): 1970-01-01
Thesis comment: Univ. v Ljubljani, Fak. za računalništvo in informatiko
Pages: 77 str.
ID: 19904951