Sharing of precompiled database statements in J2EE applications | Zendy

Latorre Roberto | Zendy; López Francisco | Zendy; Martínez Antonio E. | Zendy

AI Assistant Blog Pricing

Home ZAIA Blog

Premium

Sharing of precompiled database statements in J2EE applications

Author(s) -

Latorre Roberto,

López Francisco,

Martínez Antonio E.

Publication year - 2005

Publication title -

software: practice and experience

Language(s) - English

Resource type - Journals

SCImago Journal Rank - 0.437

H-Index - 70

eISSN - 1097-024X

pISSN - 0038-0644

DOI - 10.1002/spe.636

Subject(s) - computer science , database , sql , view , database schema , java , database testing , database tuning , database design , overhead (engineering) , programming language

This paper presents a mechanism to optimize the access to a database for Java 2 Platform Enterprise Edition (J2EE) applications. This mechanism was used in the migration of a PHP application to the J2EE platform to solve the limitations found in the standard database access. The proposed mechanism is optimal for applications with complex database queries and/or a high number of them per time unit. It presents an alternative to the traditional access, which can produce a database overhead in applications with these characteristics. The proposed database access mechanism is based on the idea of sharing precompiled statements and connections between different users. When a part of the application wants to execute an SQL statement, either a new object is created representing it, or an existing one, created previously, is reused. Copyright © 2004 John Wiley & Sons, Ltd.

This content is not available in your region!

Continue researching here.

Having issues? You can contact us here

Accelerating Research