I know some patterns to DB table schema:
我知道DB表模式的一些模式:
-
one-one: same table.
一一:同桌。
-
one-many: Having 'many' table's primary key a member of 'one' table.
one-many:让'many'表的主键成为'one'表的成员。
-
many-many: Having a new relationship table contains both table's primary key.
many-many:拥有一个新的关系表包含两个表的主键。
What are some other patterns?
还有什么其他模式?
2 个解决方案
#1
How about?:
- Relational Database Design Patterns?
- Table design patterns
- Anti-patterns
关系数据库设计模式?
表设计模式
#2
I wouldn't consider those 'patterns' since the term patterns are used for more or less complex problem solutions in a given technology, including some notion on the circumstances in which one pattern in superior to another applicable pattern.
我不会考虑那些“模式”,因为术语模式在给定技术中用于或多或少复杂的问题解决方案,包括一种模式优于另一种适用模式的情况。
The examples you are giving are more the very basic building blocks of relational database schema design. If you want to learn more about this I suggest search for 'database normalization'.
您提供的示例更多是关系数据库模式设计的基本构建块。如果您想了解更多相关信息,我建议您搜索“数据库规范化”。
Some terms that could be considered patterns in the database world are:
可以在数据库世界中考虑模式的一些术语是:
star schema snowflake schema Entity-attribute-value model
星型模式雪花模式实体 - 属性 - 值模型
#1
How about?:
- Relational Database Design Patterns?
- Table design patterns
- Anti-patterns
关系数据库设计模式?
表设计模式
#2
I wouldn't consider those 'patterns' since the term patterns are used for more or less complex problem solutions in a given technology, including some notion on the circumstances in which one pattern in superior to another applicable pattern.
我不会考虑那些“模式”,因为术语模式在给定技术中用于或多或少复杂的问题解决方案,包括一种模式优于另一种适用模式的情况。
The examples you are giving are more the very basic building blocks of relational database schema design. If you want to learn more about this I suggest search for 'database normalization'.
您提供的示例更多是关系数据库模式设计的基本构建块。如果您想了解更多相关信息,我建议您搜索“数据库规范化”。
Some terms that could be considered patterns in the database world are:
可以在数据库世界中考虑模式的一些术语是:
star schema snowflake schema Entity-attribute-value model
星型模式雪花模式实体 - 属性 - 值模型