Skip to main navigation menu Skip to main content Skip to site footer

Articles

Vol. LXXVI, No. 2

Building a CHS Bathymetric Data Warehouse

Submitted
June 12, 2015
Published
2015-05-22

Abstract

The CHS is designing and implementing a Source Database for bathymetric data. To store and manage terabytes of bathymetric information for producing CHS products and providing services to clients requires a fresh approach. The implementation of HHCode (Helical Hyperspatial Code) for storing, analyzing and accessing dense spatial data sets in an Oracle Relational Database Management System (RDBMS) is a key technology used to build the data warehouse. The paper addresses the concepts and applications necessary to manage this data within the data repository. Specific areas addressed are aggregation, attribution, and partitioning of the spatial data. The implementation of an on-line, near-line and off-line model to minimize storage costs is described. The approach used to perform horizontal and vertical datum transformations is discussed.