I'm looking for a book/site/tutorial on best practices for relational database design, tuning for performance etc. It turns out this kind of resource is a bit difficult to find; there's a lot of "here's normalization, here's ER diagrams, have at it," but not much in the way of real examples. Anyone have any ideas?
我正在寻找关于关系数据库设计，性能调整等最佳实践的书籍/网站/教程。事实证明，这种资源有点难以找到;有很多“这里的规范化，这里是ER图，有它”，但在实例中并不多。有人有主意吗？
4 个解决方案
#2
5
Take a look at the Library of Free Data Models. There are tons of example database designs, with diagrams that cover real-world scenarios (and some just fun/funny ones as well). I haven't ever used one as-is, but it's often been handy to get an idea of how to approach the problem of mapping the needs of the situation into a data model.
看看免费数据模型库。有大量的示例数据库设计，图表涵盖了现实世界的场景（有些只是有趣/有趣的场景）。我从来没有使用过一个原样，但是通常很容易理解如何解决将情况需求映射到数据模型的问题。
#4
1
Here are some resources I could find on the web. They include examples you are looking for:
以下是我可以在网上找到的一些资源。它们包括您正在寻找的示例：
- Designing and creating a Relational Database - Dr Lorna Scammell: Newcastle University Database Adviser
- 设计和创建关系数据库 - Lorna Scammell博士：纽卡斯尔大学数据库顾问
- Sample Data Models for Relational Database Design
- 关系数据库设计的示例数据模型
#1
#2
5
Take a look at the Library of Free Data Models. There are tons of example database designs, with diagrams that cover real-world scenarios (and some just fun/funny ones as well). I haven't ever used one as-is, but it's often been handy to get an idea of how to approach the problem of mapping the needs of the situation into a data model.
看看免费数据模型库。有大量的示例数据库设计，图表涵盖了现实世界的场景（有些只是有趣/有趣的场景）。我从来没有使用过一个原样，但是通常很容易理解如何解决将情况需求映射到数据模型的问题。
#3
#4
1
Here are some resources I could find on the web. They include examples you are looking for:
以下是我可以在网上找到的一些资源。它们包括您正在寻找的示例：
- Designing and creating a Relational Database - Dr Lorna Scammell: Newcastle University Database Adviser
- 设计和创建关系数据库 - Lorna Scammell博士：纽卡斯尔大学数据库顾问
- Sample Data Models for Relational Database Design
- 关系数据库设计的示例数据模型