Please use this identifier to cite or link to this item: http://scholarbank.nus.edu.sg/handle/10635/99409
Title: Scheduling multiple queries in symmetric multiprocessors
Authors: Tan, K.-L. 
Lu, H. 
Issue Date: Nov-1996
Citation: Tan, K.-L.,Lu, H. (1996-11). Scheduling multiple queries in symmetric multiprocessors. Information Sciences 95 (1-2) : 125-153. ScholarBank@NUS Repository.
Abstract: Traditionally, queries submitted to a database management system are optimized one at a time. However, queries posed to a database usually access some common relations, or share some common intermediate results. Exploiting such sharings can effectively improve the performance of the system. In this paper, we describe our approach to scheduling a group of queries for processing in symmetric multiprocessors. The novel feature of our approach is that we exploit sharings of (base) relations and/or common intermediate results for pipelined plans. We propose an optimization framework that exploits such sharings. Two scheduling algorithms are derived from the framework. The first algorithm, SerialShare, generates a serial plan, while the second algorithm, MultiShare, generates a parallel plan. An analytical model is developed to study the performance of the algorithms. Compared to the traditional method of executing one query after another without sharing, our results show that our proposed algorithms can provide significant performance improvement. © Elsevier Science Inc. 1996.
Source Title: Information Sciences
URI: http://scholarbank.nus.edu.sg/handle/10635/99409
ISSN: 00200255
Appears in Collections:Staff Publications

Show full item record
Files in This Item:
There are no files associated with this item.

Page view(s)

30
checked on Oct 19, 2018

Google ScholarTM

Check


Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.