denormalization


Also found in: Dictionary, Medical, Wikipedia.

denormalization

A relational database design that duplicates data in the tables for enhanced performance. Normalization eliminates redundancy, which although efficient for storage can slow down certain kinds of queries. For faster lookups, denormalization adds redundant data in multiple tables or uses redundant tables. See normalization.
Copyright © 1981-2019 by The Computer Language Company Inc. All Rights reserved. THIS DEFINITION IS FOR PERSONAL USE ONLY. All other reproduction is strictly prohibited without permission from the publisher.
References in periodicals archive ?
In-Chip technology processes data 100X faster, says the company, thereby eliminating much of the data preparation and denormalization work typically associated with business analytics.
Lessons from tobacco control indicate that aggressive public education campaigns, regulation of access to tobacco products, and denormalization efforts are powerful means for reducing tobacco use and related harms.
* E-cigarette use could impair denormalization of smoking behaviour and undermine quitting attempts;
We used the resulting model for estimating the [O.sub.3] values, followed by denormalization and retrending of the estimated value.
"To pick up the slack will require innovative thinking around social marketing to continue the denormalization of smoking and more cost effective mechanisms to drive cessation and abstinence for those people wishing to quit," Cobb said.
After denormalization, the mathematical model for the [R.sub.a] in terms of the input parameters can be expressed by the following equation:
Scaling factors in fuzzy controller are very similar to controller gain in a conventional controller which describes the particular input normalization and output denormalization. Hence, these scaling factors are very important with respect to controller stability and performance.
The final prediction results were obtained by compositing the prediction values after denormalization.
Effective smokefree policies are particularly important because of their denormalization of smoking and promotion of cessation.
Denormalization is a strategy for changing social norms and reinforcing a public perception of tobacco use as a health-compromising, socially unacceptable behavior.