Abstract

Paper
Integrating an OLAP Data Cube with ArcMap
Track: Environmental Management
Authors: William Winner

Advances in inexpensive sensors, remote sensing, and internet data availability have allowed the environmental science community to collect and share data on an unprecedented level. Tools for visualization and data mining have become even more important. Scientists want to navigate datasets in space and time at different scales even when some of the measurements may be at a single location and a single time.

Our Toolbar combines the data mining and retrieval capabilities of an Online Analytical Processor (OLAP) data cube with the spatial analyses and visualizations provided through Esri ArcGIST. OLAP data cubes provide the necessary framework for mining and aggregating large amounts of data. Unfortunately, OLAP technology lacks native geospatial support. Spatial aggregations must be hand-coded and are limited to a simple predetermined set. Using the OLAP results as input to the Esri spatial engine, we enable the scientist to dynamically aggregate both space and time.

William Winner
USDOC NOAA
777 Sonoma Ave., Rm 325
Santa Rosa, California 95404
United States
Phone: 707-575-6099
E-mail: WILLIAM.WINNER@NOAA.GOV