Joined Tables Inheritance
Explore the joined tables inheritance approach to implement subtyping in databases. Understand how it preserves class hierarchies, reduces data redundancy, and the trade-offs involved with join queries. This lesson helps you grasp an essential pattern for database inheritance modeling.
We'll cover the following...
We'll cover the following...
The Joined Tables Inheritance approach
To avoid the data redundancy problem of Table per Class Inheritance in the case of overlapping segmentations, we can take the JTI approach, exemplified in the SQL table model in the figure below:
This model connects ...