Database Optimization Technology of Power Designer
Chun Feng Ye · Applied Mechanics and Materials · 2014
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.