What is denormalization and when would you go for it?
Answer Posted / sivaraman (gasc)
Denormalization is the process of attempting to optimize
the performance of a database by adding redundant data or
by grouping data. In some cases, denormalization helps
cover up the inefficiencies inherent in relational database
software. A relational normalized database imposes a heavy
access load over physical storage of data even if it is
well tuned for high performance
Is This Answer Correct ? | 22 Yes | 5 No |
Post New Answer View All Answers
What are the 18 schemas?
explain detail about ftp in datastage?
What are the types of database model?
Explain about the database management systems.
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
Explain the rollup operator?
Explain about post-relational databases?
What are the three basic rules which are to be followed for the relational model of the database?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
Where is dbms used?
What are the constraints on severity level in raiseerror?
Explain about relational database management systems?
Who are end users in dbms?
Explain about xml databases?
In which table collections errors are stored.