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.
Related links
Details
Title
An Online Analytical Processing Database for Environmental Water Quality Analytics
Publication Details
IEEE SOUTHEASTCON 2018, Vol.2018
Resource Type
Conference proceeding
Conference
SoutheastCon 2018 (St. Petersburg, FL, USA, 04/19/2018–04/22/2018)
Publisher
IEEE
Series
IEEE SoutheastCon-Proceedings
Number of pages
5
Grant note
University of West Florida's Office of Undergraduate Research
Hal Marcus College of Science and Engineering ; Cybersecurity and Information Technology; Earth and Environmental Sciences; Research Administration and Engagement