On the development of a cross-platform database application for storing long-term observations of ultraviolet radiation and total ozone content obtained using Brewer Spectrophotometer

Reducing emissions of some ozone-depleting substances (ODSs) entails uneven recovery of the ozone layer as it is also affected by ODSs emissions that not restricted by the Montreal Protocol. In this regard, there remains a need to continue monitoring the total ozone content (TOC) and ultraviolet (UV) radiation, as well as to ensure the uniformity of the measurements obtained in comparison with the data for previous decades. The network of Brewer spectrophotometers, operating since the early 1980s, is one of the oldest global systems that provides high-accuracy TOC and spectral UV radiation data. A new cross-platform database application for storing measurements, internal tests and instrumental constants of Brewer spectrophotometers is under development by A.M. Obukhov Institute of Atmospheric Physics of RAS. This application is capable of running on the computers with Windows, Linux, or macOS and has one code base. The database application of the Brewer measurements is an ASP.NET Core MVC web application with a cross-platform embedded SQLite DBMS as persistent storage. The Brewer measurements database itself is implemented as a .NET Standard shared library in the C# programming language using Entity Framework (EF) Core as an object-relational mapping tool. The application represents data in a hierarchical or relational manner, with the data rationalized into discrete entity classes. All entities are mapped to their database tables with columns corresponding to the properties of the entity classes. Proposed the database application will allow maintaining the integrity and consistency of TOC and UV measurements on Brewer spectrophotometers of the global network.

[1]  M. I. Mead,et al.  A growing threat to the ozone layer from short-lived anthropogenic chlorocarbons , 2017 .

[2]  M. J. Price.  C# 8.0 and .NET Core 3.0 - Modern Cross-Platform Development , 2019 .

[3]  O. V. Postylyakov,et al.  On development of cross-platform software to continue long-term observations with the Brewer Ozone Spectrophotometer , 2018, Remote Sensing.

[4]  C. T. McElroy,et al.  Brewer, SAOZ and Ozonesonde Observations in Siberia , 2012 .

[5]  J. Kerr,et al.  Estimates of the amount of sulphur dioxide injected into the stratosphere by the explosive volcanic , 1983 .

[6]  D. Wardle,et al.  The relationship between total ozone and spectral UV irradiance from Brewer observations and its use for derivation of total ozone from UV measurements , 1997 .

[7]  C. T. McElroy,et al.  Improved retrieval of nitrogen dioxide (NO 2 ) column densities by means of MKIV Brewer spectrophotometers , 2014 .

[8]  I. Senik,et al.  Main Patterns of the Temporal Variability of Surface Ozone in the Region of the Town of Kislovodsk at 870 and 2070 m above Sea Level , 2005 .

[9]  O. Postylyakov,et al.  Implementing the Model/View architecture in software of Brewer Network Spectrophotometer for long-term monitoring of UV radiation and ozone atmospheric content , 2019, IOP Conference Series: Earth and Environmental Science.

[10]  J. Kerr,et al.  Evidence for Large Upward Trends of Ultraviolet-B Radiation Linked to Ozone Depletion , 1993, Science.

[11]  Martin Gruber,et al.  Mastering SQL , 2000 .

[12]  Adam Freeman.  Pro Entity Framework Core 2 for ASP.NET Core MVC , 2018, Apress.

[13]  James B. Kerr,et al.  Surface ultraviolet radiation , 2008 .

[14]  Wayne F. J. Evans,et al.  The Automated Brewer Spectrophotometer , 1985 .

[15]  Oleg V. Postylyakov,et al.  Model of development of cross-platform software for ozone and ultraviolet radiation measurements on the example of Brewer Spectrophotometer , 2019, Atmospheric and Ocean Optics.

[16]  Mark Summerfield.  Advanced Qt Programming : Creating Great Software with C++ and Qt 4 , 2010 .

[17]  C. Zerefos,et al.  Detecting volcanic sulfur dioxide plumes in the Northern Hemisphere using the Brewer spectrophotometers, other networks, and satellite observations , 2016 .

[18]  N. Kenya.  Montreal Protocol Parties: Adjustments and Amendments to the Montreal Protocol on Substances that Deplete the Ozone Layer , 1991, International Legal Materials.

[19]  D. Wardle,et al.  The Brewer reference triad , 2005 .

[20]  J. Haigh,et al.  Evidence for a continuous decline in lower stratospheric ozone offsetting ozone layer recovery , 2018 .

[21]  Joseph C. Rattz,et al.  Pro LINQ: Language Integrated Query in C# 2010 , 2007 .

[22]  A. Bais,et al.  Solar UVB measurements with the double‐ and single‐monochromator Brewer ozone spectrophotometers , 1996 .

[23]  R. Lindenmaier,et al.  Validation of ACE and OSIRIS ozone and NO 2 measurements using ground-based instruments at 80° N , 2012 .