crta
Hrvatska znanstvena Sekcija img
bibliografija
3 gif
 Naslovna
 O projektu
 FAQ
 Kontakt
4 gif
Pregledavanje radova
Jednostavno pretraživanje
Napredno pretraživanje
Skupni podaci
Upis novih radova
Upute
Ispravci prijavljenih radova
Ostale bibliografije
Slični projekti
 Bibliografske baze podataka

Pregled bibliografske jedinice broj: 768883

Zbornik radova

Autori: Šimenić, Kristijan; Lukić, Ivica; Köhler, Mirko
Naslov: Geolocation and Data Type Impact on SQL Query Execution Time Using Different Database Approaches
( Geolocation and Data Type Impact on SQL Query Execution Time Using Different Database Approaches )
Izvornik: Proceedings of 38th International Convention MIPRO 2015 / Biljanović, Petar (ur.). - 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.
Ključne riječi: Database; query execution; optimisation; round-trip time; geolocation
( 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.
Vrsta sudjelovanja: Predavanje
Vrsta prezentacije u zborniku: Cjeloviti rad (više od 1500 riječi)
Vrsta recenzije: Međunarodna recenzija
Izvorni jezik: eng
Kategorija: Znanstveni
Znanstvena područja:
Računarstvo
URL Internet adrese: http://docs.mipro-proceedings.com/proceedings/mipro_2015_proceedings.pdf
Upisao u CROSBI: Ivica Lukić (ivica.lukic@etfos.hr), 10. Srp. 2015. u 10:48 sati
Napomene:
Rad sa studentom



Verzija za printanje   za tiskati


upomoc
foot_4