Skip to main content

A Generic and Efficient Framework for Spatial Indexing on Flash-Based Solid State Drives

  • Conference paper
  • First Online:
Advances in Databases and Information Systems (ADBIS 2017)

Abstract

Speeding up the spatial query processing on flash-based Solid State Drives (SSDs) has become a core problem in spatial database applications, and has been carried out aided by flash-aware spatial indices. Although there are some existing flash-aware spatial indices, they do not exploit all the benefits of SSDs, leading to loss of efficiency. In this paper, we propose a new generic and efficient Framework for spatial INDexing on SSDs, called eFIND. It takes into account all the intrinsic characteristics of SSDs by employing (i) a write buffer to avoid random writes; (ii) a read buffer to decrease the overhead of random reads; (iii) a temporal control to avoid interleaved reads and writes; (iv) a flushing policy based on the characteristics of the indexed spatial objects; and (v) a log-structured approach to provide data durability. Performance tests showed that eFIND is very efficient. Compared to existing indices, eFIND improved the construction of spatial indices from 22% up to 68% and the spatial query processing from 3% up to 50%.

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 39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.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.

    http://www.openstreetmap.org/.

  2. 2.

    http://gbd.dc.ufscar.br/festival/.

References

  1. Carniel, A.C., Ciferri, R.R., Ciferri, C.D.A.: Experimental evaluation of spatial indices with FESTIval. In: Brazilian Symposium on Databases - Demonstration Track, pp. 123–128 (2016)

    Google Scholar 

  2. Carniel, A.C., Ciferri, R.R., Ciferri, C.D.A.: The performance relation of spatial indexing on hard disk drives and solid state drives. In: Brazilian Symposium on GeoInformatics, pp. 263–274 (2016)

    Google Scholar 

  3. Chen, F., Koufaty, D.A., Zhang, X.: Understanding intrinsic characteristics and system implications of flash memory based solid state drives. In: International Conference on Measurement and Modeling of Computer Systems, pp. 181–192 (2009)

    Google Scholar 

  4. Gaede, V., Günther, O.: Multidimensional access methods. ACM Comput. Surv. 30(2), 170–231 (1998)

    Article  Google Scholar 

  5. Guttman, A.: R-trees: A dynamic index structure for spatial searching. In: ACM SIGMOD International Conference on Management of Data, pp. 47–57 (1984)

    Google Scholar 

  6. Jin, P., Xie, X., Wang, N., Yue, L.: Optimizing R-tree for flash memory. Expert Syst. Appl. 42(10), 4676–4686 (2015)

    Article  Google Scholar 

  7. Jung, M., Kandemir, M.: Revisiting widely held SSD expectations and rethinking system-level implications. In: International Conference on Measurement and Modeling of Computer Systems, pp. 203–216 (2013)

    Google Scholar 

  8. Lv, Y., Li, J., Cui, B., Chen, X.: Log-compact R-tree: an efficient spatial index for SSD. In: International Conference on Database Systems for Advanced Applications, pp. 202–213 (2011)

    Google Scholar 

  9. Mittal, S., Vetter, J.S.: A survey of software techniques for using non-volatile memories for storage and main memory systems. IEEE Trans. Parallel Distrib. Syst. 27(5), 1537–1550 (2016)

    Article  Google Scholar 

  10. Sarwat, M., Mokbel, M.F., Zhou, X., Nath, S.: Generic and efficient framework for search trees on flash memory storage systems. GeoInformatica 17(3), 417–448 (2013)

    Article  Google Scholar 

  11. Wu, C.H., Chang, L.P., Kuo, T.W.: An efficient R-tree implementation over flash-memory storage systems. In: ACM SIGSPATIAL International Conference on Advances in Geographic Information Systems, pp. 17–24 (2003)

    Google Scholar 

Download references

Acknowledgments

This work has been supported by CAPES, CNPq, and FAPESP. A. C. Carniel has been supported by the grant #2015/26687-8, FAPESP. R. R. Ciferri has been supported by the grant #311868/2015-0, CNPq.

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Anderson Chaves Carniel .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2017 Springer International Publishing AG

About this paper

Cite this paper

Carniel, A.C., Ciferri, R.R., de Aguiar Ciferri, C.D. (2017). A Generic and Efficient Framework for Spatial Indexing on Flash-Based Solid State Drives. In: Kirikova, M., Nørvåg, K., Papadopoulos, G. (eds) Advances in Databases and Information Systems. ADBIS 2017. Lecture Notes in Computer Science(), vol 10509. Springer, Cham. https://doi.org/10.1007/978-3-319-66917-5_16

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-66917-5_16

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-66916-8

  • Online ISBN: 978-3-319-66917-5

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics