Title :
Dynamic query scheduling in data integration systems
Author :
Bouganim, Luc ; Fabret, Françoise ; Mohan, C. ; Valduriez, Patrick
Author_Institution :
PRiSM Lab., Versailles, France
Abstract :
Execution plans produced by traditional query optimizers for data integration queries may yield poor performance for several reasons. The cost estimates may be inaccurate, the memory available at run-time may be insufficient, or data delivery rate can be unpredictable. We address the problem of unpredictable data arrival rate. We propose to dynamically schedule queries in order to deal with irregular data delivery rate and gracefully adapt to the available memory. Our approach performs careful step-by-step scheduling of several query fragments and processes these fragments based on data arrivals. We describe a performance evaluation that shows important performance gains in several configurations
Keywords :
database management systems; query processing; scheduling; software performance evaluation; cost estimates; data integration systems; dynamic query scheduling; performance evaluation; query optimization; run-time; unpredictable data arrival rate; Costs; Decision support systems; Delay effects; Dynamic scheduling; Engines; Fiber reinforced plastics; Query processing; Relational databases; Runtime;
Conference_Titel :
Data Engineering, 2000. Proceedings. 16th International Conference on
Conference_Location :
San Diego, CA
Print_ISBN :
0-7695-0506-6
DOI :
10.1109/ICDE.2000.839442