WDB

WDB is a database system designed to store Weather and Water data (also referred to as MHO - Meteorological, Hydrological, and Oceanographic data) in a PostgreSQL database management server. The overall purpose of the system is to improve the effectiveness and quality of IT systems for MHO production. The system is intended to provide a complete real-time and archive data storage solution.

WDB is being developed to:

• Decode and store meteorological, hydrological, and oceanographic observations/point forecasts, including chemical or physical data but excluding biological and environmental data. Such data is assumed to be encoded in BUFR telegrams.
• Decode and store meteorological forecast fields (forecasts, analysis, etc.) as well as oceanographic fields (wave and circulation models). Such data is assumed to be encoded in GRIB-fm5 or GRIB2 files.
• Provide a flexible retrieval interface to the database for Java, Fortran, C++, Perl and Python.

WDB is capable of decoding and storing meteorological and oceanographics forecast fields from GRIB files. It allows retrieval of time-series (points) and entire fields using an SQL-based function interface (tested with C++, but should be compatible with Java, Perl, Python and Fortran).

Current development goals:

• Putting WDB into production in the Hindcast project (multi-terabyte forecast field archive)
• Creating a load-balancing and fail-over solution for the WDB system
• Improving the test framework and documentation
• Improving the performance of the overall system

WDB Subversion Repository

WDB Bugzilla

Code Documentation (WDB 0.6rc1)

Developer Documentation (WDB 0.6rc1)

User Documentation (WDB 0.6rc1)