SQL query execution time between two Singidunum University locations

Izdanje: Synthesis 2015 - International Scientific Conference of IT and Business-Related Research

DOI: 10.15308/Synthesis-2015-624-628

Link: https://doi.org/10.15308/Synthesis-2015-624-628

Apstrakt:
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.
Ključne reči: Vincenty’s formulae, great circle formula, haversine formula, geolocation, location determination.

Preuzimanje citata:

BibTeX format
@article{article,
  author  = {Jovanović, V., Lazović, V., Minić, N.}, 
  title   = {SQL query execution time between two Singidunum University locations},
  journal = {Synthesis 2015 - International Scientific Conference of IT and Business-Related Research},
  year    = 2015,
  doi     = {10.15308/Synthesis-2015-624-628}
}
RefWorks Tagged format
RT Conference Proceedings
A1 Verka Jovanović
A1 Vladimir Lazović
A1 Nikola Minić
T1 SQL query execution time between two Singidunum University locations
AD International Scientific Conference Sinteza, Beograd, Srbija
YR 2015
NO doi: 10.15308/Synthesis-2015-624-628
Unapred formatirani prikaz citata
Jovanović, V., Lazović, V., Minić, N., SQL query execution time between two Singidunum University locations, International Scientific Conference Sinteza, 2015, doi:10.15308/Synthesis-2015-624-628