Speeding-up data-driven applications with program summaries

Sonia Guéhis, Virginie Goasdoué-Thion, Philippe Rigaux
<span title="">2009</span> <i title="ACM Press"> <a target="_blank" rel="noopener" href="https://fatcat.wiki/container/hjiolmjuyrc77lwhatq4lbag64" style="color: black;">Proceedings of the 2009 International Database Engineering &amp; Applications Symposium on - IDEAS &#39;09</a> </i> &nbsp;
We consider the class of database programs and address the problem of minimizing the cost of their exchanges with the database server. This cost partly consists of query execution at the server side, and partly of query submission and network exchanges between the program and the server. The natural organization of database programs leads to submit an intensive flow of elementary SQL queries to the server, and exploits only locally its optimization power. In this paper, we develop a global
more &raquo; ... ization approach. We base this approach on an execution model where queries can be executed asynchronously with respect to the flow of the application program. Our method aims at choosing an efficient query scheduling which limits the penalty of client/server interactions. Our results show that the technique can improve the execution time of database programs by several orders of magnitude.
<span class="external-identifiers"> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1145/1620432.1620440">doi:10.1145/1620432.1620440</a> <a target="_blank" rel="external noopener" href="https://dblp.org/rec/conf/ideas/GuehisGR09.html">dblp:conf/ideas/GuehisGR09</a> <a target="_blank" rel="external noopener" href="https://fatcat.wiki/release/5dqikls66nd27ergqrnd2tvtwm">fatcat:5dqikls66nd27ergqrnd2tvtwm</a> </span>
<a target="_blank" rel="noopener" href="https://web.archive.org/web/20200309235237/https://basepub.dauphine.fr/bitstream/handle/123456789/3869/publi998.pdf;jsessionid=38FB17BE9C7A7B9D1BFEE042F77D54E2?sequence=1" title="fulltext PDF download" data-goatcounter-click="serp-fulltext" data-goatcounter-title="serp-fulltext"> <button class="ui simple right pointing dropdown compact black labeled icon button serp-button"> <i class="icon ia-icon"></i> Web Archive [PDF] <div class="menu fulltext-thumbnail"> <img src="https://blobs.fatcat.wiki/thumbnail/pdf/40/17/4017dd1d59f87851ae4895d453a39a0ca3dd005b.180px.jpg" alt="fulltext thumbnail" loading="lazy"> </div> </button> </a> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1145/1620432.1620440"> <button class="ui left aligned compact blue labeled icon button serp-button"> <i class="external alternate icon"></i> acm.org </button> </a>