Title :
The Design of Optimization Strategy for Physical Data Model
Author :
Zuo, Xuhui ; Zhang, Shiling
Author_Institution :
Sch. of Comput. Sci. & Technol., SouthWest Univ. of Sci. & Technol., Mianyang
Abstract :
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.
Keywords :
SQL; relational databases; SQL Server; database data model design; denormalization principles; design optimization; normalized physical data model; relational database management system; Computer science; Data models; Database languages; Design optimization; Distance learning; Guidelines; Hardware; Indexing; Performance analysis; Testing; Denormalization; MS SQL Server; PDM; design optimization;
Conference_Titel :
Knowledge Acquisition and Modeling Workshop, 2008. KAM Workshop 2008. IEEE International Symposium on
Conference_Location :
Wuhan
Print_ISBN :
978-1-4244-3530-2
Electronic_ISBN :
978-1-4244-3531-9
DOI :
10.1109/KAMW.2008.4810492
