Volume 33 Issue 10
Oct.  2007
Turn off MathJax
Article Contents
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 Astronautics, 2007, 33(10): 1204-1207. (in Chinese)
Citation: 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 Astronautics, 2007, 33(10): 1204-1207. (in Chinese)

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

  • Received Date: 01 Nov 2006
  • Publish Date: 31 Oct 2007
  • 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.

     

  • loading
  • [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
  • 加载中

Catalog

    通讯作者: 陈斌, bchen63@163.com
    • 1. 

      沈阳化工大学材料科学与工程学院 沈阳 110142

    1. 本站搜索
    2. 百度学术搜索
    3. 万方数据库搜索
    4. CNKI搜索

    Article Metrics

    Article views(2914) PDF downloads(988) Cited by()
    Proportional views
    Related

    /

    DownLoad:  Full-Size Img  PowerPoint
    Return
    Return