Let me give a very basic example ...

 

I have a News entity ... it has Title and Content and some additional functional properties ... However, when displayed there may be many language versions of the Title/Content

 

For the sake of information (if it matters), this is being done in ActiveRecord, currently mapping the single EN record onto a table

 

How could this be best represented? 

 

At a really superfluous level, there could be multiple records per language, and you could just apply a filter when searching ("Language='en') but this would mean the news items were not related to their other language counterparts.

 

Another way might be to store their resources in linked tables, but this will be the vast majority of the entities in this domain (News, Publications, Content, Reports, Subscriptions, etc)

 

Another way might be to have the Repository do the "clever" work ... but "clever" is a bit fuzzy ...

 

 

 

Any thoughts?