IMPROVING CLIMATE MONITORING SYSTEMS THROUGH OBJECT-RELATIONAL MAPPING TECHNOLOGIES AND REAL-TIME ANALYTICAL PROCESSING

1
Національний університет «Львівська політехніка»
2
Lviv Polytechnic National University
3
Національний університет «Львівська політехніка»
4
College of Agricultural,Pennsylvania State, USA

The article addresses challenges related to climate change research. It provides an overview of contemporary information technologies that facilitate the design of highly efficient climate monitoring information systems, specifically in terms of processing speed and data completeness. Particular emphasis is placed on the use of tools for automatic object-to-database table mapping based on real-time Object-Relational Mapping (ORM) systems, as well as on OLAP technologies, which leverage multidimensional cubes to accelerate the processing of large-scale climate data and enhance the effectiveness of multidimensional data analysis. The developed climate monitoring information system, presented herein, comprises components for aggregated data sets, backend processing, frontend visualization, and an analytical module implemented as OLAP cubes. The system enables scientific research on environmental parameters and supports the development of forecasting models for climate monitoring systems, providing predictive and decision-support capabilities designed to mitigate global warming.

  1. A. Dziubenko, Tekhnolohii analizu danykh v ekolohichnomu monitorynhu. Dnipro, DNU, 2021.
  2. O. Shulha, V. Tkachuk, Osnovy prohramuvannia eko- lohichnykh system, Vinnytsia, Universum, 2018.
  3. A. Lagun, N. Kukharska, “Using the information technologies for quality monitoring of different environmental impacts on humanity life”, Contemporary technologies and society innovations, artificial intelligence, and challenges, Eds., Katowice, Poland: The University of Technology in Katowice Press, 2023, pp. 585-592.
  4. A. Lagun, N. Kukharska, I. Kurta, “Rozrobka ta doslidzhennia informatsiinoi systemy dlia analizu zminy klimatu”, Kompiuterni tekhnolohii drukarstva, no. 1(47), p. 37-48, 2022.
  5. Fighting air inequality through open data, 2025. [Online].Available: https://openaq.org/
  6. Climate Data Analysis Tools & Methods, 2025. [Online].Available: https://climatedataguide.ucar.edu/climate-tools
  7. NASA Worldview, 2025. [Online]. Available: https://worldview.earthdata.nasa.gov/
  8. OpenWeather. Weather forecasts, nowcasts and history in a fast and elegant way, 2025. [Online]. Available:https://openweathermap.org/
  9. The Climate Explorer. Explore how climate is projected to change in any county in the United States, 2025. [online]. Available: https://crt-climate-explorer.nemac.org/
  10. Climate Prediction Center, 2025. [online]. Available: https://www.cpc.ncep.noaa.gov/
  11. Climate      Data     Store,     2025.     [online].     Available: https://cds.climate.copernicus.eu/
  12. JRC     portfolios     A-Z,     2025.     [Online].     Available: https://joint-research-centre.ec.europa.eu/jrc-science-and- knowledge-activities/jrc-portfolios-z_en
  13. ECMWF Reanalysis v5 (ERA5), 2025. [online]. Available: https://www.ecmwf.int/en/forecasts/dataset/ecmwf- reanalysis-v5
  14. NASA. National Aeronautics and Space Administration Goddard Institute for Space Studies, 2025. [online].Available: https://data.giss.nasa.gov/gistemp/
  15. European Climate Assessment & Dataset, 2025. [online]. Available: https://www.eea.europa.eu/data-and-maps/data/ external/european-climate-assessment-and-datasets-2
  16. Berkeley Earth. Data Overview, 2025, [online]. Available: https://berkeleyearth.org/data/
  17. Copernicus Climate Change Service, 2025. [online].Available: https://climate.copernicus.eu/
  18. Global Historical Climatology Network, 2025, [online]. Available: https://catalog.data.gov/dataset/global-historical- climatology-network-daily-ghcn-daily-version-32
  19. V. Parkhomenko, Rozrobka prohramnykh zasobiv monitorynhu ta prohnozuvannia ekolohichnoi bezpeky. Publ. house LNU, 2019.
  20. Earth Engine Data Catalog. A planetary-scale platform for Earth science data & analysis, 2024, [Online]. Available: https://developers.google.com/earth-engine/datasets