Optimization of SQL Queries for Parallel Machines

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 fi...

Full description

Bibliographic Details
Main Author: Hasan, Wagar
Format: eBook
Language:English
Published: Berlin, Heidelberg Springer Berlin Heidelberg 1996, 1996
Edition:1st ed. 1996
Series:Lecture Notes in Computer Science
Subjects:
Online Access:
Collection: Springer Book Archives -2004 - Collection details see MPG.ReNa
LEADER 01924nmm a2200301 u 4500
001 EB000659149
003 EBX01000000000000000512231
005 00000000000000.0
007 cr|||||||||||||||||||||
008 140122 ||| eng
020 |a 9783540496380 
100 1 |a Hasan, Wagar 
245 0 0 |a Optimization of SQL Queries for Parallel Machines  |h Elektronische Ressource  |c by Wagar Hasan 
250 |a 1st ed. 1996 
260 |a Berlin, Heidelberg  |b Springer Berlin Heidelberg  |c 1996, 1996 
300 |a XX, 140 p  |b online resource 
505 0 |a Price of parallelism -- JOQR optimizations -- Scheduling pipelined parallelism -- Scheduling mixed parallelism -- Summary and future work 
653 |a Information Storage and Retrieval 
653 |a Database Management 
653 |a Information storage and retrieval systems 
653 |a Database management 
041 0 7 |a eng  |2 ISO 639-2 
989 |b SBA  |a Springer Book Archives -2004 
490 0 |a Lecture Notes in Computer Science 
028 5 0 |a 10.1007/BFb0020710 
856 4 0 |u https://doi.org/10.1007/BFb0020710?nosfx=y  |x Verlag  |3 Volltext 
082 0 |a 005.74 
520 |a 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