Database Optimization Technology of Power Designer

Article Preview

Abstract:

This paper mainly discusses Database optimization technology of Power Designer in the software development..it includes the Horizontal partitioning table, the Vertical partitioning table and Table collapsing.The database optimization technology provided by Power Designer improve the efficiency of the system,such as the required connection of the query operation is reduced, the efficiency of the inquiry time to the record increased greatly compared with that of the original system. The efficiency of the optimized system also increased greatly, the number of the external keys and the indexes is also reduced.

You might also be interested in these eBooks

Info:

Periodical:

Pages:

5544-5547

Citation:

Online since:

May 2014

Authors:

Export:

Price:

Permissions CCC:

Permissions PLS:

Сopyright:

© 2014 Trans Tech Publications Ltd. All Rights Reserved

Share:

Citation:

* - Corresponding Author

[1] Zhang Hong. Software engineering and software development tool. Qinghua University Press, 2005: 1-30.

Google Scholar

[2] Wang Hao. The automatic pharmacy software system design with realizes. Suzhou University master paper, 2008: 1-4.

Google Scholar

[3] Opens Li, Qiu Guoyong. Structured method and object-oriented method comparative analysis", Shanxi Normal university journal (natural sciences version), 2001: 100 -131.

Google Scholar

[4] Wang Xiao sunlight. Sybase Corporation Power Designer Shanghai R&D center, on-line material.

Google Scholar

[5] Zhu Haibing. PDM structure tic analysis method and engineering research. Master paper, 2008: 15.

Google Scholar