This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
34th Annual Hawaii International Conference on System Sciences ( HICSS-34)-Volume 3
Maui, Hawaii
January 03-January 06
ISBN: 0-7695-0981-9
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 general, and they can be applicable to most databases. It is concluded that denormalization can enhance query performance when it is deployed with a complete understanding of application requirements.
Index Terms:
Key word: Database Design, Relational Database Management Systems, Information System, Denormalization, Data Warehousing, Query Tree, Relational Algebra
Citation:
G. Sanders, S. Shin, "Denormalization Effects on Performance of RDBMS," hicss, vol. 3, pp.3013, 34th Annual Hawaii International Conference on System Sciences ( HICSS-34)-Volume 3, 2001
Usage of this product signifies your acceptance of the Terms of Use.