Autofetch - Eliminate association fetch specifications
Autofetch addresses this by automatically adding the right association fetch directives into your queries. It dynamically monitors a program's traversals off of query results and classifies queries to figure out what associations need to be fetched/prefetched. Programs are easier to write and more modular. It is designed to integrate with any object persistence framework, but right now there is only a Hibernate connector. The library is open source LGPL and the website is http://www.cs.utexas.edu/~aibrahim/autofetch/. The details of Autofetch were published in ECOOP 2006. Let me know if you have questions.
(Note: Opinions expressed in this article and its replies are the opinions of their respective authors and not those of DZone, Inc.)