设计数据库时最重要的注意事项是什么？ [英] What are the most important considerations when designing a database?
问题描述
我想从经验丰富的程序员那里了解他们认为什么是设计新数据库时最重要的注意事项。 p>首先，最重要的是学习和了解业务领域。
1）你看到一个高交易率像一个繁忙的网站，小公司人力资源系统
2）安全是一个大问题 - 您是处理个人详细信息还是财务数据。或者它只是一个产品目录
3）您的用户会进行很多更新/插入还是主要是只读
4）多少用户，使用模式（峰值负载或均匀分布）
5）您需要24x7,16x5或其他正常运行时间因为你没有停机时间进行维护，所以很难做。
6）数据库有多大？如果它真的很大，你必须设计你的表，以考虑到和/或分区
7）你需要看看企业集群与热故障，或只是正常托管
8）在大多数DB项目中，DB是如何管理的95％的努力用于为用户及其应用程序开发DB管理员忘记了
9）DB管理员，包括备份，对其他系统的更改，与其他系统的集成，数据加载
10）实际上，数据加载和使用现有数据是另一个很大的问题。
这是一个开始
I would like to know from the experienced programmers what they consider to be the most important considerations when designing a new database.
First off and most important learn and understand the business domain.
1) Are you looking at a high transaction rate like a busy web site, or low use like a a small company HR system
2) Is security a big issue - are you handling personal details, or financial data. Or is it just a product catalogue
3) Will your users be doing many updates/inserts or is it mainly read only
4) How many users, what are the usage patterns (peak load or evenly distributed)
5) Do you need 24x7, 16x5 or other uptime, 24x7 is much harder to do as you have no down time for maintenance
6) How big is the DB going to go? If it's really big you'll have to design your tables to take account of that and/or partition
7) Do you need to look at enterprise cluster with hot fail over, or just normal hosting
8) How will the DB be adminstered, in most DB projects 95% of the effort is spent developing for the users and their applications, DB admin is forgotten
9) DB Admin, from previous includes backups, changes to other systems, integration to other systems, data loading
10) Actually Data loading and using existing data is another big issue in its own right.
That's it for a start
这篇关于设计数据库时最重要的注意事项是什么？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
