TY  - JOUR
AU  - Betancourt, Clara
AU  - Hagemeier, Björn
AU  - Schröder, Sabine
AU  - Schultz, Martin G.
TI  - Context aware benchmarking and tuning of a TByte-scale air quality database and web service
JO  - Earth science informatics
VL  - 14
SN  - 1865-0473
CY  - Heidelberg
PB  - Springer
M1  - FZJ-2021-02653
SP  - 1597-1607
PY  - 2021
AB  - We present context-aware benchmarking and performance engineering of a mature TByte-scale air quality database system which was created by the Tropospheric Ozone Assessment Report (TOAR) and contains one of the world’s largest collections of near-surface air quality measurements. A special feature of our data service https://join.fz-juelich.de is on-demand processing of several air quality metrics directly from the TOAR database. As a service that is used by more than 350 users of the international air quality research community, our web service must be easily accessible and functionally flexible, while delivering good performance. The current on-demand calculations of air quality metrics outside the database together with the necessary transfer of large volume raw data are identified as the major performance bottleneck. In this study, we therefore explore and benchmark in-database approaches for the statistical processing, which results in performance enhancements of up to 32%.
LB  - PUB:(DE-HGF)16
C6  - 34122663
UR  - <Go to ISI:>//WOS:000658575200001
DO  - DOI:10.1007/s12145-021-00631-4
UR  - https://juser.fz-juelich.de/record/893263
ER  -