Skip to main navigation Skip to search Skip to main content

St-trie: A novel indexing scheme for efficiently querying heterogeneous, spatiotemporal iot data

  • Hawon Chu
  • , Jaeseong Kim
  • , Seounghyun Kim
  • , Young Kyoon Suh
  • , Ryong Lee
  • , Rae Young Jang
  • , Minwoo Park
  • Kyungpook National University
  • Korea Institute of Science and Technology Information

Research output: Contribution to journalArticlepeer-review

2 Scopus citations

Abstract

Recently, various environmental data, such as microdust pollution, temperature, humidity, etc., have been continuously collected by widely deployed Internet of Things (IoT) sensors. Although these data can provide great insight into developing sustainable application services, it is challenging to rapidly retrieve such data, due to their multidimensional properties and huge growth in volume over time. Existing indexing methods for efficiently locating those data expose several problems, such as high administrative cost, spatial overhead, and slow retrieval performance. To mitigate these problems, we propose a novel indexing scheme termed ST-Trie, for efficient retrieval over spatiotemporal IoT environment data. Given IoT sensor data with latitude, longitude, and time, the proposed scheme first converts the three-dimensional attributes to one-dimensional index keys. The scheme then builds a trie-based index, consisting of internal nodes inserted by the converted keys and leaf nodes containing the keys and pointers to actual IoT data. We leverage this index to process various types of queries. In our experiments with three real-world datasets, we show that the proposed ST-Trie index outperforms existing approaches by a substantial margin regarding response time. Furthermore, we show that the query processing performance via ST-Trie also scales very well with an increasing time interval. Finally, we demonstrate that when compressed, the ST-Trie index can significantly reduce its space overhead by approximately a factor of seven.

Original languageEnglish
Article number9727
Pages (from-to)1-21
Number of pages21
JournalSustainability (Switzerland)
Volume12
Issue number22
DOIs
StatePublished - 2 Nov 2020

UN SDGs

This output contributes to the following UN Sustainable Development Goals (SDGs)

  1. SDG 7 - Affordable and Clean Energy
    SDG 7 Affordable and Clean Energy

Keywords

  • Environment data
  • Internet of Things sensors
  • Query processing
  • Spatiotemporal indexing
  • Trie

Fingerprint

Dive into the research topics of 'St-trie: A novel indexing scheme for efficiently querying heterogeneous, spatiotemporal iot data'. Together they form a unique fingerprint.

Cite this