企业信息化系统应注重数据库的性能优化

Paying Attention to the Optimization of Database Property in Enterprise Implementing ERP

企业信息化过程中,信息化系统运行后随着数据量的增长,数据库的规模在不断扩大,数据库的性能问题变得越来越突出,一般将影响系统的正常工作,严重时将导致系统瘫痪。介绍了数据库性能优化的策略,并结合开发信息化系统的经验,从逻辑规范化问题和生成物理数据库问题两个方面探讨了数据库设计优化问题,从指定优化器、合理使用索引、使用优化的SQL语句、将程序逻辑统一到数据库系统中四个方面对应用程序优化问题展开了讨论,然后又简要介绍了内存优化、I/O优化等问题。相信不仅对MIS等管理信息系统的软件开发者,而且对使用者都有一定的指导作用。

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.