Temi ambientali
Arpa in regione
Arpa Emilia-Romagna
Ti trovi in : ArpaER / Idro-Meteo-Clima / Documenti /

DB-All.e

sim_software

Database for punctual meteorological data


DB-All.e is a fast on-disk database where meteorological observed and forecast data can be stored, searched, retrieved and updated.

Many modern meteorological applications, like data assimilation, quality control and verification, need complex procedures for input of meteorological data, such as decoding and standardisation, and their organisation in memory.

The need to manage a high number of measure points and the need of long spans of space and time dimensions lead to a disproportionate use of RAM and increase the complexity of programming.

This framework allows to manage large amounts of data using its simple Application Program Interface, and provides tools to visualise, import and export in the standard formats BUFR, AOF and CREX.

For a short presentation look at poster presented at 8th COSMO General Meeting 18-22 September 2006, Bucharest (Romania)

News
  • 20/06/2007 Version 3.6 released
  • 15/05/2007 Version 3.4 released
  • 3/10/2006 Added some documentation (introduction), fortran examples and cnf source tarball
Whats new in 3.6 release
  • Fixed bug and changed missing value management
  • Fixed handling of varlist when querying attributes from fortran
  • Focumentation improvements for fapi.tex
  • Hack a way to sync the values of missing values between Fortran and C
  • Fixed bufr decoder to work on ARM
  • Clean records before reading in new data in fortran idba_dammelo/idba_elencamele
Whats new in 3.4 release
  • Provami, graphical application to navigate the database and perform simple editing tasks, now included in the main tar
  • Support for Oracle, Posgresql and SQLite !
  • Python interface (with export for R project for statistical computing)
  • DBall.e is now a standard package in Debian unstable !
  • More control on database import: please see "dbadb help import" for a list of the new options
  • Much improved C API documentation
  • C++ interface
  • BUFR importer can now parse compressed BUFR messages
  • Improved level and time range formatters
  • Redesigned the dba_file API
  • Fixed database export problems
  • Database support works on 64bit systems
Planned
  • Import polar and meteosat2 satellite data (already works, not yet released)
  • Distribution of Fedora 7 rpm

download DB-all.e version 3.6(see above)
download DB-all.e version 3.4(see above)
download DB-all.e version 2.5(minor change in api and some improvement)
download DB-all.e version 2.2(obsolete)

These are the main characteristics of DB-ALL.e:

  • Fortran, C and Python A.P.I. are provided.
  • To make computation easier, data is stored as physical quantities, that is, as measures of a variable in a specific point of space and time, rather than as a sequence of report.
  • Internal representation is similar to BUFR and CREX WMO standard (table code driven) and utility for import and export are included (generic and ECMWF template).
  • Representation is in 7 dimensions: x,y,z, datetime, timerange, variable, attribute, where x,y are geographic coordinate, z table driven vertical coordinate, datetime the reference time, timerange table driven observation and forecast specification, variable table driven unique definition, attribute any more information linked to the data.
  • Unlimited station information dataare possible; real, integer and character data type are supported with precision and data compression optimized.
  • it is fast for both read and for write access.
  • it is based on physical principles, that is, the data it contains are defined in terms of homogeneous and consistent physical data. For example, it is impossible for two incompatible values to exist in the same point in space and time.
  • it can manage fixed station and moving stations such as airplanes or ships.
  • it can manage both observational and forecast data.
  • it can manage data along all three dimensions in space, such as data from soundings and airplanes.
  • report information is preserved. It can work based on physical parameters or on report types.

So it is really an alternative to Netcdf for punctual data.

Project leader: Paolo Patruno
Code developer: Enrico Zini

Copyright (C) 2005,2006 ARPA-SIM urpsim@smr.arpa.emr.it

This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License.

Documentation
Examples

Download the simple examples of DB-All.e fortran API

Build

This table lists the dependencies needed to build DB-ALLe:

Package

Type of dependency

Fedora package

Debian package

Source download

unixodbc

Required

unixODBC-devel

unixodbc-dev

http://www.unixodbc.org/

gperf

Required

gperf

gperf


popt

Required


libpopt-dev


CNF

Only required for the Fortran API

starmet (unofficial, contact DB-ALL.e team)

libcnf-dev

CNF original link
or
CNF suggested tarball


gfortran

Only required for unit tests

gcc-gfortran

gfortran


doxygen

Only required for documentation

doxygen

doxygen


tetex

Only required for documentation

tetex, tetex-latex

tetex-bin


latex2html

Only required for documentation

latex2html
License: Free To Use But Restricted

latex2html
License: Free To Use But Restricted


rst2html

Optionally required for pretty-printing of the README file


python-docutils





In order to run, DB-ALL.e requires an Unix GNU operating system with the following packages installed:

Package

Type of dependency

Fedora package

Debian package

popt

Required


libpopt0

MyODBC

Required

MyODBC

libmyodbc

MySQL

Required if not accessed remotely

mysql >= 4.1.1

mysql-server-5.0

Free software with contribute of Arpa-SIM

Anno pubblicazione: 2007



Materia: Meteo e clima

Nodi: Servizio Idro-Meteo-Clima

Tipologia: Tecnico/istituzionali