May 11, 2024
3 minute read
Denormalization is a data modeling technique that involves duplicating data in multiple tables to improve query performance. It is often used in situations where data is frequently accessed and there is a need for fast response times. While denormalization can improve performance, it can also lead to data redundancy and consistency issues if not implemented correctly.
Why Denormalization?
gu3aoe|
Find a path to becoming a Denormalization. Learn more at:
OpenCourser.com/topic/gu3aoe/denormalizatio
Reading list
We've selected eight books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
Denormalization.
One of the most well-regarded books on database systems. Discusses database normalization forms in a deep and detailed way. is useful as a reference and has great depth on relational database systems.
An overview of many aspects of database management systems, with a focus on practical topics. Discusses the pros and cons of denormalization and various tradeoffs involved with it.
A guide to creating data models for enterprise applications. Although most of the book deals with normalized models, it does include various tips on when and how to denormalize.
A readable, practical guide to database design for the non-specialist. It offers an accessible overview of many database topics, including when and why to denormalize.
A guide to using Unified Modeling Language (UML) for data modeling. It discusses how to use UML to create conceptual and logical data models. The book also includes a chapter on denormalization.
Covers various pitfalls that developers can encounter when using SQL. Several of the tips in the book are related to when and when not to denormalize.
A comprehensive guide to administering SQL Server 2012. Although most of the book focuses on administrative tasks, it does include a chapter on database design. This chapter includes a section on denormalization.
A comprehensive guide to administering Oracle Database 10g. Although most of the book focuses on administrative tasks, it does include several chapters on database design. These chapters include discussions on when and how to denormalize.
For more information about how these books relate to this course, visit:
OpenCourser.com/topic/gu3aoe/denormalizatio
Save
