SQL query execution time between two Singidunum University locations

Keywords:
Vincenty’s formulae, great circle formula, haversine formula, geolocation, location determination.

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

Copy to clipboard

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

Copy to clipboard

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