Normalization
DBMS
The process of organizing database tables to reduce redundancy and improve data integrity through a series of normal forms (1NF, 2NF, 3NF, etc.).
Tags
schema-designoptimizationfundamentals
Related Concepts
Caching
System Design
Storing frequently accessed data in a faster storage layer to reduce latency and database load. Common caching solutions include Redis and Memcached.
performanceoptimizationstorage
Indexing
DBMS
A database optimization technique that creates a data structure to speed up data retrieval operations at the cost of additional write overhead and sto...
optimizationquery-performancestorage
ACID
DBMS
Properties that guarantee reliable database transactions: Atomicity, Consistency, Isolation, and Durability.
transactionsreliabilityfundamentals