skip to main content
10.1145/2666310.2666399acmconferencesArticle/Chapter ViewAbstractPublication PagesgisConference Proceedingsconference-collections
research-article

Top-k point of interest retrieval using standard indexes

Published:04 November 2014Publication History

ABSTRACT

With the proliferation of Internet-connected, location-aware mobile devices, such as smartphones, we are also witnessing a proliferation and increased use of map-based services that serve information about relevant Points of Interest (PoIs) to their users.

We provide an efficient and practical foundation for the processing of queries that take a keyword and a spatial region as arguments and return the k most relevant PoIs that belong to the region, which may be the part of the map covered by the user's screen. The paper proposes a novel technique that encodes the spatio-textual part of a PoI as a compact bit string. This technique extends an existing spatial encoding to also encode the textual aspect of a PoI in compressed form. The resulting bit strings may then be indexed using index structures such as B-trees or hashing that are standard in DBMSs and key-value stores. As a result, it is straightforward to support the proposed functionality using existing data management systems. The paper also proposes a novel top-k query algorithm that merges partial results while providing an exact result.

An empirical study with real-world data indicates that the proposed techniques enable excellent indexing and query execution performance on a standard DBMS.

References

  1. R. Bayer and E. McCreight. Organization and maintenance of large ordered indexes. Acta Informatica, 1 (3): 173--189, 1972. Google ScholarGoogle ScholarDigital LibraryDigital Library
  2. N. Beckmann, H.-P. Kriegel, R. Schneider, and B. Seeger. The R*-tree: An efficient and robust access method for points and rectangles. In SIGMOD, pages 322--331, 1990. Google ScholarGoogle ScholarDigital LibraryDigital Library
  3. A. Cary, O. Wolfson, and N. Rishe. Efficient and scalable method for processing top-k spatial Boolean queries. In SSDBM, pages 87--95, 2010. Google ScholarGoogle ScholarDigital LibraryDigital Library
  4. L. Chen, G. Cong, C. S. Jensen, and D. Wu. Spatial keyword query processing: An experimental evaluation. PVLDB, 6(3):217--228, 2013. Google ScholarGoogle ScholarDigital LibraryDigital Library
  5. Y.-Y. Chen, T. Suel, and A. Markowetz. Efficient query processing in geographic web search engines. In SIGMOD, pages 277--288, 2006. Google ScholarGoogle ScholarDigital LibraryDigital Library
  6. M. Christoforaki, J. He, C. Dimopoulos, A. Markowetz, and T. Suel. Text vs. space: Efficient geo-search query processing. In CIKM, pages 423--432, 2011. Google ScholarGoogle ScholarDigital LibraryDigital Library
  7. G. Cong, C. S. Jensen, and D. Wu. Efficient retrieval of the top-k most relevant spatial web objects. PVLDB, 2(1):337--348, 2009. Google ScholarGoogle ScholarDigital LibraryDigital Library
  8. I. De Felipe, V. Hristidis, and N. Rishe. Keyword search on spatial databases. In ICDE, pages 656--665, 2008. Google ScholarGoogle ScholarDigital LibraryDigital Library
  9. R. Fagin, A. Lotem, and M. Naor. Optimal aggregation algorithms for middleware. In PODS, 102--113, 2001. Google ScholarGoogle ScholarDigital LibraryDigital Library
  10. R. Finkel and J. Bentley. Quad trees a data structure for retrieval on composite keys. Acta Informatica, 4(1):1--9, 1974. Google ScholarGoogle ScholarDigital LibraryDigital Library
  11. Google Inc. Google S2 Geometry Library, http://code.google.com/p/s2-geometry-library/, 2011. {Online: accessed September 2014}.Google ScholarGoogle Scholar
  12. A. Guttman. R-trees: A dynamic index structure for spatial searching. SIGMOD, pages 47--57, 1984. Google ScholarGoogle ScholarDigital LibraryDigital Library
  13. R. Hariharan, B. Hore, C. Li, and S. Mehrotra. Processing spatial-keyword (sk) queries in geographic information retrieval (gir) systems. In SSBDM, pages 16--16, 2007. Google ScholarGoogle ScholarDigital LibraryDigital Library
  14. D. Hubert. Uber die stetige abbildung einer linie auf ein flachenstuck. In Mathematische Annalen, 38: 459--460, 1891.Google ScholarGoogle ScholarCross RefCross Ref
  15. A. Khodaei, C. Shahabi, and C. Li. Hybrid indexing and seamless ranking of spatial and textual features of web documents. In DEXA, pages 450--466, 2010. Google ScholarGoogle ScholarDigital LibraryDigital Library
  16. D. E. Knuth. The Art of Computer Programming, Volume 3: Sorting and Searching, 2nd ed., Addison-Wesley. 1998. Google ScholarGoogle ScholarDigital LibraryDigital Library
  17. Z. Li, K. Lee, B. Zheng, W.-C. Lee, D. L. Lee, and X. Wang. IR-tree: An efficient index for geographic document search. TKDE, 23(4):585--599, 2011. Google ScholarGoogle ScholarDigital LibraryDigital Library
  18. J. a. B. Rocha-Junior, O. Gkorgkas, S. Jonassen, and K. Nørvåg. Efficient processing of top-k spatial keyword queries. In SSTD, pages 205--222, 2011. Google ScholarGoogle ScholarDigital LibraryDigital Library
  19. S. Vaid, C. B. Jones, H. Joho, and M. Sanderson. Spatio-textual indexing for geographical search on the web. In SSTD, pages 218--235, 2005. Google ScholarGoogle ScholarDigital LibraryDigital Library
  20. D. Wu, G. Cong, and C. S. Jensen. A framework for efficient spatial web object retrieval. VLDBJ, 21(6):797--822, 2012. Google ScholarGoogle ScholarDigital LibraryDigital Library
  21. D. Wu, M. L. Yiu, G. Cong, and C. S. Jensen. Joint top-k spatial keyword query processing. TKDE, 24(10):1889--1903, 2012. Google ScholarGoogle ScholarDigital LibraryDigital Library
  22. Y. Zhou, X. Xie, C. Wang, Y. Gong, and W.-Y. Ma. Hybrid index structures for location-based web search. In CIKM, pages 155--162, 2005. Google ScholarGoogle ScholarDigital LibraryDigital Library
  23. V. Gaede, and O. Günther. Multidimensional Access Methods. In CSUR, pages 170--231, 1998 Google ScholarGoogle ScholarDigital LibraryDigital Library

Index Terms

  1. Top-k point of interest retrieval using standard indexes

        Recommendations

        Comments

        Login options

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

        Sign in
        • Published in

          cover image ACM Conferences
          SIGSPATIAL '14: Proceedings of the 22nd ACM SIGSPATIAL International Conference on Advances in Geographic Information Systems
          November 2014
          651 pages
          ISBN:9781450331319
          DOI:10.1145/2666310

          Copyright © 2014 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: 4 November 2014

          Permissions

          Request permissions about this article.

          Request Permissions

          Check for updates

          Qualifiers

          • research-article

          Acceptance Rates

          SIGSPATIAL '14 Paper Acceptance Rate39of184submissions,21%Overall Acceptance Rate220of1,116submissions,20%

        PDF Format

        View or Download as a PDF file.

        PDF

        eReader

        View online with eReader.

        eReader