Abstract
In this paper, we present a novel strategy for distributed spatial query optimization that involves multiple sites. Most previous work in the area of distributed spatial query processing and optimization focuses only on strategies for performing spatial joins and spatial semijoins, and distributed spatial queries that only involve two sites. We propose a new strategy, called the Restricted strategy, for optimizing a distributed spatial query. It uses spatial semijoins and can involve any number of sites in a distributed spatial database. The Restricted strategy improves upon an existing strategy by sending group approximations, instead of sending approximations for all objects, in order to reduce the number of comparisons between objects and thereby minimize the CPU and data transmission cost. A performance evaluation of our strategy finds that it significantly minimizes the number of data comparisons and CPU time of distributed spatial queries.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Bloom, B.H.: Space/time trade-offs in hash coding with allowable errors. Communications of the ACM 13, 422–426 (1970)
Abel, D.J., Ooi, B.C., Tan, K.-L., Power, R., Yu, J.X.: Spatial Join Strategies in Distributed Spatial DBMS. In: Egenhofer, M., Herring, J.R. (eds.) SSD 1995. LNCS, vol. 951, pp. 348–367. Springer, Heidelberg (1995)
Apers, P.M.G., Hevner, A.R., Yao, S.B.: Optimization algorithms for distributed queries. IEEE Transactions on Software Engineering 9, 57–68 (1983)
Brinkhoff, T., Kriegel, H.-P., Seeger, B.: Efficient processing of spatial joins using R-trees. In: Proceedings of the 1993 ACM SIGMOD International Conference on Management of Data, New York, USA, pp. 237–246 (1993)
Guttman, A.: R-trees: a dynamic index structure for spatial searching. In: Proceedings of the 1984 ACM SIGMOD International Conference on Management of Data, pp. 47–57 (1984)
Hua, Y., Xiao, B., Wang, J.: BR-Tree: a scalable prototype for supporting multiple queries of multidimensional data. IEEE Transactions on Computers 58, 1585–1597 (2009)
Jacox, E., Samet, H.: Spatial join techniques. ACM Transactions on Database Systems 34, 1–44 (2007)
Kang, M.-S., Ko, S.-K., Koh, K., Choy, Y.-C.: A Parallel Spatial Join Algorithm for Distributed Spatial Databases. In: Andreasen, T., Motro, A., Christiansen, H., Larsen, H.L. (eds.) FQAS 2002. LNCS (LNAI), vol. 2522, pp. 212–225. Springer, Heidelberg (2002)
Karam, O.: Optimizing Distributed Spatial Joins using R-trees. Ph.D. Thesis, Tulane University (2001)
Karam, O., Petry, F.: Optimizing distributed spatial joins using R-trees. In: Proceedings of the 43rd ACM Southeast Regional Conference, pp. 222–226 (2006)
Özsu, M.T., Valduriez, P.: Principles of Distributed Database Systems. Springer, New York (2011)
Osborn, W., Zaamout, S.: Multiple-Site Distributed Spatial Query Optimization using Spatial Semijoins. In: Proceedings of the 10th International Baltic Conference on Databases and Information Systems, Vilnius, Lithuania (2012)
Shekhar, S., Chawla, S.: Spatial Databases: A Tour. Prentice Hall, New Jersey (2003)
Tan, K.-L., Ooi, B.C., Abel, D.J.: Exploiting spatial indexes for semijoin-based join processing in distributed spatial databases. IEEE Transactions on Knowledge and Data Engineering 12, 920–937 (2000)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2013 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Zaamout, S., Osborn, W. (2013). A Strategy for Optimizing a Multi-site Query in a Distributed Spatial Database. In: Liang, S.H.L., Wang, X., Claramunt, C. (eds) Web and Wireless Geographical Information Systems. W2GIS 2013. Lecture Notes in Computer Science, vol 7820. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-37087-8_2
Download citation
DOI: https://doi.org/10.1007/978-3-642-37087-8_2
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-37086-1
Online ISBN: 978-3-642-37087-8
eBook Packages: Computer ScienceComputer Science (R0)