Naslov
Geolocation and Data Type Impact on SQL Query Execution Time Using Different Database Approaches

Autori
Šimenić, Kristijan ; Lukić, Ivica ; Köhler, Mirko

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

Izvornik
Proceedings of 38th International Convention MIPRO 2015 / Biljanović, Petar - Rijeka : Hrvatska udruga za informacijsku i komunikacijsku tehnologiju, elektroniku i mikroelektroniku - MIPRO, 2015, 1225-1228

ISBN
978-953-233-083-0

Skup
38th international convention on information and communication technology, electronics and microelectronics

Mjesto i datum
Opatija, Hrvatska, 25.05.2015. - 29.05.2015

Vrsta sudjelovanja
Predavanje

Vrsta recenzije
Međunarodna recenzija

Ključne riječi
Database; query execution; optimisation; round-trip time; geolocation

Sažetak
Picking right database approach or connection – Application Programming Interface in PHP used to achieve connection to database server, together with database and table definition affects query execution time. Servers are located in different geographical positions affecting roundtrip time (RTT). Four different database connections are used together with queries consisted of same data trying to point time difference using PHP and MySQL database server. Most common data structures are tested both for time difference and needed storage space. Combining data types and choosing a good database connection in terms of simplicity, security and time needed for execution, lead towards saving space and time. Time and storage problems often occurs when operating with large amount of data which will be case in this paper. Also, providing facts and results, best database connection and table optimization in default database configuration are given. Later optimization can be achieved in terms of choosing different database engines for specific needs.

Izvorni jezik
Engleski

Znanstvena područja
Računarstvo

Napomena
Rad sa studentom

POVEZANOST RADA