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.