Performance monitoring and optimization design of database access layer about J2EE management information system
-
摘要: 针对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.
-
Key words:
- J2EE /
- information management /
- applications /
- database access /
- performance monitoring /
- SQL tuning
-
[1] 闵翔.人工智能自动SQL优化 .中国计算机报, 2001-12-24(E20) Min Xiang. Artificial intelligence auto-tunning SQL .Chinese Computer Newspaper, 2001-12-24(E20)(in Chinese) [2] 朱卫琴. 精通Hibernate:Java对象持久化技术详解[M]. 北京:电子工业出版社,2006: 32-36 Zhu Weiqin. Mastering Hibernate:Java object persistence with Hibernate[M].Beijing:Publishing House of Electronics Industry,2006:32-36(in Chinese) [3] Gradecki Joseph D, Lasieck Nicholas. Mastering aspectj: aspect-oriented programming in Java [M]. Hoboken, NJ:John Wiley & Sons, 2003:235-241 [4] Burleson Donald K. Oracle high performance SQL tunning[M]. New York: McGraw-Hill Osborne Media,2001:9-11 [5] Reference manual for Hibernate 3.x . :Red Hat Middleware,LLC,2005.http://www.hibernate.org/5.html [6] Russell Miles. AspectJ cookbook [M]. :O-Reilly Media Inc,2004:12 [7] Java management extention white paper . :Sun Microsystems Inc.2005. http://java.sun.com/products/JavaManagement [8] Thomas Kyte. Expert Oracle database architecture 9i and 10g programming techniques and solutions[M]. Pap/Cdr edition. :Apress,2005:36-42 -
点击查看大图
计量
- 文章访问数: 2977
- HTML全文浏览量: 205
- PDF下载量: 989
- 被引次数: 0
下载:
