About Normalization and Semi-Normalization

This is an article about normalization and semi-normalization.

Hello!

Today, we learned about regularization and semi-regularization!

Normalization

Normalization is a process used in database design to minimize redundancy and to maintain data consistency.

The main goal is to eliminate data duplication and prevent anomalies that can occur when inserted, updated, or deleted.

Goals

1. Minimize data duplication: One data must be stored in one location.
2. Data Dependency Management: It should be easy to modify or delete data by minimizing dependencies between tables in the database.
3. Prevent insertion, update, and deletion anomalies: Avoid anomalies (update anomalies, insertion anomalies, deletion anomalies) that can occur when data is inserted, updated, or deleted.

the normalization process

1. 1st Normalization (1NF): All property values must be atomic.
2. 2nd Normalization (2NF): Remove partial functional dependencies so that all properties must be fully functional dependencies on the candidate key.
3. 3rd Normalization (3NF): Remove transitional functional dependencies so that all properties are not transitional functional dependencies on candidate keys.
4. Voice-Code Normalization (BCNF): All determinants must be candidate keys.

Denormalization

Semi-normalization is the process of reassembling normalized tables to improve the performance of a database.

It is primarily used in read operations-intensive online analytical processing (OLAP) environments, increasing data duplication and reassembling some normalized tables.

Goals

1. Improved lookup performance: The process of putting regularized tables back together improves the speed of lookup operations.
2. Reduce response time: Reduce response time when running complex queries on large databases.
3. Save storage space: Save storage space for redundant data and optimize database capacity.

a semi-normalization method

1. Combining tables: Reunite normalized tables to optimize lookup operations.
2. Add duplicate data to speed up lookup operations by adding duplicate data.
3. Add Calculated Fields: Pre-calculates, stores, and uses data that requires complex operations.

at the end of the day

Normalization and semi-normalization are the two main strategies for minimizing duplication of data and improving the performance of databases in database design.

Normalization is used to maintain data consistency and minimize data redundancy, and semi-normalization is the process of recombining data to improve the performance of lookup operations.

When designing a database, it is important to optimize the performance of the database by properly combining normalization and semi-normalization.

Thank you!