IDEAS home Printed from https://ideas.repec.org/a/gam/jsusta/v12y2020i22p9727-d448936.html
   My bibliography  Save this article

ST-Trie: A Novel Indexing Scheme for Efficiently Querying Heterogeneous, Spatiotemporal IoT Data

Author

Listed:
  • Hawon Chu

    (School of Computer Science and Engineering, Kyungpook National University, Daegu 41566, Korea)

  • Jaeseong Kim

    (School of Computer Science and Engineering, Kyungpook National University, Daegu 41566, Korea)

  • Seounghyeon Kim

    (School of Computer Science and Engineering, Kyungpook National University, Daegu 41566, Korea
    Current address: Samsung Research, Samsung Electronics, Seoul 06765, Korea)

  • Young-Kyoon Suh

    (School of Computer Science and Engineering, Kyungpook National University, Daegu 41566, Korea)

  • Ryong Lee

    (Research Data Sharing Center, Korea Institute of Science and Technology Information, Daejeon 34141, Korea)

  • Rae-Young Jang

    (Research Data Sharing Center, Korea Institute of Science and Technology Information, Daejeon 34141, Korea)

  • Minwoo Park

    (Research Data Sharing Center, Korea Institute of Science and Technology Information, Daejeon 34141, Korea)

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.

Suggested Citation

  • Hawon Chu & Jaeseong Kim & Seounghyeon Kim & Young-Kyoon Suh & Ryong Lee & Rae-Young Jang & Minwoo Park, 2020. "ST-Trie: A Novel Indexing Scheme for Efficiently Querying Heterogeneous, Spatiotemporal IoT Data," Sustainability, MDPI, vol. 12(22), pages 1-21, November.
  • Handle: RePEc:gam:jsusta:v:12:y:2020:i:22:p:9727-:d:448936
    as

    Download full text from publisher

    File URL: https://www.mdpi.com/2071-1050/12/22/9727/pdf
    Download Restriction: no

    File URL: https://www.mdpi.com/2071-1050/12/22/9727/
    Download Restriction: no
    ---><---

    References listed on IDEAS

    as
    1. Ahmed Ismail & Samir Abdlerazek & Ibrahim M. El-Henawy, 2020. "Development of Smart Healthcare System Based on Speech Recognition Using Support Vector Machine and Dynamic Time Warping," Sustainability, MDPI, vol. 12(6), pages 1-15, March.
    2. Yuquan Meng & Yuhang Yang & Haseung Chung & Pil-Ho Lee & Chenhui Shao, 2018. "Enhancing Sustainability and Energy Efficiency in Smart Factories: A Review," Sustainability, MDPI, vol. 10(12), pages 1-28, December.
    3. Xue-Bo Jin & Xing-Hong Yu & Xiao-Yi Wang & Yu-Ting Bai & Ting-Li Su & Jian-Lei Kong, 2020. "Deep Learning Predictor for Sustainable Precision Agriculture Based on Internet of Things System," Sustainability, MDPI, vol. 12(4), pages 1-18, February.
    4. Arum Park & Jungho Jun & Kyoung Jun Lee, 2017. "Customer-Driven Smart and Sustainable Interactions in Conventions: The Case of Nestlé’s Smart Button Adoption," Sustainability, MDPI, vol. 9(11), pages 1-13, November.
    5. Bhagya Nathali Silva & Murad Khan & Kijun Han, 2020. "Futuristic Sustainable Energy Management in Smart Environments: A Review of Peak Load Shaving and Demand Response Strategies, Challenges, and Opportunities," Sustainability, MDPI, vol. 12(14), pages 1-23, July.
    6. William Villegas-Ch & Xavier Palacios-Pacheco & Sergio Luján-Mora, 2019. "Application of a Smart City Model to a Traditional University Campus with a Big Data Architecture: A Sustainable Smart Campus," Sustainability, MDPI, vol. 11(10), pages 1-28, May.
    Full references (including those not matched with items on IDEAS)

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Ayad Ghany Ismaeel & Jereesha Mary & Anitha Chelliah & Jaganathan Logeshwaran & Sarmad Nozad Mahmood & Sameer Alani & Akram H. Shather, 2023. "Enhancing Traffic Intelligence in Smart Cities Using Sustainable Deep Radial Function," Sustainability, MDPI, vol. 15(19), pages 1-24, October.
    2. Jonek-Kowalska, Izabela & Musioł-Urbańczyk, Anna & Podgórska, Marzena & Wolny, Maciej, 2021. "Does motivation matter in evaluation of research institutions? Evidence from Polish public universities," Technology in Society, Elsevier, vol. 67(C).
    3. William Villegas-Ch. & Milton Roman-Cañizares & Santiago Sánchez-Viteri & Joselin García-Ortiz & Walter Gaibor-Naranjo, 2021. "Analysis of the State of Learning in University Students with the Use of a Hadoop Framework," Future Internet, MDPI, vol. 13(6), pages 1-25, May.
    4. Xue-Bo Jin & Wen-Tao Gong & Jian-Lei Kong & Yu-Ting Bai & Ting-Li Su, 2022. "PFVAE: A Planar Flow-Based Variational Auto-Encoder Prediction Model for Time Series Data," Mathematics, MDPI, vol. 10(4), pages 1-17, February.
    5. Agustín Zaballos & Alan Briones & Alba Massa & Pol Centelles & Víctor Caballero, 2020. "A Smart Campus’ Digital Twin for Sustainable Comfort Monitoring," Sustainability, MDPI, vol. 12(21), pages 1-33, November.
    6. Saqib Ali & Habib Ullah & Minhas Akbar & Waheed Akhtar & Hasan Zahid, 2019. "Determinants of Consumer Intentions to Purchase Energy-Saving Household Products in Pakistan," Sustainability, MDPI, vol. 11(5), pages 1-20, March.
    7. Ruben Barreto & Calvin Gonçalves & Luis Gomes & Pedro Faria & Zita Vale, 2022. "Evaluation Metrics to Assess the Most Suitable Energy Community End-Users to Participate in Demand Response," Energies, MDPI, vol. 15(7), pages 1-18, March.
    8. Waris, Idrees & Hameed, Irfan, 2019. "Using Extended Model of Theory of Planned Behavior to Predict Purchase Intention of Energy Efficient Home Appliances in Pakistan," MPRA Paper 109612, University Library of Munich, Germany.
    9. Jonghyuk Kim & Hyunwoo Hwangbo, 2019. "Real-Time Early Warning System for Sustainable and Intelligent Plastic Film Manufacturing," Sustainability, MDPI, vol. 11(5), pages 1-13, March.
    10. Hsiao-Yen Mao & Wen-Min Lu & Hsin-Yen Shieh, 2023. "Exploring the Influence of Environmental Investment on Multinational Enterprises’ Performance from the Sustainability and Marketability Efficiency Perspectives," Sustainability, MDPI, vol. 15(10), pages 1-23, May.
    11. Cezar-Petre Simion & Cătălin-Alexandru Verdeș & Alexandra-Andreea Mironescu & Florin-Gabriel Anghel, 2023. "Digitalization in Energy Production, Distribution, and Consumption: A Systematic Literature Review," Energies, MDPI, vol. 16(4), pages 1-30, February.
    12. Harsh Wardhan Pandey & Ramesh Kumar & Rajib Kumar Mandal, 2023. "Ranking of mitigation strategies for duck curve in Indian active distribution network using MCDM," International Journal of System Assurance Engineering and Management, Springer;The Society for Reliability, Engineering Quality and Operations Management (SREQOM),India, and Division of Operation and Maintenance, Lulea University of Technology, Sweden, vol. 14(4), pages 1255-1275, August.
    13. Senthil Sundaramoorthy & Dipti Kamath & Sachin Nimbalkar & Christopher Price & Thomas Wenning & Joseph Cresko, 2023. "Energy Efficiency as a Foundational Technology Pillar for Industrial Decarbonization," Sustainability, MDPI, vol. 15(12), pages 1-24, June.
    14. Jelena Končar & Aleksandar Grubor & Radenko Marić & Sonja Vučenović & Goran Vukmirović, 2020. "Setbacks to IoT Implementation in the Function of FMCG Supply Chain Sustainability during COVID-19 Pandemic," Sustainability, MDPI, vol. 12(18), pages 1-21, September.
    15. Muhammad Fahad & Tariq Javid & Hira Beenish & Adnan Ahmed Siddiqui & Ghufran Ahmed, 2021. "Extending ONTAgri with Service-Oriented Architecture towards Precision Farming Application," Sustainability, MDPI, vol. 13(17), pages 1-14, August.
    16. Rafael Ninno Muniz & Carlos Tavares da Costa Júnior & William Gouvêa Buratto & Ademir Nied & Gabriel Villarrubia González, 2023. "The Sustainability Concept: A Review Focusing on Energy," Sustainability, MDPI, vol. 15(19), pages 1-22, September.
    17. Teckshawer Tom, 2023. "5G Impacts, Internet of Things (IoT) and Businesses in Developing Countries," Technium Social Sciences Journal, Technium Science, vol. 46(1), pages 87-104, August.
    18. William Villegas-Ch & Xavier Palacios-Pacheco & Milton Román-Cañizares, 2020. "Integration of IoT and Blockchain to in the Processes of a University Campus," Sustainability, MDPI, vol. 12(12), pages 1-21, June.
    19. Krzysztof Kosowski & Karol Tucki & Marian Piwowarski & Robert Stępień & Olga Orynycz & Wojciech Włodarski, 2019. "Thermodynamic Cycle Concepts for High-Efficiency Power Plants. Part B: Prosumer and Distributed Power Industry," Sustainability, MDPI, vol. 11(9), pages 1-13, May.
    20. Lei Zhang & Ying Yang, 2023. "Towards Sustainable Energy Systems Considering Unexpected Sports Event Management: Integrating Machine Learning and Optimization Algorithms," Sustainability, MDPI, vol. 15(9), pages 1-16, April.

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:gam:jsusta:v:12:y:2020:i:22:p:9727-:d:448936. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: MDPI Indexing Manager (email available below). General contact details of provider: https://www.mdpi.com .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.