Re: how to link different but related tables

mireero <mireero_at_free.fr> writes:
>Actually, that means that if I have 50 different families of product,
>I'll have 50 "left join", right ?
>Ok for 50, but if I have thousands ?

  The application domain really might be this complex, or   maybe the design has missed some possible simplifications.

  Maintaining such a database might be difficult.

  Performance issues might arise.

  But the philosophy of relational databases is not to have   dynamic attributes, but to hardcode all the attributes of all   entities at design time. So maybe one than has to bite this   bullet.

  I would not write the SQL queries manually in such a case,   but generate them from some more abstract formal specification.   This way, modifications might be easier. Received on Tue Mar 15 2016 - 15:18:31 CET