Skip to main navigation Skip to search Skip to main content

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

Sarana Nutanong, Marco D. Adelfio, Hanan Samet

Research output: Chapters, Conference Papers, Creative and Literary WorksRGC 32 - Refereed conference paper (with host publication)peer-review

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. © 2013 Authors.
Original languageEnglish
Title of host publicationACM International Conference Proceeding Series
Pages717-720
DOIs
Publication statusPublished - 2013
Externally publishedYes
Event16th International Conference on Extending Database Technology, EDBT 2013 - Genoa, Italy
Duration: 18 Mar 201322 Mar 2013

Conference

Conference16th International Conference on Extending Database Technology, EDBT 2013
PlaceItaly
CityGenoa
Period18/03/1322/03/13

Research Keywords

  • query processing
  • spatial databases

Fingerprint

Dive into the research topics of 'An efficient layout method for a large collection of geographic data entries'. Together they form a unique fingerprint.

Cite this