Research And Design Of Performance Turning About Database Based On J2EE Framework

J2EE is a good solution of enterprise application,which is based on java platform,it can be used to simplify complicated problems in enterprise information devlepment,deployment, management and so on greatly. it also offers transaction,security,naming,persistence and resource management service for enterprise application. All these service can enabled developers focus on developing business logic while ignoring the bottom detail,and provide well mechanism for designing and developing enterprise information program.But when J2EE application framework improve the reuse of the software and decompose complexity of problems, it also brought some questions such as redundant codes,complicatied relations among different tiers,Problem of system performance becomes more extruding.As the core of application system,database's performance is very important to whole system. Conficts between expansibility of modules and the performance,the load,the efficiency and consistency of data which make programmers to get into serious performance traps,the products developed by them can not satisfy the requirement of work.In the paper, our work mainly focuses on expounding how to improve database performance of system which is base on J2EE, which includes how to design the solution of system performance optimization,how to design the reasonable and effective database structure,how to write effective sql,how to improve the database accessing component,how to optimize the database transaction and mixed program based on data exchanging.Combing with the development of J2EE system, we analyze the factors of performance bottle-neck, such as database design, database program, mixed program, program structure, code efficiency, Consequently, as the aim to solving the problem, we present the solution for system performance optimization in aspects of design of database structure, design of technology framework, multi-language message transfer, Hibernate improving and transaction optimizaition.The performance optimization schema has been applied in shipdb, which is approved feasible by testing and analyzing of system performance.