DocumentCode
3097272
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
fYear
2008
fDate
21-22 Dec. 2008
Firstpage
336
Lastpage
339
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;
fLanguage
English
Publisher
ieee
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
Type
conf
DOI
10.1109/KAMW.2008.4810492
Filename
4810492
Link To Document