北京航空航天大学学报 ›› 2007, Vol. 33 ›› Issue (10): 1204-1207.

• 论文 • 上一篇    下一篇

J2EE信息系统数据访问层性能监测与优化设计

唐文忠,许晓曼   

  1. 北京航空航天大学 计算机学院, 北京 100083
  • 收稿日期:2006-11-01 出版日期:2007-10-31 发布日期:2010-09-17
  • 作者简介:唐文忠(1968-),男,河北涿鹿人,研究员,tangwenzhong@buaa.edu.cn.

Performance monitoring and optimization design of database access layer about J2EE management information system

Tang Wenzhong, Xu Xiaoman   

  1. School of Computer Science and Technology, Beijing University of Aeronautics and Astronautics, Beijing 100083, China
  • Received:2006-11-01 Online:2007-10-31 Published:2010-09-17

摘要: 针对J2EE信息系统开发阶段从性能优化的角度实现了数据访问层的设计和一个简易的性能监测工具.首先在数据访问层设计阶段,兼顾考虑开发效率和性能问题提供专门的数据访问操作方法;利用面向方面编程(AOP,Aspect-Oriented Programming)技术对系统数据库访问操作及性能指标进行监视,帮助开发者在系统调试运行阶段根据SQL语句执行情况发现数据访问过程中影响性能的因素;开发根据具体的情况调整数据访问的源代码,然后对造成系统性能瓶颈的SQL语句进行性能调优,并替换数据访问层中低效的SQL语句,最终达到优化系统数据访问性能的目的.

Abstract: Based on the character of J2EE management system performance, an application data layer and a database access monitoring tool were designed and implemented for the applications performance optimization during the development period. At the data layer, some special data access operation methods were provided to improve the data access efficiency and some convenient measures were adopted for posterior system performance optimization works. System database access steps and the performance parameters can be monitored with aspect-oriented programming(AOP) technology, which will help developer to find the key factor of side-effect during system tuning period. According to the monitoring results, developer can modify the source code of side-effect and then optimize the system performance bottle-neck SQL and replace the originally inefficient SQL sentence for the data layer.Therefore the purpose of optimization system database access performance may be achieved.

中图分类号: 


版权所有 © 《北京航空航天大学学报》编辑部
通讯地址:北京市海淀区学院路37号 北京航空航天大学学报编辑部 邮编:100191 E-mail:jbuaa@buaa.edu.cn
本系统由北京玛格泰克科技发展有限公司设计开发