From CASRAI dictionary
|Extended definition||n/a +|
|Meta title||csr:Denormalization +|
|Original source||http://searchdatamanagement.techtarget.com/definition/denormalization +|
|Research Admin Domain||false +|
|Research Data Domain||true +|
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. +
"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|
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.|