基于冶金行业铁前MES系统数据库治理优化

Ironmaking MES Database's Government and Optimization in Metallurgical Industry

本文针对钢铁企业铁前MES海量级数据库系统SQL查询效率低的问题,通过索引创建、等价改写、业务逻辑优化方法手段,使得数据库性能显著地提升,用户体验感增强。由数据库服务器性能指标(CPU占用率、逻辑读、响应时间)分析计算可知,铁前MES数据库整体性能提升了4倍。

In this paper, aiming at the low SQL querying efficiency in massive database system of Ironmaking MES in the Iron and steel enterprise, database performance is significantly improved and user experience is enhanced through SQL optimization methods such as index creation, equivalent rewriting and transaction logic optimization.According to the analysis and calculation of the database server performance indicators(CPU usage, logical read, response time),the overall performance of MES database has been improves by 4 times.