prikaz prve stranice dokumenta Razmatranje utjecaja geolokacije i tipa podataka na vrijeme trajanja SQL upita
  Download
PDF 164.57 KB
undergraduate thesis
Razmatranje utjecaja geolokacije i tipa podataka na vrijeme trajanja SQL upita
Osijek: Josip Juraj Strossmayer University of Osijek, Faculty of Electrical Engineering, Computer Science and Information Technology Osijek, 2015. urn:nbn:hr:200:729139
Šimenić, Kristijan
Josip Juraj Strossmayer University of Osijek
Faculty of Electrical Engineering, Computer Science and Information Technology Osijek
Department of Computer Engineering and Automation
Chair of Computer Engineering

Institutional repository: Faculty of Electrical Engineering, Computer Science and Information Technology Osijek

Cite this document

Šimenić, K. (2015). Razmatranje utjecaja geolokacije i tipa podataka na vrijeme trajanja SQL upita (Undergraduate thesis). Osijek: Josip Juraj Strossmayer University of Osijek, Faculty of Electrical Engineering, Computer Science and Information Technology Osijek. Retrieved from https://urn.nsk.hr/urn:nbn:hr:200:729139

Šimenić, Kristijan. "Razmatranje utjecaja geolokacije i tipa podataka na vrijeme trajanja SQL upita." Undergraduate thesis, Josip Juraj Strossmayer University of Osijek, Faculty of Electrical Engineering, Computer Science and Information Technology Osijek, 2015. https://urn.nsk.hr/urn:nbn:hr:200:729139

Šimenić, Kristijan. "Razmatranje utjecaja geolokacije i tipa podataka na vrijeme trajanja SQL upita." Undergraduate thesis, Josip Juraj Strossmayer University of Osijek, Faculty of Electrical Engineering, Computer Science and Information Technology Osijek, 2015. https://urn.nsk.hr/urn:nbn:hr:200:729139

Šimenić, K. (2015). 'Razmatranje utjecaja geolokacije i tipa podataka na vrijeme trajanja SQL upita', Undergraduate thesis, Josip Juraj Strossmayer University of Osijek, Faculty of Electrical Engineering, Computer Science and Information Technology Osijek, accessed 16 January 2025, https://urn.nsk.hr/urn:nbn:hr:200:729139

Šimenić K. Razmatranje utjecaja geolokacije i tipa podataka na vrijeme trajanja SQL upita [Undergraduate thesis]. Osijek: Josip Juraj Strossmayer University of Osijek, Faculty of Electrical Engineering, Computer Science and Information Technology Osijek; 2015 [cited 2025 January 16] Available at: https://urn.nsk.hr/urn:nbn:hr:200:729139

K. Šimenić, "Razmatranje utjecaja geolokacije i tipa podataka na vrijeme trajanja SQL upita", Undergraduate thesis, Josip Juraj Strossmayer University of Osijek, Faculty of Electrical Engineering, Computer Science and Information Technology Osijek, Osijek, 2015. Available at: https://urn.nsk.hr/urn:nbn:hr:200:729139

Metadata
TitleRazmatranje utjecaja geolokacije i tipa podataka na vrijeme trajanja SQL upita
Title (english)Geolocation and Data Type Impact on SQL Query Execution Time Using Different Database Approaches
AuthorKristijan Šimenić
MentorIvica Lukić (mentor)
MentorMirko Kohler (mentor)
Committee memberIvica Lukić (predsjednik povjerenstva)
Committee memberHrvoje Glavaš (član povjerenstva)
Committee memberJosip Job (član povjerenstva)
GranterJosip Juraj Strossmayer University of Osijek
Faculty of Electrical Engineering, Computer Science and Information Technology Osijek
(Department of Computer Engineering and Automation)
(Chair of Computer Engineering)
Osijek
Defense date and country2015-07-09, Croatia
Scientific / art field,
discipline and subdiscipline		TECHNICAL SCIENCES
Computing
Program Engineering
Abstract
U radu je promatran odabir sučelja, definicija baze podataka i tablica unutar njih te utjecaj istih na vrijeme izvršavanja upita. Korišteni su poslužitelji locirani na različitim geografskim mjestima. Četiri sučelja za pristupanje bazi podataka i izvršavanje upita korištena su prilikom izvršavanja jednakih upita za prikaz temeljnih razlika između sučelja. Najučestalije strukture podataka (atributi) testirani su razlikom prilikom dohvaćanja i potrebnom mjestu za skladištenje podataka. Uz iznošenje činjenica i rezultata, dane su najbolje metode odabira sučelja i optimizacije tablica u osnovnim postavkama baze podataka. Zaključeno je da treba biti u nastojanju izbjegavati MySQL sučelje te odabrati između MySQLi i PDO sučelja ovisno o potrebama korisnika. Također, prilikom definiranja atributa unutar tablica, objašnjeno je zašto je potrebno povesti brigu o odabiru te su prikazane razlike prilikom korištenja istovrsnih atributa.
Abstract (english)
Picking right database approach together with database and table definition alternates query execution time. Servers are located in different geographical positions affecting round-trip time (RTT). Four methods for database approach and query execution are used in queries consisted of same data trying to point time difference. Most common data structures are tested both for time difference and needed storage space. Combining data types and choosing a good database approach 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 methods for database approach and table optimization in default database setup are given. Later optimization can be achieved in terms of choosing different database engines for specific needs.
Keywords
Keywords (english)
Languagecroatian
URN:NBNurn:nbn:hr:200:729139
Study programmeTitle: Undergraduate University Study Programme in Computer Engineering
Study programme type: university
Study level: undergraduate
Academic / professional title: sveučilišni/a prvostupnik/ prvostupnica (baccalaureus/baccalaurea) inženjer/inženjerka računarstva (sveučilišni/a prvostupnik/ prvostupnica (baccalaureus/baccalaurea) inženjer/inženjerka računarstva)
Type of resourceText
File originBorn digital
Access conditionsOpen access
Terms of useLicence In copyright icon
Created on2016-08-01 11:09:34