Follow through with the denormalization idea on #1585

The implementation should be efficient, having little impact in the ingester performance. The suggestions for better performance can be applied, such as:

• bulk update only after x amount of time instead of updating every insert
• use sqlite instead of postres for helper tables

or other suggestions