Query Optimization in Parallel Database Systems

Query Optimization in Parallel Database Systems

by Sadat A.B.M. Rubaiyat Islam
     
 
In this book, we simulated a parallel database and developed a partition join where both skew effects and load balancing techniques were adopted. A parallel database system seeks to improve performance through parallelization of various operations, such as loading data, building indexes and evaluating queries. Although data may be stored in a distributed fashion, the

Overview

In this book, we simulated a parallel database and developed a partition join where both skew effects and load balancing techniques were adopted. A parallel database system seeks to improve performance through parallelization of various operations, such as loading data, building indexes and evaluating queries. Although data may be stored in a distributed fashion, the distribution is governed solely by performance considerations. Parallel databases improve processing and input/output speeds by using multiple CPUs and disks in parallel. Centralized and client-server database systems are not powerful enough to handle such applications. In parallel processing, many operations are performed simultaneously, as opposed to serial processing, in which the computational steps are performed sequentially. In this work, a novel approach for parallel join was simulated in a parallel environment in addition to other join techniques in a database system. Different load balancing techniques are also discussed with their advantages and disadvantages. An extensive experimental result is also noted with proper graphical representation.

Product Details

ISBN-13:
9783639265620
Publisher:
OmniScriptum GmbH & Co. KG
Publication date:
06/17/2010
Pages:
64
Product dimensions:
6.00(w) x 9.00(h) x 0.15(d)

Meet the Author

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >