Automatic Prefetching by Traversal Profiling in Object Persistence Architectures

Object persistence architectures support transparent access to persistent objects. For efficiency, many of these architectures support queries that can prefetch associated objects as part of the query result. While specifying prefetch manually in a query can significantly improve performance, correct prefetch specifications are difficult to determine and maintain, especially in modular programs. Incorrect prefetching is difficult to detect, because prefetch is only an optimization hint. This paper presents AutoFetch, a technique for automatically generating prefetch specifications using traversal profiling in object persistence architectures. AutoFetch generates prefetch specifications based on previous executions of similar queries. In contrast to previous work, AutoFetch can fetch arbitrary traversal patterns and can execute the optimal number of queries. AutoFetch has been implemented as an extension of Hibernate. We demonstrate that AutoFetch improves performance of traversals in t...

• Type: Conference
• Year: 2006
• Where: ECOOP
• Authors: Ali Ibrahim, William R. Cook
• Keywords: Architectures Support Queries, ECOOP 2006, Object Persistence Architectures, Prefetch Specifications, Programming Languages