Single Table Inheritance (Database Inheritance design options) pros and cons and in which case it us

Posted by Yosef on Stack Overflow See other posts from Stack Overflow or by Yosef
Published on 2010-05-31T23:31:09Z Indexed on 2010/05/31 23:53 UTC
Read the original article Hit count: 624

Hi, I study about today about 2 database design inheritance approaches:

1. Single Table Inheritance

2. Class Table Inheritance

In my student opinion Single Table Inheritance make database more smaller vs other approaches because she use only 1 table.

But i read that the more favorite approach is Class Table Inheritance according Bill Karwin.

My Question is:

Single Table Inheritance pros and cons and in which case it used?

thanks, Yosef

© Stack Overflow or respective owner

Related posts about database

Related posts about database-modeling