Optimization of SQL Queries for Parallel Machines [electronic resource] / edited by Waqar Hasan.

Contributor(s): Hasan, Waqar [editor.] | SpringerLink (Online service)Material type: TextTextSeries: Lecture Notes in Computer Science ; 1182Publisher: Berlin, Heidelberg : Springer Berlin Heidelberg, 1996Description: XX, 140 p. online resourceContent type: text Media type: computer Carrier type: online resourceISBN: 9783540496380Subject(s): Computer science | Database management | Information storage and retrieval systems | Computer Science | Database Management | Information Storage and RetrievalAdditional physical formats: Printed edition:: No titleDDC classification: 005.74 LOC classification: QA76.9.D3Online resources: Click here to access online
Contents:
Price of parallelism -- JOQR optimizations -- Scheduling pipelined parallelism -- Scheduling mixed parallelism -- Summary and future work.
In: Springer eBooksSummary: 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.
Item type: E-BOOKS
Tags from this library: No tags from this library for this title. Log in to add tags.
    Average rating: 0.0 (0 votes)
Current library Home library Call number Materials specified URL Status Date due Barcode
IMSc Library
IMSc Library
Link to resource Available EBK6839

Price of parallelism -- JOQR optimizations -- Scheduling pipelined parallelism -- Scheduling mixed parallelism -- Summary and future work.

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.

There are no comments on this title.

to post a comment.
The Institute of Mathematical Sciences, Chennai, India

Powered by Koha