What is denormalization and when would you go for it?
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 data modeling with example?
Explain the cube operator?
Who are end users in dbms?
What is dbms and its application?
What are the key features of dbms?
How can I detect whether a given connection is blocked?
Explain about relational operator join?
Explain the process of the user request and data generating?
Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
What are the three basic rules which are to be followed for the relational model of the database?
How to combine two function together?
What is the maximum length of an extended property?
State the acid rules?
Where is dbms used?