Speeding-Up Data-Driven Applications with Program Summaries

Guéhis, Sonia; Rigaux, Philippe; Thion-Goasdoué, Virginie

Guéhis, Sonia; Rigaux, Philippe; Thion-Goasdoué, Virginie (2009), Speeding-Up Data-Driven Applications with Program Summaries, in Desai, Bipin C.; Sacca, Domenico; Greco, Sergio, International Database Engineering and Applications Symposium (IDEAS 2009), September 16-18, 2009, Cetraro, Calabria, Italy. ACM International Conference Proceeding Series ACM 2009, p. 66-76

View/Open

publi998.pdf (270.0Kb)

Type

Communication / Conférence

Date

2009

Conference title

13th International Database Engineering and Applications Symposium (IDEAS 2009)

Conference date

2009-09

Conference city

Cetraro

Conference country

Italie

Book title

International Database Engineering and Applications Symposium (IDEAS 2009), September 16-18, 2009, Cetraro, Calabria, Italy. ACM International Conference Proceeding Series ACM 2009

Book author

Desai, Bipin C.; Sacca, Domenico; Greco, Sergio

ISBN

978-1-60558-402-7

Pages

66-76

Metadata

Show full item record

Author(s)

Guéhis, Sonia
Rigaux, Philippe

Thion-Goasdoué, Virginie

Abstract (EN)

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.

Subjects / Keywords

object-relational mapping; data retrieva loptimization; database applications