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.
Tang Wenzhong, Xu Xiaoman.Performance monitoring and optimization design of database access layer about J2EE management information system[J] JOURNAL OF BEIJING UNIVERSITY OF AERONAUTICS AND A, 2007,V33(10): 1204-1207