Logo image
An Online Analytical Processing Database for Environmental Water Quality Analytics
Conference proceeding   Peer reviewed

An Online Analytical Processing Database for Environmental Water Quality Analytics

Dallas Snider, John Derek Morgan, Matthew Schwartz, Austin Adkison and Delikarl Jean Baptiste
IEEE SOUTHEASTCON 2018, Vol.2018
IEEE SoutheastCon-Proceedings
SoutheastCon 2018 (St. Petersburg, FL, USA, 04/19/2018–04/22/2018)
01/01/2018

Metrics

175 Record Views

Abstract

Online analytical processing databases allow for the efficient analysis of vast amounts of data. In this paper, we describe the design of an online analytical processing data cube structure for use in the analysis of multiple measures of environmental water quality data. The measures, also known as facts, will be the quantitative values returned by various water quality tests while the dimensions will be the attributes that describe the what, when and where of the water quality test measures. The data model and build process presented here will allow for varying types of tests and for the insertion of new data as it becomes available. The overall goal of this design is to provide business intelligence capabilities to water quality decision makers.

Details

Logo image