扩展实体关系模型到表（子类） [英] Extended Entity-Relationship Model to tables (subclasses)

问题描述

在EER模型中有子类实体。我想知道什么是实现在一个真正的SQL表的方式，或者如果有任何指南，可能会帮助我了解如何实现实体子类到表中，将有所帮助。感谢

In the EER model there are subclasses entities. I was wondering what's the way to implement that in a real SQL Table or if there is any guide that might help me out to understand how to implement entities subclasses into tables that would help. Thanks

推荐答案

Martin Fowler的书企业应用程序架构的模式涵盖了用于子类化表的解决方案：

Martin Fowler's book Patterns of Enterprise Application Architecture covers solutions for subclassing tables:

• 单一表格继承


• 类表继承


• 混凝土表继承

• Single Table Inheritance
• Class Table Inheritance
• Concrete Table Inheritance

这些对应于@ spencer7593的答案中的选项， Java& Hibernate。

These correspond to the options in the answer from @spencer7593, without being tied to Java & Hibernate.

这篇关于扩展实体关系模型到表（子类）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！