Firehose objects unicity on database side

[Matthieu Caneill]

How is one supposed to deal with unicity of Firehose elements in an
SQL database? I mean, in xml files we don't avoid repetitions, but we
should on the database side. A simplified example of this problem
could be:
<analysis>
  <metadata>
    <sut name="python-ethtool" />
    <generator name="coccinelle" />
  </metadata
  <results>
    <issue />
  </results>
</analysis>

<analysis>
  <metadata>
    <sut name="python-ethtool" />
    <generator name="cpychecker" />
  </metadata
  <results>
    <issue />
  </results>
</analysis>

Both metadatas should point to the same SUT, in the db.

Do you have something in mind like a Firehose 'unicity' module?


--
Matthieu