SOCIETY & ”INDUSTRY 4.0”

NoSQL database for air quality prediction

  • 1 University of Chemical Technology and Metallurgy, Sofia, Bulgaria

Abstract

The increasing application of NoSQL database technology and the neural networks raises the question of how compatible and applicable are the NoSQL databases to the neural network prediction models. This paper examines the applicability of a traditional relational database for storing air quality data and compares it to a NoSQL database performing the same functions. The possibility of the NoSQL database to feed a neural network model for predicting the atmospheric air quality is evaluated. The tendencies in the data are studied, and some solutions for improving the air quality are proposed. An analysis and a comparison of the performance of both relational SQL and NoSQL database systems by using real-world data for the Air Quality Index in the city of London is assessed and their performance is compared. Bivariate analysis on the data in order to assess the quality of the neural network forecast is performed.

Keywords

References

  1. Besmir Sejdiu, Florije Ismaili, Lule Ahmedi, Computers 2021, 10(10), 127; https://doi.org/10.3390/computers10100127, IoTSAS: An Integrated System for Real-Time Semantic Annotation and Interpretation of IoT Sensor Stream Data
  2. Jeang-Kuo Chen, Wei-Zhe Lee, Algorithms 2019, 12(5), 106; https://doi.org/10.3390/a12050106, An Introduction of NoSQL Databases Based on Their Categories and Application Industries
  3. The Impact of Bike-Sharing Ridership on Air Quality: A Scalable Data Science Framework,
  4. Nina Hua, Victoria Suarez, Rebecca Reilly, Philip Trinh, Paul Intrevado, Diane Myung-kyung Woodbridge, Data Science Program, University of San Francisco, 2019, IEEE SmartWorld, Ubiquitous Intelligence & Computing, Advanced & Trusted Computing, Scalable Computing & Communications, Cloud & Big Data Computing, Internet of People and Smart City Innovation, Data Modeling in Apache Cassandra, Five Steps to an Awesome Data Model
  5. Roba Zayed, Maysam Abbod, DataSCI, vol. 4, no. 2, pp. 5-10, Jan. 2022, Big Data AI System for Air Quality Prediction
  6. Nadia N. Sánchez-Pozo, Sergi Trilles-Oliver, Albert Solé-Ribalta, Leandro L. Lorente-Leyva, Dagoberto Mayorca-Torres, Diego H. Peluffo-Ordóñez International Conference on Hybrid Artificial Intelligence Systems, HAIS 2021: Hybrid Artificial Intelligent Systems pp 293–304, Algorithms Air Quality Estimation: A Comparative Study of Stochastic and Heuristic Predictive Models
  7. Akram Jamal, Ramin Nabizadeh Nodehi, Journal of Air Pollution and Health (Quarterly), eISSN: 2476-3071, Tehran University of Medical Sciences, Tehran, Iran, 2017, Predicting Air Quality Index Based on Meteorological Data: A Comparison of Regression Analysis, Artificial Neural Networks and Decision Tree
  8. Heidar Maleki, Armin Sorooshian, Gholamreza Goudarzi, Zeynab Baboli, Yaser Tahmasebi Birgani & Mojtaba Rahmati, Clean Technologies and Environmental Policy volume 21, pages 1341–1352 (2019), Air pollution prediction by using an artificial neural network model
  9. Sean Mc Grath, Eoin Garrigan, Liaoyuan Zeng, 2021 IEEE International Conference on Electronic Technology, Communication and Information (ICETCI), Predicting Air Quality Index Using Deep Neural Networks
  10. Fabio Cassano, Antonio Casale, Paola Regina, Luana Spadafina & Petar Sekulic, International Symposium on Ambient Intelligence, ISAmI 2019: Ambient Intelligence – Software and Applications, 10th International Symposium on Ambient Intelligence pp 36–44, A Recurrent Neural Network Approach to Improve the Air Quality Index Prediction
  11. https://www.londonair.org.uk/
  12. José Ángel Martín-Baosa, Luis Rodriguez-Benitez, Ricardo García-Ródenas, JunLiu, Applied Soft Computing, Volume 115, January 2022, 108282, https://doi.org/10.1016/j.asoc.2021.108282, IoT based monitoring of air quality and traffic using regression analysis
  13. Ning Jin, Yongkang Zeng, Ke Yan, Zhiwei Ji, IEEE Transactions on Industrial Informatics ( Volume: 17, Issue: 12, December 2021), Page(s): 8514 – 8522, Multivariate Air Quality Forecasting With Nested Long Short Term Memory Neural Network
  14. Piotr Grzesik, Dariusz Mrozek, International Conference on Computational Science 2020: Computational Science – ICCS 2020 pp 371–383, Comparative Analysis of Time Series Databases in the Context of Edge Computing for Low Power Sensor Networks

Article full text

Download PDF