Re: [bufrtables] BUFR and GRIB2 table information in relational DB?

NOTE: The bufrtables mailing list is no longer active. The list archives are made available for historical reasons.

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/ 



  • 2011 messages navigation, sorted by:
    1. Thread
    2. Subject
    3. Author
    4. Date
    5. ↑ Table Of Contents
  • Search the bufrtables archives: