skip to main content
research-article

Processing spatial skyline queries in both vector spaces and spatial network databases

Published:03 September 2009Publication History
Skip Abstract Section

Abstract

In this article, we first introduce the concept of Spatial Skyline Queries (SSQ). Given a set of data points P and a set of query points Q, each data point has a number of derived spatial attributes each of which is the point's distance to a query point. An SSQ retrieves those points of P which are not dominated by any other point in P considering their derived spatial attributes. The main difference with the regular skyline query is that this spatial domination depends on the location of the query points Q. SSQ has application in several domains such as emergency response and online maps. The main intuition and novelty behind our approaches is that we exploit the geometric properties of the SSQ problem space to avoid the exhaustive examination of all the point pairs in P and Q. Consequently, we reduce the complexity of SSQ search from O(|P|2|Q|) to O(|S|2|C| + √|P|), where |S| and |C| are the solution size and the number of vertices of the convex hull of Q, respectively.

Considering Euclidean distance, we propose two algorithms, B2S2 and VS2, for static query points and one algorithm, VCS2, for streaming Q whose points change location over time (e.g., are mobile). VCS2 exploits the pattern of change in Q to avoid unnecessary recomputation of the skyline and hence efficiently perform updates. We also propose two algorithms, SNS2 and VSNS2, that compute the spatial skyline with respect to the network distance in a spatial network database. Our extensive experiments using real-world datasets verify that both R-tree-based B2S2 and Voronoi-based VS2 outperform the best competitor approach in terms of both processing time and I/O cost. Furthermore, their output computed based on Euclidean distance is a good approximation of the spatial skyline in network space. For accurate computation of spatial skylines in network space, our experiments showed the superiority of VSNS2 over SNS2.

References

  1. Barber, C. B., Dobkin, D. P., and Huhdanpaa, H. 1996. The quickhull algorithm for convex hulls. ACM Trans. Math. Softw. 22, 4, 469--483. Google ScholarGoogle ScholarDigital LibraryDigital Library
  2. Börzsönyi, S., Kossmann, D., and Stocker, K. 2001. The skyline operator. In Proceedings of the International Conference on Data Engineering (ICDE'01). 421--430. Google ScholarGoogle ScholarDigital LibraryDigital Library
  3. Chomicki, J., Godfrey, P., Gryz, J., and Liang, D. 2003. Skyline with presorting. In Proceedings of the International Conference on Data Engineering (ICDE'03). IEEE Computer Society, 717--816.Google ScholarGoogle Scholar
  4. de Berg, M., van Kreveld, M., Overmars, M., and Schwarzkopf, O. 2000. Computational Geometry: Algorithms and Applications 2nd Ed. Springer Verlag. Google ScholarGoogle ScholarCross RefCross Ref
  5. Huang, X. and Jensen, C. S. 2004. In-route skyline querying for location-based services. In Proceedings of the 4th International Workshop on Web and Wireless Geographical Information Systems (W2GIS'04). Vol. 3428. Springer, 120--135. Google ScholarGoogle ScholarDigital LibraryDigital Library
  6. Huang, Z., Jensen, C. S., Lu, H., and Ooi, B. C. 2006. Skyline queries against mobile lightweight devices in MANETs. In Proceedings of the International Conference on Data Engineering (ICDE'06). IEEE Computer Society. Google ScholarGoogle ScholarDigital LibraryDigital Library
  7. Kolahdouzan, M. and Shahabi, C. 2004. Voronoi-based k nearest neighbor search for spatial network databases. In Proceedings of the International Conference on Very Large Databases. Morgan Kaufmann, 840--851. Google ScholarGoogle ScholarDigital LibraryDigital Library
  8. Kossmann, D., Ramsak, F., and Rost, S. 2002. Shooting stars in the sky: An online algorithm for skyline queries. In Proceedings of the International Conference on Very Large Databases (VLDB'02). 275--286. Google ScholarGoogle ScholarDigital LibraryDigital Library
  9. Lin, X., Yuan, Y., Wang, W., and Lu, H. 2005. Stabbing the sky: Efficient skyline computation over sliding windows. In Proceedings of the International Conference on Data Engineering (ICDE'05). IEEE Computer Society, 502--513. Google ScholarGoogle ScholarDigital LibraryDigital Library
  10. Okabe, A., Boots, B., Sugihara, K., and Chiu, S. N. 2000. Spatial Tessellations: Concepts and Applications of Voronoi Diagrams 2nd Ed. Probability and Statistics. Wiley, New York. 671 pages. Google ScholarGoogle ScholarCross RefCross Ref
  11. Papadias, D., Tao, Y., Fu, G., and Seeger, B. 2005a. Progressive skyline computation in database systems. ACM Trans. Datab. Syst. 30, 1, 41--82. Google ScholarGoogle ScholarDigital LibraryDigital Library
  12. Papadias, D., Tao, Y., Mouratidis, K., and Hui, C. K. 2005b. Aggregate nearest neighbor queries in spatial databases. ACM Trans. Datab. Syst. 30, 2, 529--576. Google ScholarGoogle ScholarDigital LibraryDigital Library
  13. Sharifzadeh, M. and Shahabi, C. 2006. The spatial skyline queries. In Proceedings of the 32nd International Conference on Very Large Data Bases (VLDB'06). 751--762. Google ScholarGoogle ScholarDigital LibraryDigital Library
  14. Tan, K.-L., Eng, P.-K., and Ooi, B. C. 2001. Efficient progressive skyline computation. In Proceedings of the International Conference on Very Large Databases (VLDB'01). 301--310. Google ScholarGoogle ScholarDigital LibraryDigital Library
  15. Theodoridis, Y. and Nascimento, M. A. 2000. Generating spatiotemporal datasets on the WWW. SIGMOD Rec. 29, 3, 39--43. Google ScholarGoogle ScholarDigital LibraryDigital Library

Index Terms

  1. Processing spatial skyline queries in both vector spaces and spatial network databases

          Recommendations

          Reviews

          Fatma Mili

          Increasingly, various contexts call for queries where one is seeking a set of objects (points) from the database that form a skyline (no other point dominates them). These queries have been dubbed skyline queries. They are specified through a set of points ( qi ) that are then used as a basis to define the criterion of dominance and select the points of interest ( pj ). For example, given a set of agent locations ( qi ), find a set of potential restaurants ( pj ) where they could meet; given a set of explosion locations ( qi ), find the buildings ( pj ) that must be evacuated first; or, given a set of compromised nodes in a network, identify the nodes that must be isolated first. In many of these applications, the dominance relationship is exclusively spatial. Branch-and-bound algorithms have been introduced to address the general skyline query problem, without being restricted to spatial criteria. Sharifzadeh et al. focus on skyline queries where the points pj and qi have coordinates in space and where the dominance relationship is based on proximity to the query points qi . They establish geometric relationships that enable them to reduce the search space and derive two different algorithms that are more efficient than the general-purpose skyline query algorithms. They further address the case where the query points qi are mobile (for example, agents are moving); they develop a dynamic algorithm that minimizes the amount of computation required to update the skyline as the query points move. Finally, they address applications where the query criterion is not based on Euclidean distance (for example, weights on network edges), and thus does not benefit from the same geometric properties as the spatial queries. For these, they introduce two alternative approaches. In our increasingly mobile computing infrastructure, the problem addressed in this paper is of highly practical utility. Finding efficient and accurate algorithms to solve it is critical. I found the paper easy to read. The theoretical foundation is fairly straightforward, and it is exploited in very innovative and interesting ways throughout the paper. Online Computing Reviews Service

          Access critical reviews of Computing literature here

          Become a reviewer for Computing Reviews.

          Comments

          Login options

          Check if you have access through your login credentials or your institution to get full access on this article.

          Sign in

          Full Access

          • Published in

            cover image ACM Transactions on Database Systems
            ACM Transactions on Database Systems  Volume 34, Issue 3
            August 2009
            269 pages
            ISSN:0362-5915
            EISSN:1557-4644
            DOI:10.1145/1567274
            Issue’s Table of Contents

            Copyright © 2009 ACM

            Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

            Publisher

            Association for Computing Machinery

            New York, NY, United States

            Publication History

            • Published: 3 September 2009
            • Accepted: 1 February 2009
            • Revised: 1 December 2008
            • Received: 1 June 2007
            Published in tods Volume 34, Issue 3

            Permissions

            Request permissions about this article.

            Request Permissions

            Check for updates

            Qualifiers

            • research-article
            • Research
            • Refereed

          PDF Format

          View or Download as a PDF file.

          PDF

          eReader

          View online with eReader.

          eReader