Item description for Optimization of SQL Queries for Parallel Machines (Lecture Notes in Computer Science) by Wagar Hasan...
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.
Promise Angels is dedicated to bringing you great books at great prices. Whether you read for entertainment, to learn, or for literacy - you will find what you want at promiseangels.com!
Est. Packaging Dimensions: Length: 9.1" Width: 6.1" Height: 0.5" Weight: 0.55 lbs.
Release Date Dec 19, 1996
ISBN 3540620656 ISBN13 9783540620655
Availability 72 units. Availability accurate as of Feb 21, 2017 11:35.
Usually ships within one to two business days from La Vergne, TN.
Orders shipping to an address other than a confirmed Credit Card / Paypal Billing address may incur and additional processing delay.
Reviews - What do customers think about Optimization of SQL Queries for Parallel Machines (Lecture Notes in Computer Science)?
Another book that is irrelevant in architecting the real solutions for optimizing parallel execution of queries. Feb 16, 2008
I have found NONE information how to Optimize Parallel Execution of the query, or any practical algorithm to optimize the parallel execution of the queries.I was looking for a suggestion/algorithm/approach to design the solutions for Distributed ETLs. I don't know what audience this book had been written for as it looks like personal notes/lectures based on some work that had been put on shelves.
A published dissertation - and just what that says Jun 18, 2001
This is the published form of the author's dissertation (which presumably means he is now Dr. Hasan). And naturally it reads like a dissertation. As such it is of interest only to people in a few fields. A person writing a SQL implementation for a multiprocessor would benefit. More generally a person writing implementations for multi-processors could learn something. The measurements of how to estimate and minimize cost of interprocess communications could be singnificant.
However, it is of little use to a person concerned with optimizing SQL queries for general implementations (much of Hasan's work was at very low level, such as bypassing SQL's built in optimizing and at the implementation level below that normally available to SQL users).
So if you need the specific area of interest then it's excellent but otherwise it's too limited in scope.