Naslov
Query Optimization in Relational Database Systems

Autori
Crnjak, Anamarija ; Jaksic, Danijela ; Poscic, Patrizia

Vrsta, podvrsta i kategorija rada
Radovi u zbornicima skupova, cjeloviti rad (in extenso), stručni

Izvornik
Proceedings of 42nd International Convention on Information and Communication Technology, Electronics and Microelectronics - MIPRO / Skala, Karolj - Rijeka : Hrvatska udruga za informacijsku i komunikacijsku tehnologiju, elektroniku i mikroelektroniku - MIPRO, 2019, 1904-1909

Skup
42nd International Convention on Information and Communication Technology, Electronics and Microelectronics (MIPRO 2019)

Mjesto i datum
Opatija, Hrvatska, 20.05.2019. - 24.05.2019

Vrsta sudjelovanja
Predavanje

Vrsta recenzije
Međunarodna recenzija

Ključne riječi
query optimization ; relational system ; optimizer ; join ; SQL ; subquery ; function ; database

Sažetak
Query optimization is an important component in relational systems and has gained great importance since the '80s. Sometimes, the reason for a slow query response time is the system load, but the more common one is that the query is written in a way that can not be performed efficiently. Query optimization requires a series of actions and procedures to get the desired result. The aim of this paper is to present and describe some of the more familiar and prominent methods and techniques of query optimization in relational database systems.

Izvorni jezik
Engleski

Znanstvena područja
Informacijske i komunikacijske znanosti

POVEZANOST RADA