摘要
对大型企业级管理信息系统后台数据库执行SQL审查(SQL Review),在表设计、索引设计、SQL编码等方面搜集潜在的性能隐患及缺陷,可为后续开展数据库深层次性能优化工作理清思路、明确方向。文章通过提取典型的SQL审查对象,制定审查规则、赋予权重,并建立评分机制,形成了一整套SQL审查指标体系。权衡优化成本与收益,重点运用面向表索引和SQL优化的数据库性能优化技术,以相对低的成本使得企业管理信息系统性能有质的改善,显著提升响应速度。
A SQL review for large enterprise management information systems＇ database can collect potential performance threats and bugs on table, index and SQL code, which can make a clear direction for the future work of deepening database＇s performance optimization. During the SQL review, we extract some typical targets weighted, establish review rules, build the scoring mechanism, Then, a set of SQL review index system is formed. After a tradeoff of costs and benefi ts, two kinds of database optimization technologies including database index tuning and SQL tuning are used to improve the performance and response speed of enterprise management information systems with low cost.
出处
《电力信息与通信技术》
2016年第4期146-153,共8页
Electric Power Information and Communication Technology
关键词
数据库
SQL审查
索引
性能优化
database
SQL review
index
performance optimization
