Interested to Buy Any Domain ? << Click Here >> for more details...
What is denormalization and when would you go for it?
- 9 Answers
- 39357 Views
- NBP, I also Faced
- E-Mail Answers
Answer Posted / sandeepa rout
De-normalization is the process of attempting to optimize
the performance of a database by adding redundant data. It
is sometimes necessary because current DBMSs implement the
relational model poorly.
Only one valid reason exists for denormalizing a relational
design - to enhance performance. However, there are several
indicators which will help to identify systems and tables
which are potential denormalization candidates. These are:
* Many critical queries and reports exist which rely upon
data from more than one table. Often times these requests
need to be processed in an on-line environment.
* Repeating groups exist which need to be processed in a
group instead of individually.
* Many calculations need to be applied to one or many
columns before queries can be successfully answered.
* Tables need to be accessed in different ways by different
users during the same timeframe.
* Many large primary keys exist which are clumsy to query
and consume a large amount of DASD when carried as foreign
key columns in related tables.
* Certain columns are queried a large percentage of the
time. Consider 60% or greater to be a cautionary number
flagging denormalization as an option.
| Is This Answer Correct ? | 18 Yes | 5 No |
Post New Answer View All Answers
What is normalization? Explain different levels of normalization?
Explain about post-relational databases?
How to use online Backups?
How can you fix a poorly performing query?
How can you log an error to the server event log from a stored procedure?
Which four data types cannot be used as a return type from a user-defined function?
What are the 18 schemas?
What are the three basic rules which are to be followed for the relational model of the database?
I have a few records all are same structures data, I want to store data in multiple targets how
How to use timestamp datatypes
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
Explain about xml databases?
Why does this query return 0?
Where is dbms used?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
