The Design of Optimization Strategy for Physical Data Model

The normalized PDM (physical data model) affects the performance of database. In this paper, the normalization and database data model design of RDBMS were discussed in brief. The deep analyses of the de-normalization principles and methods for design optimization of a physical data model of a test bank based on SQL Server were used to improve the performance of database.