SQL QUERY EXECUTION TIME BETWEEN TWO SINGIDUNUM UNIVERSITY LOCATIONS




Abstract:
The paper presents the creation of SQL queries using mathematical functions that provide the distance between the two points in the shortest time possible and at a highest level of accuracy. The research shows that one of the three most commonly used formulae demonstrated the highest level of accuracy. Haversin formula, which has showed satisfactory accuracy, has been converted into a SQL query where the query execution time was tested. In order to get the information about the location as quickly as possible, the query was expanded with a request to search for the locations within the predefined radius starting from the given coordinates. The aim of this research was to use the results obtained for the purpose of modern mobile phone applications development.

CITATION:

IEEE format

V. Jovanović, V. Lazović, N. Minić, “SQL query execution time between two Singidunum University locations,” in Synthesis 2015 - International Scientific Conference of IT and Business-Related Research, Belgrade, Singidunum University, Serbia, 2015, pp. 624-628. doi: 10.15308/Synthesis-2015-624-628 

APA format

Jovanović, V., Lazović, V., Minić, N. (2015). SQL query execution time between two Singidunum University locations. Paper presented at Synthesis 2015 - International Scientific Conference of IT and Business-Related Research. doi:10.15308/Synthesis-2015-624-628

BibTeX format
Download

RefWorks Tagged format
Download