Overview

The CWMS database is a zone provided for local Corps offices to store time series and relational data used in modeling CWMS watersheds. Oracle was chosen as the database facilitator because it is a widely used database and follows the corporate guidelines for USACE. The CWMS system provides a variety of ways to interact with the CWMS database, including PL/SQL, the CWMS API, and various application programs. The CWMS database schema also stores procedures used to write and receive data to the database. Updates to the procedures and database information to fix bugs and provide added functionality are accomplished through changes to the CWMS schema (CWMS_20). Schema updates are created and tested at HEC and then distributed to districts databases.

Accomplishments

A new Schema update was developed and pushed out to all offices. The team worked to update all offices to the most recent Schema. Changes that were included in the latest schema update include:

  • Support for Virtual location levels
  • Ability to store and retrieve location levels in XML format
  • Improvements to Versioned Time Series
  • Improved vertical datum handling
  • Updated user management
  • Improved message queue management
  • Improved algebraic expression processing
  • Added features to Web Accounts to be used with CDA
  • Improvements to Data Dissemination (public/private data)
  • Bug fixes

The Database team continues to make performance improvements and bug fixes and are developing a new Schema update that will be distributed in the Fall of 2023.  

Databases were setup in the CWBI-test and CWBI-prod and are actively receiving data from district T7s.

Goldengate processes copying data from district T7 to national databases were maintained and adjusted to accommodate COOP exercises.

Field Support and Technology Transfer

The HEC team continues to support the field in proving databases enhancements, bug fixes, and performance improvements. Tech transfer continues in relaying information to the field in terms of how to interact with the database through CDA and through CWMS client software.