Browse wiki

From CASRAI dictionary
Denormalization
Draft true  +
Extended definition n/a  +
Meta title csr:Denormalization  +
Original source http://searchdatamanagement.techtarget.com/definition/denormalization  +
Research Data Domain true  +
Short definition In a relational database, denormalization
In a relational database, denormalization is an approach to speeding up read performance (data retrieval) in which the administrator selectively adds back specific instances of redundant data after the data structure has been normalized. A denormalized database should not be confused with a database that has never been normalized. After data has been duplicated, the database designer must take into account how multiple instances of the data will be maintained. One way to denormalize a database is to allow the database management system (DBMS) to store redundant information on disk. This has the added benefit of ensuring the consistency of redundant copies. Another approach is to denormalize the actual logical data design, but this can quickly lead to inconsistent data. Rules called constraints can be used to specify how redundant copies of information are synchronized, but they increase the complexity of the database design and also run the risk of impacting write performance.
n the risk of impacting write performance.  +
Type Terms  +
UUID d94fb6c0-194e-4792-9c33-0cd5d9d89277  +
Has query
"Has query" is a predefined property that represents meta information (in form of a subobject) about individual queries.
Denormalization + , Denormalization + , Denormalization + , Denormalization + , Denormalization +
Categories Terms , Drafts , Research Data Domain
Modification date
This property is a special property in this wiki.
12 August 2015 06:27:13  +
hide properties that link here 
  No properties link to this page.
 

 

Enter the name of the page to start browsing from.