The current database scheme for AMOS needs to be normalized and optimized a bit. Currently, we store the actual string texts per branch. No surprise the database size is more than 7GB now as we effectively copy all the texts every six months.

The idea is to have a single table for actual string texts (with sha1 hash) that would be 1:N referenced from the amos_repository table.