@article{bilgin_chirkova_salo_singh_2004, title={Deriving efficient SQL sequences via read-aheads}, volume={3181}, ISBN={354022937X}, url={https://publons.com/publon/21294482/}, DOI={10.1007/978-3-540-30076-2_30}, abstractNote={Modern information system architectures place applications in an application server and persistent objects in a relational database. In this setting, we consider the problem of improving application throughput; our proposed solution uses data prefetching (read-aheads) to minimize the total data-access time of an application, in a manner that affects neither the application code nor the backend DBMS. Our methodology is based on analyzing and automatically merging SQL queries to produce query sequences with low total response time, in ways that exploit the application’s data-access patterns. The proposed approach is independent of the application domain and can be viewed as a component of container managed persistence that can be implemented in middleware. This paper describes our proposed framework for using generic data-access patterns to improve application throughput and reports preliminary experimental results on discovering key parameters that influence the trade-offs in producing efficient merged SQL queries. The approach is evaluated in the context of a financial domain, which yields the kinds of natural conceptual relationships where our approach is valuable.}, journal={Lecture Notes in Computer Science}, publisher={Berlin; New York: Springer}, author={Bilgin, A. S. and Chirkova, R. Y. and Salo, T. J. and Singh, Munindar P.}, year={2004}, pages={299–308} } @inbook{bilgin_2004, title={Incremental read-aheads}, volume={3268}, ISBN={3540233059}, booktitle={Current trends in database technology: EDBT 2004 Workshops, PhD, DataX, PIM, P2P&DB, and Clustweb, Heraklion, Crete, Greece, March 14-18, 2004: revised selected papers}, publisher={Berlin; New York: Springer}, author={Bilgin, A. S.}, year={2004}, pages={144–153} }