Uncovering Database Access Optimizations in the Middle Tier with TORPEDO

A popular architecture for enterprise applications is one of a stateless object-based server accessing persistent data through Object-Relational mapping software. The reported benefits of using ObjectRelational mapping software are increased developer productivity, greater database portability and improved runtime performance over hand-written SQL due to caching. In spite of these supposed benefits, many software architects are suspicious of the "black box" nature of O-R mapping software. Discerning how O-R mapping software actually accesses a database is difficult. The Testbed of Object Relational Products for Enterprise Distributed Objects (TORPEDO) is designed to reveal the sophistication of O-R mapping software in accessing databases in single server and clustered environments. TORPEDO defines a set of realistic application level operations that detect a significant set of database access optimizations. TORPEDO supports two standard Java APIs for O-R mapping, namely, Con...

• Type: Conference
• Year: 2005
• Where: ICDE
• Authors: Bruce E. Martin
• Keywords: Database, ICDE 2005, O-R Mapping Software, Object-Relational Mapping Software, Optimizations Torpedo Reveals