Parallel execution of SQL queries against large databases offers a solution to the problem of reducing query response. This book addresses the related optimization problem: Given an SQL query, find the plan that delivers the result in minimal time. The author presents and analyzes new theoretical findings and efficient algorithms pertaining to parallel operation at a practical level of granularity relevant to database system operations. The optimization results balance the advantages and costs of parallel execution of SQL queries. The techniques presented are applicable to modern system configurations, where computation is performed on pipelining-capable workstations operating in parallel, and can be used to construct SQL compilers able to exploit parallel machines effectively.

Bibliographic Information

Book Title: Optimization of SQL Queries for Parallel Machines
Editors: Waqar Hasan
Series Title: Lecture Notes in Computer Science
DOI: https://doi.org/10.1007/BFb0020710
Publisher: Springer Berlin, Heidelberg
eBook Packages: Springer Book Archive
Copyright Information: Springer-Verlag Berlin Heidelberg 1996
Softcover ISBN: 978-3-540-62065-5Published: 04 December 1996
eBook ISBN: 978-3-540-49638-0Published: 13 November 2005
Series ISSN: 0302-9743
Series E-ISSN: 1611-3349
Edition Number: 1
Number of Pages: XX, 140
Topics: Database Management, Information Storage and Retrieval

Publish with us

Policies and ethics

Optimization of SQL Queries for Parallel Machines

Overview

Access this book

Other ways to access

Table of contents (6 chapters)

Front Matter

Introduction

Price of parallelism

JOQR optimizations

Scheduling pipelined parallelism

Scheduling mixed parallelism

Summary and future work

Back Matter

Keywords

About this book

Bibliographic Information

Publish with us

Search

Navigation