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

2007 10 O ctober 2007 33 10 Journa l o f Be ijing U nivers ity of A eronautics and A stronautics V ol. 33 N o10 J2EE 唐文忠 许晓曼 ( , 100083 ) 针对 J2EE 信息系统开发阶段从性能优化的角度实现了数据访问 的设计 和 一个简易的性能监测工具. 首先在数据访问 设计阶段, 兼顾考虑开发效率和性能问题提供 专门的数据访问操作方法; 利用面向方面编程( AOP, A sp ectO riented P rogramm ing) 技术对系统 数据库访问操作及性能指标进行监视, 帮助开发者在系统调试运行阶段根据 SQL 语句执行情 况发现数据访问过程中影响性能的因素; 开发根据具体的情况调整数据访问的源代码, 然后对 造成系统性能瓶颈的 SQ L 语句进行性能调优, 并替换数据访问 中低效的 SQL 语句, 最终达 到优化系统数据访问性能的目的. J2EE; 信息系统; 应用; 数据访问; 性能监视; SQ L 性能优化 TP 3 15 A ( 2007) Performance mon ito ring and optmi ization des ign of database access laye r about J2EE management information system T ang W enzhong X u X iaom an ( S chool of Compu ter Science and T echnology, B eijing U n iv ers ity of A eronau tics and A stron aut ics, Beijing 100083, Ch ina) Abstract B ased on the character o f J2EE m anagem en t system perform ance, an application data layer and a datab ase accessm on itoring tool w ere designed and mi p lem ented for the application s perform ance optmi i zation during the deve lopm ent p eriod. A t the data layer, som e sp ecial data access op eration m ethodsw ere pro vided to mi prove the data access effic iency and som e convenient m easures w ere adopted for posterior system perform ance optmi izat ion w orks. System datab ase access step s and the perform ance param eters can be m oni to red w ith asp ectoriented programm ing( AOP ) technology, w hich w ill help develop er to find the key factor o f sideeffect during system tun ing period. A ccord ing to the m on itoring resu lts, develop er can modify the sour