What is de-normalization, Database Management System

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







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
Related Questions
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

explain the level architectures of the database management system

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: 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

need a DBMS system on any data for assignment.

entity relationship diagram for online examination system

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

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 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

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