Kevin Loney 在 Oralce Database 10g: The Complete Reference 一书中给了十条数据库设计的10条戒律:
The ten commandments of humane design:
1. Include users. Put them on the project team and teach them the relational model and SQL.
2. Name tables, columns, keys, and data jointly with the users. Develop an application thesaurus to ensure name consistency.
3. Use English words that are meaningful, memorable, descriptive, short, and singular. Use underscores consistently or not at all.
4. Don’t mix levels in naming.
5. Avoid codes and abbreviations.
6. Use meaningful keys where possible.
7. Decompose overloaded keys.
8. Analyze and design from the tasks, not just the data. Remember that normalization is not design.
9. Move tasks from users to the machine. It is profitable to spend cycles and storage to gain ease of use.
10. Don’t be seduced by development speed. Take time and care in analyses, design, testing, and tuning.
阅读(790) | 评论(0) | 转发(0) |