Database Design and Website Interface

The primary objective of the UVMRP database and web design is to provide a user-friendly interface for an end user to search, view, and download data and related descriptions via the Internet. The interface was designed with the client/ server paradigm. To prevent loss of data, backups are made with the use of tape, CD, and DVD, some of which are stored off site. The database containing the aforementioned measurements and derived data is implemented using the open source MySQL (DuBois, 2005). Structure Query Language (SQL) and open source Java Server Faces (JSF) are exploited to integrate different parts into this web accessible database. The database is updated daily when new measurements are collected. In this section, we briefly introduce the information that can be viewed and downloaded from the website, the database structure, and the website interface.

8.6.1 The Data

The information contained in the database can be classified into three categories: metadata, measurements, and derived data. As described in Table 8.4, metadata include site information, instrument history at each site, calibration for each instrument/sensor, and documentation. Raw voltage measurements and calibrated data are recognized as measurements. Derived data are comprised of optical depths, column ozone, and synthetic spectra.

Table 8.4 The structure of the UV-B Database

Data in the UVMRP Database

Meta Data


Location information

Contains the geography of a location as well as internal location

ID and phone number, if a phone line site

Tracking information

Contains the history of a particular instrument. Some instruments

are rotated annually through the calibration facility and moved

to a different location. A history of this information is maintained

for special use

Calibration and angular

All the calibration and angular correction data are stored in a

correction data

table accessible by calibration date. The calibration factors are

interpolated between starting and closing calibration data


The quality control flags, historical instrument configurations, web

interface error codes, meteorological events at locations, and

users of the data are stored in a table to allow dynamic access

and change to its structure



Raw voltage

Contains raw voltage measurements and quality control codes

Cosine corrected data

Contains cosine corrected data for UV-MFRSR and VIS-MFRSR

instruments along with quality control codes

Calibrated data

Data used to calculate both lamp and Langley calibration are

stored in tables but the actual calculation is done at the time of

the data request

Derived Products


Instantaneous optical

Time resolution of 3-min


Average optical depths

Morning and afternoon data

Column ozone

Contains daily column ozone

Synthetic Spectra

Data used to calculate synthetic spectra are stored in tables, but the

actual calculation is performed at the time of the data request

To access the link for the data and derived data, go to the UVMRP website ( Click on the "Data Access" link at the top of the page where you will access the page shown in Fig. 8.10. On this page, the user can view or download the data desired by clicking on the corresponding self explanatory buttons located in the right hand column. The left hand column contains short descriptions about data from each category. Details regarding data processing and corrections are accessible through the links located at the bottom of the right hand column under "Quality Control."

Figure 8.10 Web interface of USDA UV-B Monitoring and Research Program database

Was this article helpful?

0 0

Post a comment