What is De-normalization?

De-normalization is the method of attempting to optimize the performance of a database by adding redundant data. It is sometimes essential because current DBMSs execute the relational model poorly. A true relational DBMS would allow for a fully normalized database at the logical level, whereas providing physical storage of data that is tuned for high performance. De-normalization is a method to move from higher to lower normal forms of database modeling in order to speed up database access.

 

Posted Date: 7/10/2013 3:12:13 AM | Location : United States

Ask an Expert

Related Discussions:- What is de-normalization, Assignment Help, Ask Question on What is de-normalization, Get Answer, Expert's Help, What is de-normalization Discussions

Write discussion on What is de-normalization
Your posts are moderated

Write your message here..

Related Questions

Define sequence, Define Sequence A sequence is a set of integers 1, 2, ... Define Sequence A sequence is a set of integers 1, 2, 3 that are generated in order on demand. Sequences are regularly used in databases because lots of applications require ev

4, explain the level architectures of the database management system explain the level architectures of the database management system

ER Diagram, A database will be made to store information about patients in ... A database will be made to store information about patients in a hospital. On arrival, each patient’s personal details (name, address, and telephone number) are recorded where poss

Serialisability, Serialisability: Any schedule that makes the similar resul... Serialisability: Any schedule that makes the similar results as a serial schedule is known as a serialisable schedule. But how can a schedule are determined to be serialisable or n

DBMS , need a DBMS system on any data for assignment. need a DBMS system on any data for assignment.

Online examination system project, entity relationship diagram for online e... entity relationship diagram for online examination system

Many-to-many relationship, Many-to-many : Entities in A and B are related w... Many-to-many : Entities in A and B are related with any number of entities from each other. Example: Taught_by Relationship among course and faculty. One faculty member ca

Reasons for the growing popularity of data mining, Question: Data Minin... Question: Data Mining is the process of extracting knowledge hidden from large volumes of raw data. (a) Using a suitable example, illustrate how Data Mining can be useful t

Optimistic concurrency control, Optimistic Concurrency Control Is locki... Optimistic Concurrency Control Is locking the only way to stop concurrency related problems? There exist some other ways too. One such way is known as an Optimistic Concurrency

Entity relationship diagram, The Enhanced Entity Relationship Diagram (ERD)... The Enhanced Entity Relationship Diagram (ERD) produced with a drawing or case tool. Your EERD must use a ''standard'' notation style such as Crows Foot or Chen. Please note that t