Name
Abstract | ||
|---|---|---|
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 optimization 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. |
Year | DOI | Venue |
|---|---|---|
2009 | 10.1145/1620432.1620440 | IDEAS |
Keywords | DocType | Citations |
execution time,execution model,efficient query scheduling,speeding-up data-driven application,database server,query execution,server side,query submission,database program,application program,server interaction,program summary,global optimization,object relational mapping,digital humanities,organisation,data retrieval,client server | Conference | 1 |
PageRank | References | Authors |
0.38 | 15 | 3 |
Name | Order | Citations | PageRank |
|---|---|---|---|
| Sonia Guéhis | 1 | 4 | 2.15 |
| Virginie Goasdoué-Thion | 2 | 1 | 0.38 |
| Philippe Rigaux | 3 | 444 | 110.71 |