Characteristics
- A normalized database has a few basic characteristics
because of which we use them.
- It is designed to store detailed data as efficiently as
possible
- It is designed to provide data integrity. Meaning that the
data maintains its meaning, relationship etc.
- It also results in increase the number of tables and
databases. So the mare data tables we have the more easy to maintain it.
- It is also an excellent solution for adding and managing
daily activities.
challenges:
- A normalized database has few challenges as well
- It is usually very inefficient for data extraction/queries,
that is because of multiple tables and join statements in the queries.
Normalization may also result in multiple databases.
- It doesn’t store the data in the form needed for data
analysis.
- The data is stored in most detailed form. The data is not stored
in the aggregated or discretized form.
- As data storage increases, query efficiency decreases.
- Needed historical data may not be existed in the database.
So, the thing is that normalization is good for OLTP but it
creates problems for historical data warehouse type data.
No comments:
Post a Comment