Skip to main content

Compact Data Structures for Efficient Processing of Distance-Based Join Queries

  • Conference paper
  • First Online:
Model and Data Engineering (MEDI 2022)

Abstract

Compact data structures can represent data with usually a much smaller memory footprint than its plain representation. In addition to maintaining the data in a form that uses less space, they allow us to efficiently access and query the data in its compact form. The \(k^2\)-tree is a self-indexed, compact data structure used to represent binary matrices, that can also be used to represent points in a spatial dataset. Efficient processing of the Distance-based Join Queries (DJQs) is of great importance in spatial databases due to its wide area of application. Two of the most representative and known DJQs are the K Closest Pairs Query (KCPQ) and the \(\varepsilon \) Distance Join Query (\(\varepsilon \)DJQ). These types of join queries are executed over two spatial datasets and can be solved by plane-sweep algorithms, which are efficient but with great requirements of RAM, to be able to fit the whole datasets into main memory. In this work, we present new and efficient algorithms to implement DJQs over the \(k^2\)-tree representation of the spatial datasets, experimentally showing that these algorithms are competitive in query times, with much lower memory requirements.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 54.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 69.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Notes

  1. 1.

    Available at http://spatialhadoop.cs.umn.edu/datasets.html.

  2. 2.

    Available at https://gitlab.lbd.org.es/public-sources/djq/k2tree-djq.

  3. 3.

    Available at https://github.com/simongog/sdsl-lite.

References

  1. Brisaboa, N.R., Ladra, S., Navarro, G.: Compact representation of web graphs with extended functionality. Inf. Syst. 39(1), 152–174 (2014)

    Article  Google Scholar 

  2. Brisaboa, N.R., Cerdeira-Pena, A., de Bernardo, G., Navarro, G.: Óscar Pedreira: extending general compact querieable representations to GIS applications. Inf. Sci. 506, 196–216 (2020)

    Article  Google Scholar 

  3. Corral, A., Manolopoulos, Y., Theodoridis, Y., Vassilakopoulos, M.: Algorithms for processing k-closest-pair queries in spatial databases. Data Knowl. Eng. 49(1), 67–104 (2004)

    Article  Google Scholar 

  4. Álvarez García, S., Brisaboa, N., Fernández, J.D., Martínez-Prieto, M.A., Navarro, G.: Compressed vertical partitioning for efficient RDF management. Knowl. Inf. Syst. 44(2), 439–474 (2015)

    Google Scholar 

  5. García-García, F., Corral, A., Iribarne, L., Vassilakopoulos, M., Manolopoulos, Y.: Efficient distance join query processing in distributed spatial data management systems. Inf. Sci. 512, 985–1008 (2020)

    Article  Google Scholar 

  6. Gutiérrez, G., Sáez, P.: The k closest pairs in spatial databases - when only one set is indexed. GeoInformatica 17(4), 543–565 (2013)

    Article  Google Scholar 

  7. Kim, Y.J., Patel, J.M.: Performance comparison of the R*-tree and the quadtree for kNN and distance join queries. IEEE Trans. Knowl. Data Eng. 22(7), 1014–1027 (2010)

    Article  Google Scholar 

  8. Mamoulis, N.: Spatial Data Management. Synthesis Lectures on Data Management. Morgan & Claypool Publishers (2012)

    Google Scholar 

  9. Navarro, G.: Compact Data Structures: A Practical Approach. Cambridge University Press, USA (2016)

    Book  Google Scholar 

  10. Roumelis, G., Vassilakopoulos, M., Corral, A., Manolopoulos, Y.: A new plane-sweep algorithm for the k-closest-pairs query. In: SOFSEM, pp. 478–490 (2014)

    Google Scholar 

  11. Santolaya, F., Caniupán, M., Gajardo, L., Romero, M., Torres-Avilés, R.: Efficient computation of spatial queries over points stored in k\({}^{{2}}\)-tree compact data structures. Theoret. Comput. Sci. 892, 108–131 (2021)

    Article  MathSciNet  MATH  Google Scholar 

Download references

Acknowledgments

Guillermo de Bernardo, Miguel R. Penabad and Nieves R. Brisaboa are partially funded by: MCIN/AEI [PDC2021-121239-C31 (FLATCITY-POC), PDC2021-120917-C21 (SIGTRANS, NextGenerationEU/PRTR), PID2020-114635RB-I00 (EXTRACompact), PID2019-105221RB-C41 (MAGIST)]; ED431C 2021/53 (GRC), GAIN/Xunta de Galicia; and as CITIC members are also partially funded by ED431G 2019/01 (CSI), Xunta de Galicia, FEDER Galicia 2014–2020. The work by Antonio Corral was partially funded by the EU ERDF and the Andalusian Government (Spain) under the project UrbanITA (ref. PY20_00809) and the Spanish Ministry of Science and Innovation under the R &D project HERMES (ref. PID2021-124124OB-I00).

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Miguel R. Penabad .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2023 The Author(s), under exclusive license to Springer Nature Switzerland AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Bernardo, G.d., Penabad, M.R., Corral, A., Brisaboa, N.R. (2023). Compact Data Structures for Efficient Processing of Distance-Based Join Queries. In: Fournier-Viger, P., Hassan, A., Bellatreche, L. (eds) Model and Data Engineering. MEDI 2022. Lecture Notes in Computer Science, vol 13761. Springer, Cham. https://doi.org/10.1007/978-3-031-21595-7_15

Download citation

  • DOI: https://doi.org/10.1007/978-3-031-21595-7_15

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-031-21594-0

  • Online ISBN: 978-3-031-21595-7

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics