View Source

This icon performs an ODB/SQL query on an ODB database (ODB-1) or file (ODB-2). The result is always an ODB file (in ODB-2 format).

From Macro/Python the icon can be called as odb_filter().

A tutorial about using ODB in Metview can be found here.

What is ODB?

ODB is a database developed at ECMWF to store and retrieve large volumes of meteorological observational and feedback data efficiently for use within the IFS.

Currently, ODB comes in two flavours:

ODB-1 (the original hierarchical table format capable of running in a parallel environment within IFS)
ODB-2 (a new flat format with a modern API used for archiving in MARS).

The ODB Filter Editor

ODB Filename

Specifies the path to the input ODB

ODB Icon

Specifies the input ODB as an icon. If both an icon (in ODB Icon) and a filename (in ODB Filename) are specified the icon takes precedence.

ODB Query

Specifies the ODB/SQL query to run.

ODB NB Rows

Specifies the maximum number of rows in the result. If -1 is given here the number of rows is not limited in the output. The default value is -1.