Jeff,
Another aspect, besides keeping track of versions, and supplying various APIs,
is that of an audit trail to a registry. XML type technologies need to validate
models, structures and codelists. I am keen that WMO offers some kind of
registry service (though this could be from a database) to support web services
with URIs etc. Copies could be cached locally to imporve performance.
Gil Ross is preparing a paper on the various approaches. I think this
correspondance betwseen you, enrico, José and Eizi is very relevant.
Best wishes, Chris
Chris Little
OGC Meteorology & Oceanography Domain Working Group
International Telecoms & Projects
Met Office FitzRoy Road Exeter Devon EX1 3PB United Kingdom
Tel: +44(0)1392 886278 Fax: +44(0)1392 885681 Mobile: +44(0)7753 880514
E-mail: chris.little@xxxxxxxxxxxxxxxx http://www.metoffice.gov.uk
-----Original Message-----
From: bufrtables-bounces@xxxxxxxxxxxxxxxx
[mailto:bufrtables-bounces@xxxxxxxxxxxxxxxx] On Behalf Of José Mauro de Rezende
Sent: 16 June 2011 23:17
To: Jeff Ator; Eric Wise; Paul Zamiska; leslie.baran@xxxxxxxx; Lamar Troutman;
Enrico Fucile; Sibylle Krebber; Atsushi Shimazaki; Eizi Toyoda; Weedon,
Richard; Yves Pelletier; Simon Elliott; Jose Mauro de Rezende; Weiqing Qu; Stan
Kellett; bufrtables@xxxxxxxxxxxxxxxx
Subject: Re: [bufrtables] BUFR and GRIB2 table information in relational DB?
Hi Jeff,
My colleague did some work regarding BUFR tables, inserting them on a MySQL
data base. This was done some years ago. We stopped that because we started
using other encoders and decoders. WE thought that time a data base would be a
good way to deal with all those tables. I did some work converting all thos doc
tables provided by WMO into a excel ones and my friend imported all of then
into the data base. Of coarse, it is very out of date now.
I did not worked with GRIB tables that time.
JMauro.
----- Original Message -----
From: "Jeff Ator" <Jeff.Ator@xxxxxxxx>
To: "Eric Wise" <wisee@xxxxxxxxxxxxx>; "Paul Zamiska"
<paul.zamiska@xxxxxxxxxxx>; <leslie.baran@xxxxxxxx>; "Lamar Troutman"
<lamar.troutman@xxxxxxxx>; "Enrico Fucile" <enrico.fucile@xxxxxxxxx>; "Sibylle
Krebber" <Sibylle.Krebber@xxxxxx>; "Atsushi Shimazaki"
<AShimazaki@xxxxxxx>; "Eizi Toyoda" <toyoda@xxxxxxxxxxxxxxxx>; "Richard Weedon"
<richard.weedon@xxxxxxxxxxxxxxxx>; "Yves Pelletier"
<yves.pelletier@xxxxxxxx>; "Simon Elliott" <Simon.Elliott@xxxxxxxxxxxx>; "Jose
Mauro de Rezende" <jmauro@xxxxxxxxxxxx>; "Weiqing Qu"
<w.qu@xxxxxxxxxx>; "Stan Kellett" <Stanley.Kellett@xxxxxxxxxxxxx>;
<bufrtables@xxxxxxxxxxxxxxxx>
Sent: Thursday, June 16, 2011 1:59 PM
Subject: BUFR and GRIB2 table information in relational DB?
> Hi Everyone,
>
> This is more of a general survey question. Here at NCEP, we currently
> have our BUFR and GRIB2 master table information scattered across a
> bunch of ASCII tables, web pages and system files. We're thinking
> about designing and implementing a relational database to store all of
> this information in one place, and then developing methods to allow
> the information to be easily exported from the database into the
> specific formats we need for all of our APIs and other operational
> tasks. We believe the BUFR and GRIB2 tables lend themselves well to
> relational database design (especially when multiple versions of
> tables including local entries need to be stored), and having one
> master repository would alleviate problems we're currently having
> keeping information synchronized across multiple system files and documents.
>
> My question is, has anyone out there ever done or thought about doing
> this type of thing? If so, we'd be interested to correspond with you
> about your experiences, issues encountered, best practices, etc. and
> explore any possible avenues for collaboration. It's hard for us to
> believe that nobody else has ever thought of this before, so if at all
> possible we'd like to benefit from any existing experience in the
> community and avoid re-inventing the proverbial wheel.
>
> Please let me know if you have any thoughts or experience in this area
> that you'd be willing to share. Either way, thanks for your time and
> consideration!
>
> With best regards,
> -Jeff
>
_______________________________________________
bufrtables mailing list
bufrtables@xxxxxxxxxxxxxxxx
For list information or to unsubscribe, visit:
http://www.unidata.ucar.edu/mailing_lists/
