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%.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
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)
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)
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)
Gaede, V., Günther, O.: Multidimensional access methods. ACM Comput. Surv. 30(2), 170–231 (1998)
Guttman, A.: R-trees: A dynamic index structure for spatial searching. In: ACM SIGMOD International Conference on Management of Data, pp. 47–57 (1984)
Jin, P., Xie, X., Wang, N., Yue, L.: Optimizing R-tree for flash memory. Expert Syst. Appl. 42(10), 4676–4686 (2015)
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)
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)
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)
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)
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)
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
Corresponding author
Editor information
Editors and Affiliations
Rights 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)