Abstract
Mobile devices like PDAs are capable of retrieving information from various types of services. In many cases, the user requests cannot directly be processed by the service providers, if their hosts have limited query capabilities or the query combines data from various sources, which do not collaborate with each other. In this paper, we present a framework for optimizing spatial join queries that belong to this class. We presume that the connection and queries are ad-hoc, there is no mediator available and the services are non-collaborative. We also assume that the services are not willing to share their statistics or indexes with the client. We retrieve statistics dynamically in order to generate a low-cost execution plan, while considering the storage and computational power limitations of the PDA. Since acquiring the statistics causes overhead, we describe an adaptive algorithm that optimizes the overall process of statistics retrieval and query execution. We demonstrate the applicability of our methods with a prototype implementation on a PDA with wireless network access.
This is a preview of subscription content, log in via an institution to check access.
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
Adali, S., Selçuk Candan, K., Papakonstantinou, Y., Subrahmanian, V.S.: Query caching and optimization in distributed mediator systems. In: Proc. of ACM SIGMOD Int’l Conference (1996)
Arge, L., Procopiuc, O., Ramaswamy, S., Suel, T., Vitter, J.S.: Scalable sweeping-based spatial join. In: Proc. of VLDB Conference (1998)
Brinkhoff, T., Kriegel, H.-P., Seeger, B.: Efficient processing of spatial joins using r-trees. In: Proc. of ACM SIGMOD Int’l Conference (1993)
Corral, A., Manolopoulos, Y., Theodoridis, Y., Vassilakopoulos, M.: Closest pair queries in spatial databases. In: Proc. of ACM SIGMOD Int’l Conference (2000)
Dittrich, J.-P., Seeger, B.: Data redundancy and duplicate detection in spatial join processing. In: Proc. of Int’l Conf. on Data Engineering, ICDE (2000)
Guttman, A.: R-trees: a dynamical index structure for spatial searching. In: Proc. of ACM SIGMOD Int’l Conference (1984)
Hjaltason, G.R., Samet, H.: Incremental distance join algorithms for spatial databases. In: Proc. of ACM SIGMOD Int’l Conference (1998)
Ives, Z.G., Florescu, D., Friedman, M., Levy, A.Y., Weld, D.S.: An adaptive query execution system for data integration. In: Proc. of ACM SIGMOD Int’l Conference (1999)
Koudas, N., Sevcik, K.C.: High dimensional similarity joins: Algorithms and performance evaluation. In: Proc. of Int’l Conf. on Data Engineering, ICDE (1998)
Liu, D., Lim, E.-P., Ng, W.K.: Efficient k nearest neighbor queries on remote spatial databases using range estimation. In: Proc of Int’l Conference on Scientific and Statistical Database Management, SSDBM (2002)
Lo, M.-L., Ravishankar, C.V.: Spatial hash-joins. In: Proc. of ACM SIGMOD Int’l Conference (1996)
Luo, G., Naughton, J.F., Ellmann, C.: A non-blocking parallel spatial join algorithm. In: Proc. of Int’l Conf. on Data Engineering, ICDE (2002)
Mamoulis, N., Papadias, D.: Integration of spatial join algorithms for processing multiple inputs. In: Proc. of ACM SIGMOD Int’l Conference (1999)
Patel, J.M., DeWitt, D.J.: Partition based spatial-merge join. In: Proc. of ACM SIGMOD Int’l Conference (1996)
Roth, M.T., Ozcan, F., Haas, L.M.: Cost models do matter: Providing cost information for diverse data sources in a federated system. In: Proc. of VLDB Conference (1999)
Shin, H., Moon, B., Lee, S.: Adaptive multi-stage distance join processing. In: Proc. of ACM SIGMOD Int’l Conference (2000)
Tan, K.-L., Ooi, B.-C., Abel, D.J.: Exploiting spatial indexes for semijoin-based join processing in distributed spatial databases. IEEE Trans. on Data and Knowledge Engineering 12(2), 920–937 (2000)
Tomasic, A., Raschid, L., Valduriez, P.: Scaling access to heterogeneous data sources with disco. IEEE Trans. on Data and Knowledge Engineering 10(5), 808–823 (1998)
Zhang, J., Mamoulis, N., Papadias, D., Tao, Y.: All-nearestneighbors queries in spatial databases. Technical Report CS07-02, HKUST, Hong Kong (2002)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2003 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Mamoulis, N., Kalnis, P., Bakiras, S., Li, X. (2003). Optimization of Spatial Joins on Mobile Devices. In: Hadzilacos, T., Manolopoulos, Y., Roddick, J., Theodoridis, Y. (eds) Advances in Spatial and Temporal Databases. SSTD 2003. Lecture Notes in Computer Science, vol 2750. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-45072-6_14
Download citation
DOI: https://doi.org/10.1007/978-3-540-45072-6_14
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-40535-1
Online ISBN: 978-3-540-45072-6
eBook Packages: Springer Book Archive