WDB

WDB is a database system designed to store meteorological, hydrological and oceanographic (MHO) data in a PostgreSQL database management server. The purpose of the WDB system is to improve the quality and effectiveness of IT systems for MHO production by providing a flexible and effective data storage solution for real-time and archive data.

WDB is an open-source project licensed under GPL2 or (at your option) any later version.

WDB version 0.7.4 is now available. WDB version 0.6.0 was the first version of WDB leveraged into a production system (the terabyte-sized field archive Hindcast). The new version contains interface improvements and several important bug fixes.

To subscribe to release information about WDB, register on Freshmeat and subscribe to WDB.

• Decode and store meteorological forecast fields
  • WDB has loading programs to load forecasts, analysis, etc. stored in GRIB1 format. Metadata is provided for HIRLAM fields

• Decode and store oceanographic fields
  • WDB has loading programs to load wave and circulation models stored in GRIB1 files. Metadata is provided for WAM fields

• Flexible retrieval interface
  • The WDB Call Interface (WCI) allows the extraction of entire fields or points (time-series) from the database using an SQL-based function interface.
  • WCI is compatible with C++; it should be usable in C, Java, Perl, Python, and Fortran as well (however, these interfaces are not yet tested).

See the roadmap for a detailed roadmap of WDB, broken down by release. On the executive level, the future development of WDB is targetted toward:

• Putting WDB into production in the Hindcast project (multi-terabyte forecast field archive)
• Improving the performance of the overall system; but in particular the extraction of forecast points from fields in time series
• Improving the test framework and documentation
• Creating a load-balancing and fail-over solution for the WDB system