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

Vladimir V. Savinykh; Oleg V. Postylyakov

doi:10.1117/12.2574234

20 September 2020 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

Vladimir V. Savinykh, Oleg V. Postylyakov

Author Affiliations +

Proceedings Volume 11531, Remote Sensing of Clouds and the Atmosphere XXV; 115310U (2020) https://doi.org/10.1117/12.2574234
Event: SPIE Remote Sensing, 2020, Online Only

Conference Poster

Abstract

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.

Citation Download Citation

Vladimir V. Savinykh and Oleg V. Postylyakov "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", Proc. SPIE 11531, Remote Sensing of Clouds and the Atmosphere XXV, 115310U (20 September 2020); https://doi.org/10.1117/12.2574234

ACCESS THE FULL ARTICLE

INSTITUTIONAL
Select your institution to access the SPIE Digital Library.

SELECT YOUR INSTITUTION

PERSONAL
Sign in with your SPIE account to access your personal subscriptions or to use specific features such as save to my library, sign up for alerts, save searches, etc.

PERSONAL SIGN IN

No SPIE Account? Create one

PURCHASE THIS CONTENT

SUBSCRIBE TO DIGITAL LIBRARY

50 downloads per 1-year subscription

Members: $195

Non-members: $335 ADD TO CART

25 downloads per 1 - year subscription

Members: $145

Non-members: $250 ADD TO CART

PURCHASE SINGLE ARTICLE

Includes PDF, HTML & Video, when available