In terms of databases, is “Normalize for correctness, denormalize for performance” a right mantra?

by

The two most common reasons to denormalize are:

  1. Performance
  2. Ignorance

The former should be verified with profiling, while the latter should be corrected with a rolled-up newspaper 😉

I would say a better mantra would be “normalize for correctness, denormalize for speed – and only when necessary”

More Related Contents:

  1. Is storing a delimited list in a database column really that bad?
  2. What are database normal forms and can you give examples? [closed]
  3. Normalization: What does “repeating groups” mean?
  4. In what way does denormalization improve database performance?
  5. have address columns in each table or an address table that is referenced by the other tables?
  6. Minimum no of tables that exists after decomposing relation R into 1NF?
  7. What’s the better database design: more tables or more columns?
  8. Normalization in database management system
  9. Should each and every table have a primary key?
  10. What is the minimal proof that a database relation is not in BCNF?
  11. Database development mistakes made by application developers [closed]
  12. Database, Table and Column Naming Conventions? [closed]
  13. Surrogate vs. natural/business keys [closed]
  14. How are super- and subtype relationships in ER diagrams represented as tables?
  15. What is the best design for a database table that can be owned by two different resources, and therefore needs two different foreign keys? [closed]
  16. When and why are database joins expensive?
  17. First name, middle name, last name. Why not Full Name?
  18. Relational table naming convention [closed]
  19. What are the design criteria for primary keys?
  20. When I should use one to one relationship?
  21. Supertype-subtype database design
  22. Database optimization orders
  23. What’s wrong with nullable columns in composite primary keys?
  24. Best representation of an ordered list in a database?
  25. NULL permitted in Primary Key – why and in which DBMS?
  26. What are some best practices and “rules of thumb” for creating database indexes?
  27. When we need to use 1-to-1 relationship in database design?
  28. Need help in developing DB logic
  29. Databse architecture (single db vs client specific db) for Building Enterprise Web (RIA) application on cloud
  30. Database – Data Versioning [closed]

Leave a Comment