IATI Consultations Archive

Live discussions and consultations can be found at discuss.iatistandard.org.

Data normalisation: IATI in relational databases

For a number of uses of IATI data you might want to put IATI data into a relational database. The diagram attached shows one possible structure for normalising the data - separating out all the elements that could have a one-to-many relationship with a core activity (or transaction etc.) into their own tables. 

You can see what is mandatory (1..), optional (0..) and only allowed to have a single value (..1) in the documentation for the IATI Standard: http://iatistandard.org/standard/activities

Have more questions? Submit a request

3 Comments

  • 0
    Avatar
    Tim Davies

    A question from the <A href="http://groups.drupal.org/node/161214#comment-542089">Drupal forum</a>: is there a normalisation diagram for the organisation standard? 

  • 0
    Avatar
    Reinier Battenberg

    I noticed that the fact that location~gazetteer entry is a 0-* in the Standard. This allows you to refer to multiple sources (like your own map + Openstreetmap).

    That is not reflected in the (awesome) image.

  • 0
    Avatar
    Reinier Battenberg

    Do you have the sources for this file in an open format (i use dia)? That would be useful for a iati > drupal mapping diagram. am at reinier dot battenberg at mountbatten doot net

Please sign in to leave a comment.