What is the process in which there is redundancy of data to improve performance?

What is the process in which there is redundancy of data to improve performance?

What is the process in which there is redundancy of data to improve performance?

A.
Redundancy

B.
Normalization

C.
Denormalization

D.
Granularity

E.
Cardinality

Explanation:
Denormalization is the process of intentionally backing away from normalization to
improve performance by suppressing join and permitting the use of star transformation technique.
Denormalization should not be the first choice for improving performance and should only be used
for fine tuning of a database for a particular application.



Leave a Reply 6

Your email address will not be published. Required fields are marked *


Leo Yu

Leo Yu

norm
1) each attribute can only have one single value
2) partial dependency is not allowed
3) dependency between two non-primary attribute is not allowed

LOOKS OLAP only conforms 1)

Google

Google

Below youll discover the link to some websites that we feel you must visit.

home improvement ideas

home improvement ideas

just beneath, are quite a few absolutely not related web sites to ours, on the other hand, they are surely worth going over

Nursing Homes CT

Nursing Homes CT

Sites of interest we have a link to

Free Games download

Free Games download

below youll come across the link to some sites that we feel you’ll want to visit