Re^4: OO concepts and relational databases

[dragonchild]

Those solve different problems. The first solves the IS-A problem and is the cumbersome and error-prone solution I was referring to. The second solves the problem of a large number of optional attributes and is an alternative to having dozens of columns in your main table, most of which are NULL for any given row.

There have been situations where I will use both solutions for different issues in my design. In fact, you can use both solutions for the same tables, if you need it.

And, the two solutions can be considered interchangeable, for a limited subset of IS-A problems. But, the second solution becomes very unwieldy for most IS-A problems.