Nothing Special   »   [go: up one dir, main page]

skip to main content
10.1145/2452376.2452462acmotherconferencesArticle/Chapter ViewAbstractPublication PagesedbtConference Proceedingsconference-collections
demonstration

An efficient layout method for a large collection of geographic data entries

Published: 18 March 2013 Publication History

Abstract

Many spatial applications require the ability to display locations of geographic data entries on an online map. For example, an online photo-sharing service may wish to display photos (as thumbnails) according to where they were taken. Since displaying geographic data entries as thumbnails or icons on a map requires some amount of space, displayed entries can overlap each other. As a result, we may wish to discard less popular or older entries (based on a given measure of importance) so that these more popular or newer entries become more distinct. A straightforward solution is to apply a spatial database extension such as PostGIS (i) to retrieve entries within a given display window; (ii) to discard entries in proximity of a more important one. In this paper, we demonstrate our method for efficiently selecting distinct entries from a large geographical point set. Specifically, our demonstration software presents a voting system built upon an ensemble of interrelated indexes, which is the main novelty of our query processing method. This allows us to efficiently determine the degree of distinctiveness of all entries within a query window using simple index traversal operations rather than expensive spatial operations. The effectiveness of our method in comparison to a traditional spatial query is shown by our experimental results using a real dataset of over 9 million locations. These experimental results show that our proposed method is capable of consistently producing subsecond response times, while the spatial query-based method takes more than 10 seconds on average in a low spatial selectivity setting.

References

[1]
W. G. Aref and H. Samet. Efficient processing of window queries in the pyramid data structure. In PODS'90, pp. 265--272, Nashville, TN, Apr. 1990.
[2]
S. Doddi, M. V. Marathe, A. Mirzaian, B. M. E. Moret, and B. Zhu. Map labeling and its generalizations. In SODA'98, pp. 148--157, New Orleans, LA, Jan. 1998.
[3]
C. Esperança and H. Samet. Experience with SAND/Tcl: a scripting tool for spatial databases. JVLC, 13(2):229--255, Apr. 2002.
[4]
B. C. Fruin, H. Samet, and J. Sankaranarayanan. Tweetphoto: photos from news tweets. In GIS'12, pp. 582--585, Redondo Beach, CA, Nov. 2012.
[5]
E. Jacox and H. Samet. Spatial join techniques. TODS, 32(1):7, Mar. 2007.
[6]
M. Van Kreveld, I. Reinbacher, A. Arampatzis, and R Van Zwol. Multi-dimensional scattered ranking methods for geographic information retrieval. GeoInformatica, 9(1):61--84, Mar. 2005.
[7]
M. D. Lieberman, H. Samet, J. Sankaranarayanan, and J. Sperling. STEWARD: architecture of a spatio-textual search engine. In GIS'07, pp. 186--193, Seattle, WA, Nov. 2007.
[8]
S. Nutanong, M. D. Adelfio, and H. Samet. Multiresolution select-distinct queries on large geographic point sets. In GIS'12, pp. 159--168, Redondo Beach, CA, Nov. 2012.
[9]
H. Samet. A quadtree medial axis transform. CACM, 26(9):680--693, Sept. 1983.
[10]
H. Samet. Foundations of Multidimensional and Metric Data Structures. Morgan-Kaufmann, San Francisco, 2006.
[11]
H. Samet, M. D. Adelfio, B. C. Fruin, M. D. Lieberman, and B. E. Teitler. Porting a web-based mapping application to a smartphone app. In GIS'11, pp. 525--528, Chicago, Nov. 2011.
[12]
H. Samet, H. Alborzi, F. Brabec, C. Esperança, G. R. Hjaltason, F. Morgan, and E. Tanin. Use of the SAND spatial browser for digital government applications. CACM, 46(1):63--66, Jan. 2003.
[13]
H. Samet, A. Rosenfeld, C. A. Shaffer, and R. E. Webber. A geographic information system using quadtrees. Pattern Recognition, 17(6):647--656, Nov/Dec 1984.
[14]
H. Samet, B. E. Teitler, M. D. Adelfio, and M. D. Lieberman. Adapting a map query interface for a gesturing touch screen interface. In WWW'11 (Companion Volume), pp. 257--260, Hyderabad, India, Mar. 2011.
[15]
J. Sankaranarayanan and H. Samet. Images in news. In ICPR, pp. 3240--3243, Istanbul, Turkey, Aug. 2010.
[16]
J. Sankaranarayanan, H. Samet, B. Teitler, M. D. Lieberman, and J. Sperling. TwitterStand: News in tweets. In GIS'09, pp. 42--51, Seattle, WA, Nov. 2009.
[17]
A. D. Sarma, H. Lee, H. Gonzalez, J. Madhavan, and A. Y. Halevy. Efficient spatial sampling of large geographical tables. In SIGMOD, pp. 193--204, Scottsdale, AZ, Jun. 2012.
[18]
C. A. Shaffer, H. Samet, and R. C. Nelson. QUILT: a geographic information system based on quadtrees. IJGIS, 4(2):103--131, Apr.--June 1990.
[19]
B. Teitler, M. D. Lieberman, D. Panozzo, J. Sankaranarayanan, H. Samet, and J. Sperling. NewsStand: A new view on news. In GIS'08, pp. 144--153, Irvine, CA, Nov. 2008.
[20]
F. Wagner and A. Wolff. An efficient and effective approximation algorithm for the map labeling problem. In ESA'00, vol. 979 of Springer-Verlag Lecture Notes in Computer Science, pp. 420--433, Corfu, Greece, Sep. 2000.

Cited By

View all
  • (2017)Design of a Telemedicine Ubiquitous Architecture Based on the Smart Device mHealth Arduino 4GApplied Computer Sciences in Engineering10.1007/978-3-319-50880-1_30(345-356)Online publication date: 3-Jan-2017
  • (2016)Dynamic presentation consistency issues in smartphone mapping appsCommunications of the ACM10.1145/297132259:9(58-67)Online publication date: 24-Aug-2016
  • (2016)Static presentation consistency issues in smartphone mapping appsCommunications of the ACM10.1145/290437859:5(88-98)Online publication date: 26-Apr-2016
  • Show More Cited By

Recommendations

Comments

Please enable JavaScript to view thecomments powered by Disqus.

Information & Contributors

Information

Published In

cover image ACM Other conferences
EDBT '13: Proceedings of the 16th International Conference on Extending Database Technology
March 2013
793 pages
ISBN:9781450315975
DOI:10.1145/2452376

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 18 March 2013

Permissions

Request permissions for this article.

Check for updates

Author Tags

  1. query processing
  2. spatial databases

Qualifiers

  • Demonstration

Funding Sources

Conference

EDBT/ICDT '13

Acceptance Rates

Overall Acceptance Rate 7 of 10 submissions, 70%

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • Downloads (Last 12 months)8
  • Downloads (Last 6 weeks)0
Reflects downloads up to 21 Nov 2024

Other Metrics

Citations

Cited By

View all
  • (2017)Design of a Telemedicine Ubiquitous Architecture Based on the Smart Device mHealth Arduino 4GApplied Computer Sciences in Engineering10.1007/978-3-319-50880-1_30(345-356)Online publication date: 3-Jan-2017
  • (2016)Dynamic presentation consistency issues in smartphone mapping appsCommunications of the ACM10.1145/297132259:9(58-67)Online publication date: 24-Aug-2016
  • (2016)Static presentation consistency issues in smartphone mapping appsCommunications of the ACM10.1145/290437859:5(88-98)Online publication date: 26-Apr-2016
  • (2016)On the naturalness of softwareCommunications of the ACM10.1145/290236259:5(122-131)Online publication date: 26-Apr-2016
  • (2016)Hiding secrets in softwareCommunications of the ACM10.1145/290231359:5(113-120)Online publication date: 26-Apr-2016
  • (2016)Design ubiquitous architecture for telemedicine based on mhealth Arduino 4G LTE2016 IEEE 18th International Conference on e-Health Networking, Applications and Services (Healthcom)10.1109/HealthCom.2016.7749440(1-6)Online publication date: Sep-2016
  • (2015)Looking Backward to Look ForwardACM Transactions on Computing Education10.1145/281720915:3(1-8)Online publication date: 23-Sep-2015
  • (2015)Object-Oriented Design and ProgrammingACM Transactions on Computing Education10.1145/270051915:3(1-21)Online publication date: 28-Jul-2015
  • (2015)Uncovering “Threshold Concepts” in Web Development: An Instructor PerspectiveACM Transactions on Computing Education10.1145/270051315:1(1-18)Online publication date: 4-Mar-2015
  • (2015)Created computed universeCommunications of the ACM10.1145/266721758:6(36-38)Online publication date: 21-May-2015
  • Show More Cited By

View Options

Login options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Media

Figures

Other

Tables

Share

Share

Share this Publication link

Share on social media