问题描述
我很精通SQL Server,MySQL,Oracle等,但把这些数据库产品放在一边,有没有一个资源可以帮助我设计关系数据库?有没有什么像数据库设计的模式或最佳实践?我看过几次数据库通常不可扩展;人们有个人偏好,保留列为isChecked列,其本质上是布尔型的,但存储为Char(1),其值为Y和N,而不是0和1,对我来说听起来更好。在数据库设计时不会犯同样的错误?
将非常感谢与书籍或文章的链接。
提前感谢
几点:
- 尽可能了解问题域。
- 了解您的数据库提供者提供的数据类型的知识,您无法创建良好的数据模型
- 如何正确使用规范化和设计表
- 性能:何时以及如何应用索引,如何编写高效的查询等。
- 何时以及如何使用不同的数据库对象,如视图,过程,函数,触发器
I am pretty well versed with SQL Server, MySQL, Oracle etc but putting these Database products aside, is there a resource that will help me design relational databases well? Is there something like patterns or best practices for database design?
I have seen a few times that database is often not scalable; people have personal preferences with keeping columns like isChecked column which is boolean in nature but stored as Char(1) with values like 'Y' and 'N' instead of 0 and 1 which to me sounds better. Ways not to commit common mistakes while doing database design?
Links to books or articles will be highly appreciated.
Thanks in advance.
A few points:
- Learn as much as you can about problem domain. You can't create good data model without knowing what you're designing for
- Have good knowledge about data types provided by your database provider
- How to properly use normalisation and design tables
- Performance: when and how to apply indexes, how to write efficient queries etc.
- When and how to use different DB objects like views, procedures, functions, triggers
这篇关于数据库设计最佳实践的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!