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 Features

Decode and store meteorological and oceanographic forecast fields

WDB has loading programs to load forecasts, analysis, wave and circulations models stored in GRIB1 and FELT format. Metadata is provided for HIRLAM 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).

Open Source

WDB is licensed under GPL2 or (at your option) any later version.

Get WDB

The latest release of WDB is version 0.9.3. WDB has been in limited usage as a forecast archive since version 0.6.0 released in March 2008. WDB entered full production usage on yr.no with version 0.7.8 at the end of February 2009.

WDB Core
Source Code (tar.gz)
WDB Loaderbase
Source Code (tar.gz)
WDB Gribload
Source Code (tar.gz)

Note: Version 0.8.0 introduced interface changes to WDB that are incompatible with 0.7.x. Further interface changes were introduced in WDB version 0.9.0 in order to replace the Postgres BLOB system. Further versions in the 0.9.x series will attempt to stabilize the user interface prior to the release of 1.0.0.

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

Help

The WDB Mailing Lists should be your first stop if you have problems with WDB.

Search the mailing list archives to see if your problem has been answered before. If you are unable to find a response that helps you, post your questions to the appropriate mailing list (non-subscribers can post). For questions not concerning the development of WDB, use the WDB Users mailing list.

Development

WDB is an open-source project; we welcome contributions to the code and we will help you get more involved, if you want to be. Use the For Developers section on the left, and post your questions, ideas, and suggestions to the WDB Development mailing list.

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