Comparison and Analysis of Normalization and Denormalization Design in Database
Ding Weiming · Computer Technology and Development · 2006
Database plays a significant role in the software system of big or medium scale,hence,its design becomes an important part of the integral design of the software system.This paper firstly introduces the theory of normalization and denormalization in logical design of database.Then based on enhancing the ability of database,it introduces comparatively the technology of normalization design and some methods of denormalization design and extends to discuss the advantages and disadvantages in these methods.Finally,based on the analysis in the paper,the requirement in practice is also to be considered in the selection of designs.