Denormalization Effects on Performance of RDBMS

  title={Denormalization Effects on Performance of RDBMS},
  author={G. Lawrence Sanders and Seungkyoon Shin},
In this paper, we present a practical view of denormalization, and provide fundamental guidelines for incorporating denormalization. We have suggested, using denormalization as an intermediate step between logical and physical modeling to be used as an analytic procedure for the design of the applications requirements criteria. Relational algebra and query trees are used to examine the effect on the performance of relational systems. The guidelines and methodology presented are sufficiently… CONTINUE READING
Highly Cited
This paper has 69 citations. REVIEW CITATIONS


Publications citing this paper.
Showing 1-10 of 25 extracted citations

Informed Schema Design for Column Store-Based Database Services

2015 IEEE 8th International Conference on Service-Oriented Computing and Applications (SOCA) • 2015
View 11 Excerpts
Method Support
Highly Influenced


Tuomo Moilanen
View 8 Excerpts
Highly Influenced

Accelerating Joins and Aggregations on the Oracle In-Memory Database

2018 IEEE 34th International Conference on Data Engineering (ICDE) • 2018
View 1 Excerpt

Main Memory Adaptive Denormalization

SIGMOD Conference • 2016
View 1 Excerpt

A survey of object-relational transformation patterns for high-performance UML-based applications

2015 3rd International Conference on Model-Driven Engineering and Software Development (MODELSWARD) • 2015

69 Citations

Citations per Year
Semantic Scholar estimates that this publication has 69 citations based on the available data.

See our FAQ for additional information.


Publications referenced by this paper.
Showing 1-10 of 26 references

Relational Completeness of Data Base Sublanguages

IBM Research Report • 1972
View 4 Excerpts
Highly Influenced


R. Elmasri
S. B, Fundamental of Database Systems, 3 ed., New York: Addison-Wesley • 2000
View 2 Excerpts

The Birth of the Relational Model

C. J. Date
Intelligent Enterprise Magazine, November • 1998
View 1 Excerpt

The Physics of Logical Modeling,

C. Tupper
Database Programming & Design, September, • 1998
View 1 Excerpt


R. Barquin
H., Planning and Designing the Data Warehousing, Upper Saddle River, New Jersey: Prentice Hall • 1997
View 1 Excerpt

Kranti Toraskar

N. Bolloju
"Data clustering for effective mapping of object models to relational models," Journal of Database Management, vol. 8, no. 4 • 1997
View 2 Excerpts

The Normal is so .

C. J. Date
Interesting," Database Programming & Design, November, • 1997
View 1 Excerpt

Data model design for business analysis,

J. Hahnke
Unix Review, • 1996
View 1 Excerpt

A Performance Oriented Database Design Technique

M. Schkolnick, P. Sorenson

Breaking all the rules: an insider's guide to practical normalization.,

D. Menninger
Data Based Advisor, • 1995
View 1 Excerpt