Napredna pretraga

Pregled bibliografske jedinice broj: 768883

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


Šimenić, Kristijan; Lukić, Ivica; Köhler, Mirko
Geolocation and Data Type Impact on SQL Query Execution Time Using Different Database Approaches // Proceedings of 38th International Convention MIPRO 2015 / Biljanović, Petar (ur.).
Rijeka: Croatian Society for Information and Communication Technology, Electronics and Microelectronics - MIPRO, 2015. str. 1225-1228 (predavanje, međunarodna recenzija, cjeloviti rad (in extenso), znanstveni)


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 : Croatian Society for Information and Communication Technology, Electronics and Microelectronics - 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-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


Ustanove
Fakultet elektrotehnike, računarstva i informacijskih tehnologija Osijek