Re: how to link different but related tables

ram_at_zedat.fu-berlin.de (Stefan Ram) writes:
>Performance issues might arise.

  In such an extrem case, one might consider to use base   tables that are denormalized and contain NULLs for the   attributes that do not apply. Denormalization is usually an   anti-pattern, but might be appropriate at times. But this   might have its own performance issues.

  Another anti-pattern are »dynamical attributes«. I.e.,

Product Property Value

1211 Weight 200 kg
1211 Height 10 m
1212 Size 200131 Bytes

  But in extreme cases patterns that usually are   anti-patterns might have to be considered. Received on Tue Mar 15 2016 - 15:27:46 CET