快速学习关系数据库设计有哪些好的参考? [英] What are some good references for learning relational database design QUICKLY?
问题描述
所以说您已经知道如何使用数据库进行基本操作，例如创建它们... :)，您将了解基本概念，例如视图和联接..以及基本SQL语法....，但是您对解决方案遵循最佳实践"甚至正确"感到不满意.
So say you already know how to do basic things with databases e.g. create them...:) and you understand basic concepts like views and joins..and basic SQL syntax....but you just don't feel comfortable that your solutions follow the "best practices" or are even "correct".
对于试图建立数据库驱动的网站的人，您在哪里可以读到相对严格但直截了当的内容?会说什么时候/为什么联接不好，什么时候缓存，什么样的查询代价高昂，也许有一些练习和提示/解决方案?还有一些数学知识?
Where could you read up something relatively rigorous but straight to the point for someone trying to build a database driven website? something that would say when/why joins are bad, when to cache, what kinds of queries are expensive, maybe have some exercises and hints/ solutions? something with a little bit of math as well?
诸如电子书或一些讲义之类的东西可能是最合适的，但欢迎提出任何建议！
Something like an e-book or some lecture notes may be the most appropriate but any suggestions are welcome!
推荐答案
- 与比您更有经验的人一起工作
- 犯很多错误...并确保您从中汲取教训！
- 开始阅读有关关系数据库的书
- 了解特定dbms(尤其是优化程序)的内部详细信息
唯一真正的捷径是#1.
The only real shortcut is #1.
一旦您开始对建模充满信心，就开始利用特定dbms内部知识.以对您的特定dbms有利的方式倾斜次要设计选择，可能是一大收获. (固定长度记录和群集在MySQL中浮现在脑海.)
Once you begin to feel confident in modelling, start utilizing the knowledge of the internals of your specific dbms. It can be a big payoff to tilt minor design choices in ways that are benificial for your particular dbms. (Fixed length records and clustering comes to mind in MySQL).
您还需要一本关于关系数据库设计基础的无聊的书，以打动您的朋友和同事.为此我找到的最好的书是CJ Date的简介数据库系统.除了像它的作者一样厚重而乏味之外，不幸的是，它还具有关于归一化和关系理论的一些最佳材料.
You also need a thick and boring book on the fundamentals of relational database design to impress your friends and fellow coworkers. The best book for this purpose I've found is C.J Date's An Introduction to Database Systems. Apart from being just as thick and boring as its author, it unfortunately has some of the best material on the topic of normalization and relational theory.
我第二次向@Cade Roux提供有关Celko书籍的建议，尤其推荐"SQL for Smarties"或"Data and Databases".
I second @Cade Roux advice about Celko's books, and especially recommend "SQL for Smarties" or "Data and Databases".
这篇关于快速学习关系数据库设计有哪些好的参考?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
