What would be a good way to implement internationalization with ObjectDB?
Let's say we do have a product catalog and we need to provide category and product data internationally. With a relational database we most probably would have two tables, one for locale neutral information, i.e. Product with fields SKU, price, etc. and another one for locale information only, i.e. ProductLocale with fields name, description, etc.
Theoretically with a pure object-orientated approach this would not be necessary, instead we could use maps for the international members and provide a map entry for each locale, then we could call a method for example like getName("en") and it would return the map entry for the english product name, getName() without a locale would just return the default language.
Technically this also probably would work fine with the @ElementCollection annotation, but how would this impact the performance, let's say when there are millions of products each with several multi-language members where for example the long description would be even stored as a rather long HTML code, wouldn't that severely impact the performance?
What would you suggest to do instead?
Thanks a lot for your great support.