Abstract
It is crucial for users to find lots of information with time and geographical tags on the Internet. Therefore, a nearest neighbor query method called STR-kNN is proposed. Using the method of calculating the spatiotemporal similarity between two objects, the spatiotemporal variables of the data object are normalized and mapped to the three-dimensional space. The distance similarity between two data objects in the three-dimensional space is used to approximate their actual spatiotemporal similarity. In this way, a three-dimensional STR-tree index is built for the data object in the three-dimensional space. This index can effectively combine the spatial–temporal variables of the data object, ensuring that each data object is traversed no more than once during query processing. Finally, an accurate searching algorithm of STR-kNN is designed to find up to the top-k query results through a single calculation. In the experiment, when the data volume is 6 million, the query times of STR-kNN, 3DR-k NN, and RT-k NN algorithms are 12 ms, 43 ms, and 55 ms respectively. When k is taken as 50, the query times of the three algorithms are 12 ms, 43 ms, and 55 ms, respectively, indicating that the new algorithm can greatly improve the query efficiency.







Similar content being viewed by others
Explore related subjects
Discover the latest articles, news and stories from top researchers in related subjects.References
Peng Y (2019) Research on Spatio-temporal Keywords Query Algorithm for Massive Short Texts. Central South University for Nationalities.
Elashry A, Shehab A, Riad AM, Aboul-Fotouh A (2018) 2DPR-Tree: two-dimensional priority R-tree algorithm for spatial partitioning in spatial hadoop. ISPRS Int J Geo Inf 7(5):179–187. https://doi.org/10.3390/ijgi7050179
Sharifzadeh M, Shahabi C (2010) Vo R-tree: R-trees with Voronoi diagrams for efficient processing of spatial nearest neighbor queries. Proc VLDB Endowment 3(1):1231–1242
Liu QF (2018) Research on the similarity measurement of multi-scale spatial targets. Changsha University of Science and Technology
Li C, Shen DR, Kou Y, Nie TZ, Yu G (2017) Diversity-aware KNN query processing approaches for temporal spatial textual content. Pattern Recognit Artif Intell 30(1):64–72. https://doi.org/10.16451/j.cnki.issn1003-6059.201701007
Deng Z, Wang L, Han W, Ranjan R, Zomaya A (2017) G-ML-Octree: an update-efficient index structure for simulating 3D moving objects across GPUs. IEEE Trans Parallel Distrib Syst 29(5):1075–1088. https://doi.org/10.1109/TPDS.2017.2787747
Wang X, Meng W, Zhang M (2019) A novel information retrieval method based on R-tree index for smart hospital information system. Int J Adv Comput Res (IJACR) 9(42):133–145. https://doi.org/10.19101/IJACR.2019.940030
Zhou AY, Yang B, Jin CQ, Ma Q (2011) Location-Based services: architecture and progress. Chin J Comput 34(7):1155–1171
Zhang D, Chee YM, Mondal A, Tung AK, Kitsuregawa M (2009) Keyword search in spatial databases: Towards searching by document. In: 2009 IEEE 25th International Conference on Data Engineering, Shanghai, China, IEEE, pp 688–699. https://doi.org/10.1109/ICDE.2009.77
Al-Nsour E, Sleit A, Alshraideh M (2019) SOLD: A node-Splitting algorithm for R-tree base on objects’ locations distribution. J Inf Sci 45(2):169–195. https://doi.org/10.1177/0165551518785561
Gong L, Wang H, Ogihara M, Xu J (2020) IDEC: Index able distance estimating codes for approximate nearest neighbor search. Proc VLDB Endow 13(9):1483–1497. https://doi.org/10.1478/3397230.3397243
Zheng B, Xi Z, Weng L, Hung NQV, Liu H, Jensen CS (2020) PM-LSH: A fast and accurate LSH framework for high-dimensional approximate NN search. Proc VLDB Endow 13(5):643–655. https://doi.org/10.14778/3377369.3377374
Yang H, Parthasarathy S, Ucar D (2007) A spatio-temporal mining approach towards summarizing and analyzing protein folding trajectories. Algorithms Mol Biol 2(1):1–16. https://doi.org/10.1186/1748-7188-2-3
Huang Q, Ma G, Feng J, Fang Q, Tung AK (2018) Accurate and Fast Asymmetric Locality-Sensitive Hashing Scheme for Maximum Inner Product Search. In: Proceedings of the 24thACM SIGKDD International Conference on Knowledge Discovery & Data Mining, KDD 2018, London, UK, pp 1561–1570. https://doi.org/10.1145/3219819.3219971
Silva YN, Aref WG, Ali MH (2010) The similarity join database operator. In: 2010 IEEE 26th International Conference on Data Engineering (ICDE 2010), Long Beach, California, USA, IEEE, pp 892–903. https://doi.org/10.1109/ICDE.2010.5447873
Xiao C, Wang W, Lin X, Shang H (2009) Top-k set similarity joins. In: 2009 IEEE 25th International Conference on Data Engineering, Shanghai, China, IEEE, pp 916–927. https://doi.org/10.1109/ICDE.2009.111
Skovsgaard A, Sidlauskas D, Jensen CS (2014) Scalable top-k spatio-temporal term querying. In: 2014 IEEE 30th International Conference on Data Engineering, Chicago, IL, USA, IEEE, pp 148–159. https://doi.org/10.1109/ICDE.2014.6816647
Chen L, Cong G, Cao X, Tan KL (2015) Temporal spatial-keyword top-k publish/subscribe. In: 2015 IEEE 31st International Conference on Data Engineering, Seoul, Korea (South), IEEE, pp 255–266. https://doi.org/10.1109/ICDE.2015.7113289
Gao YJ (2008) Research on key technologies for spatiotemporal database query processing. Zhejiang University, Hangzhou
Wang TM, Li Y, Liang JP (2017) Design and research of spatio-temporal database for smart city. Beijing Surv Mapp 6:72–76. https://doi.org/10.19580/j.cnki.1007-3000.2017.06.017
Li S, Zhang LP, Li S, Hao XH (2019) Spatial skyline query method based on Hilbert R-tree in multi-dimensional space. High Technol Lett 25(3):262–270
Xu G, Li H, Dai Y, Yang K, Lin X (2019) Enabling efficient and geometric range query with access control over encrypted spatial data. IEEE Trans Inf Forensics Secur 14(4):870–885. https://doi.org/10.1109/TIFS.2018.2868162
Theodoridis Y, Vazirgiannis M, Sellis T (1996) Spatio-Temporal Indexing for Large Multimedia Applications. In: Proceedings of the Third IEEE International Conference on Multimedia Computing and Systems, Hiroshima, Japan, IEEE, pp 441–448. https://doi.org/10.1109/MMCS.1996.535011
Pfoser D, Jensen CS, Theodoridis Y (2000) Novel Approaches in Query Processing for Moving Object Trajectories. In: Proceedings of the 26th International Conference on Very Large Data Bases, pp 395–406
Jiyani A, Mahrishi M, Meena Y, Singh G (2021) NAM: a nearest acquaintance modeling approach for VM allocation using R-Tree. Int J Comput Appl 43(3):218–225. https://doi.org/10.1080/1206212X.2018.1514726
Tao Y, Papadias D (2001) MV3R-Tree: A Spatio-Temporal Access Method for Timestamp and Interval Queries. In: Proceedings of Very Large Data Bases Conference (VLDB), pp 431–440
Fort M, Sellarès JA, Valladares N (2019) Nearest and farthest spatial skyline queries under multiplicative weighted Euclidean distances. Knowl-Based Syst 192:105299. https://doi.org/10.1016/j.knosys.2019.105299
Ma Q, Triantafillou P (2019) DBEst: Revisiting Approximate Query Processing Engines with Machine Learning Models. In: Proceedings of the 2019 International Conference on Management of Data, pp 1553–1570. https://doi.org/10.1145/3299869.3324958
Šaltenis S, Jensen CS, Leutenegger ST, Lopez MA (2000) Indexing the positions of continuously moving objects. In: Proceedings of the 2000 ACM SIGMOD international conference on Management of data, pp 331–342. https://doi.org/10.1145/342009.335427
Ke RH, Wu S, Ke WW (2023) A spatial-temporal model for identifying tidal shared-bicycle stops and bicycle sharing demand prediction based on KNN-Light GBM. J Geo-inf Sci 25(4):741–753
Yang HJ (2023) A nearest neighbor classification algorithm based on cluster analysis. Comput Knowl Technol 29(19):30–34
Yang W, Li T, Fang G, Wei H (2020) PASE: Postgresql Ultra-High-Dimensional Approximate Nearest Neighbor Search Extension. In: Proceedings of the 2020 Inter-national Conference on Management of Data, pp 2241–2253. https://doi.org/10.1145/3318464.3386131
Zhang J, Wang W, Jiang X, Ku WS, Lu H (2019) An MBR-Oriented Approach for Efficient Skyline Query Processing. In: 2019 IEEE 35th International Conference on Data Engineering (ICDE), Macao, China, IEEE, pp 806–817. DOI: https://doi.org/10.1109/ICDE.2019.00077
Author information
Authors and Affiliations
Contributions
ZT wrote the original draft, and SQ reviewed and editing the final version.
Corresponding author
Ethics declarations
Conflict of interest
The authors declare they have no financial interests and no Competing Interests.
Additional information
Publisher's Note
Springer Nature remains neutral with regard to jurisdictional claims in published maps and institutional affiliations.
Rights and permissions
Springer Nature or its licensor (e.g. a society or other partner) holds exclusive rights to this article under a publishing agreement with the author(s) or other rightsholder(s); author self-archiving of the accepted manuscript version of this article is solely governed by the terms of such publishing agreement and applicable law.
About this article
Cite this article
Qian, S., Tian, Z. A nearest neighbor query method for searching objects with time and location informations based on spatiotemporal similarity. Evol. Intel. 17, 3031–3041 (2024). https://doi.org/10.1007/s12065-024-00926-7
Received:
Revised:
Accepted:
Published:
Issue Date:
DOI: https://doi.org/10.1007/s12065-024-00926-7