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

Editore: VDM Verlag Dr. Müller, 2010

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 | Taschenbuch | Englisch | VDM Verlag Dr. Müller | EAN 9783639265620 | Verantwortliche Person für die EU: preigu GmbH & Co. KG, Lengericher Landstr. 19, 49078 Osnabrück, mail[at]preigu[dot]de | Anbieter: preigu. Codice articolo 101032426

Riassunto:

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.

Informazioni sull?autore: 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.

Dati bibliografici

Titolo: Query Optimization in Parallel Database ...
Casa editrice: VDM Verlag Dr. Müller
Data di pubblicazione: 2010
Legatura: Taschenbuch
Condizione: Neu