Answers

Question and Answer:

  Home  Database Analyst

⟩ Tell us when might someone denormalize their data?

Typically done for performance reasons, to reduce the number of table joins. This is not a good idea in a transactional environment as there are inherent data integrity risks or performance risks due to excessive locking to maintain data integrity.

Questions related to the Unified Modeling Language (UML) or Entity-Relationship Diagrams (ERDs) may also be asked here.

 138 views

More Questions for you: