Query optimization for parallel execution

  • Authors:

  • Sumit Ganguly;Waqar Hasan;Ravi Krishnamurthy

  • Affiliations:

  • Hewlett-Packard Laboratories, 1501, Page Mill Road, Palo Alto, CA;Hewlett-Packard Laboratories, 1501, Page Mill Road, Palo Alto, CA;Hewlett-Packard Laboratories, 1501, Page Mill Road, Palo Alto, CA

  • Venue:
  • SIGMOD '92 Proceedings of the 1992 ACM SIGMOD international conference on Management of data
  • Year:
  • 1992

Quantified Score

Hi-index 0.00

Visualization

Abstract

The decreasing cost of computing makes it economically viable to reduce the response time of decision support queries by using parallel execution to exploit inexpensive resources. This goal poses the following query optimization problem: Minimize response time subject to constraints on throughput, which we motivate as the dual of the traditional DBMS problem. We address this novel problem in the context of Select-Project-Join queries by extending the execution space, cost model and search algorithm that are widely used in commercial DBMSs. We incorporate the sources and deterrents of parallelism in the traditional execution space. We show that a cost model can predict response time while accounting for the new aspects due to parallelism. We observe that the response time optimization metric violates a fundamental assumption in the dynamic programming algorithm that is the linchpin in the optimizers of most commercial DBMSs. We extend dynamic programming and show how optimization metrics which correctly predict response time may be designed.