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.

Release Status

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.

WDB Features

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).

WDB Roadmap

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