Query Optimization in Parallel Database Systems : Query optimization in Parallel database with parallel join technique considering skewing and load balancing

A.B.M. Rubaiyat Islam Sadat

ISBN 10: 3639265629 / ISBN 13: 9783639265620

Published by VDM Verlag Dr. Müller, 2010

About this Item

nach der Bestellung gedruckt Neuware - Printed after ordering - 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.

Seller Inventory # 9783639265620

Bibliographic Details

• Title: Query Optimization in Parallel Database Systems : Query optimization in Parallel database with parallel join technique considering skewing and load balancing
• Publisher: VDM Verlag Dr. Müller
• Publication Date: 2010
• Language: English
• ISBN 10: 3639265629
• ISBN 13: 9783639265620
• Binding: Taschenbuch
• Condition: Neu
• Dimensions: 220W x 150H x 4D millimeters 220 millimeters width by 150 millimeters height by 4 millimeters depth
• Weight: 114 grams

About this title

Synopsis

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.

About the Author

Double Masters' from RWTH Aachen, Germany and University of Trento, Italy. BSc in CSE from BUET,Bangladesh in 2006. Awarded 'Erasmus Mundus' scholarship for European Union Masters in Informatics for 2009-2011. Author of an IEEE published conference paper in 'High Performance Computational Systems Biology 2009' held in Trento, Italy.