ENGLISH

Optimization of SQL Queries for Parallel Machines

By Waqar Hasan (eds.)

Book information

Publisher
Springer-Verlag Berlin Heidelberg
Year
1996
ISBN
3540620656, 9783540620655
DOI
10.1007/BFb0020710
LCC
QA76.73.S67 H38 1996
Open Library ID
OL1000773M
Language
english
Format
DJVU
Filesize
1 MB (1108239 bytes)
Series
Lecture Notes in Computer Science 1182
Edition
1
Pages
140\147
Topic
Technique
Library
Kolxo3
DPI
300
Time added
2011-01-06 10:13:16
Database Management; Information Storage and Retri

Description

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.

Similar books