Paying Attention to the Optimization of Database Property in Enterprise Implementing ERP
Guo Xiu-li · Journal of Shanghai Second Polytechnic University · 2005
With the growth of data quantity after the informatization system is operated,the scale of the database is expanding constantly and the property problem of the database becomes more and more outstanding in the process of enterprise's information construction.These will generally influence the normal work of the system and even lead to system paralysis when being serious.Introduces the strategies of optimizing database property.Combining with experiences of developing informatization system,has discussed the optimization of database design from two aspects of logical standardization and producing physical database.Has discussed the application program optimization from assigning the implement for optimizing,using reasonable indexes,using optimized SQL sentences and unifying the program logically to database system.Then introduces optimizing EMS memory and I/O and so on briefly.Believe that this paper has certain directive significance to not only software developers but also users of management information system such as MIS.