Databases Flashcards
1
Q
Denormalized vs Normalized Databases
A
Normalized databases are designed to minimize redundancy, while denormalized databases are design to optimize read time
2
Q
Denormalization is commonly used to create highly scalable systems
A
True. Joins can be expensive, sometimes easier to store the data redundantly in the same table.
3
Q
When designing a large, scalable database, joins are generally very slow. Thus, you must…
A
denormalize your data. Think carefully how data will be used - you’ll probably need to duplicate the data in multiple tables.