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. 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).
    2. 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.
    3. 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.
    4. Williams, B. & Bishop, D., 2024. "Flexible futures: The potential for electrical energy demand response in New Zealand," Energy Policy, Elsevier, vol. 195(C).
    5. Mohammed Alnahhal†& Omar Antar & Ahmad Sakhrieh & Muataz Al Hazza, 2024. "Analyzing Energy Consumption in Universities: A Literature Review," International Journal of Energy Economics and Policy, Econjournals, vol. 14(3), pages 18-27, May.
    6. Gabriel Suster & Cosmin Alin Popescu & Tiberiu Iancu & Gabriela Popescu & Ramona Ciolac, 2025. "The Synergy of Smart Campus Development with Smart City Policies and the New European Bauhaus with Implications for Educational Efficiency," Sustainability, MDPI, vol. 17(17), pages 1-35, September.
    7. 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.
    8. Enemuo, Michael & Ogunmodimu, Olumide, 2025. "Transitioning the mining sector: A review of renewable energy integration and carbon footprint reduction strategies," Applied Energy, Elsevier, vol. 384(C).
    9. 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.
    10. 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.
    11. 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.
    12. Badr Alsamani & Samir Chatterjee & Ali Anjomshoae & Peter Ractham, 2022. "Smart Space Design–A Framework and an IoT Prototype Implementation," Sustainability, MDPI, vol. 15(1), pages 1-27, December.
    13. Alessandro Scuderi & Giovanni La Via & Giuseppe Timpanaro & Luisa Sturiale, 2022. "The Digital Applications of “Agriculture 4.0”: Strategic Opportunity for the Development of the Italian Citrus Chain," Agriculture, MDPI, vol. 12(3), pages 1-13, March.
    14. Yi Yang & Yuting Bai & Xiaoyi Wang & Li Wang & Xuebo Jin & Qian Sun, 2020. "Group Decision-Making Support for Sustainable Governance of Algal Bloom in Urban Lakes," Sustainability, MDPI, vol. 12(4), pages 1-16, February.
    15. Aguilar, J. & Garces-Jimenez, A. & R-Moreno, M.D. & García, Rodrigo, 2021. "A systematic literature review on the use of artificial intelligence in energy self-management in smart buildings," Renewable and Sustainable Energy Reviews, Elsevier, vol. 151(C).
    16. Yasir Basheer & Asad Waqar & Saeed Mian Qaisar & Toqeer Ahmed & Nasim Ullah & Sattam Alotaibi, 2022. "Analyzing the Prospect of Hybrid Energy in the Cement Industry of Pakistan, Using HOMER Pro," Sustainability, MDPI, vol. 14(19), pages 1-24, September.
    17. Ali Saleh Aziz & Mohammad Faridun Naim Tajuddin & Tekai Eddine Khalil Zidane & Chun-Lien Su & Abdullahi Abubakar Mas’ud & Mohammed J. Alwazzan & Ali Jawad Kadhim Alrubaie, 2022. "Design and Optimization of a Grid-Connected Solar Energy System: Study in Iraq," Sustainability, MDPI, vol. 14(13), pages 1-29, July.
    18. William Villegas-Ch & Jhoann Molina-Enriquez & Carlos Chicaiza-Tamayo & Iván Ortiz-Garcés & Sergio Luján-Mora, 2019. "Application of a Big Data Framework for Data Monitoring on a Smart Campus," Sustainability, MDPI, vol. 11(20), pages 1-15, October.
    19. Vian Ahmed & Karam Abu Alnaaj & Sara Saboor, 2020. "An Investigation into Stakeholders’ Perception of Smart Campus Criteria: The American University of Sharjah as a Case Study," Sustainability, MDPI, vol. 12(12), pages 1-24, June.
    20. Khai Wah Khaw & Mark Camilleri & Victor Tiberius & Alhamzah Alnoor & Ali Shakir Zaidan, 2024. "Benchmarking electric power companies’ sustainability and circular economy behaviors: using a hybrid PLS-SEM and MCDM approach," Environment, Development and Sustainability: A Multidisciplinary Approach to the Theory and Practice of Sustainable Development, Springer, vol. 26(3), pages 6561-6599, March.

    More about this item

    Keywords

    ;
    ;
    ;
    ;
    ;

    Statistics

    Access and download statistics

    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.