You might also like

More about Query Optimization in Parallel Database Systems

• Book details
• Synopsis
• Trending among others

You get 121 loyalty points

Book 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.

Book details

Book category Books in English Computing & information technology Information technology: general issues

• Full title: Query Optimization in Parallel Database Systems
• Subtitle: Query optimization in Parallel database with parallel join technique considering skewing and load balancing
• Author: A.B.M. Rubaiyat Islam Sadat
• Language: English
• Binding: Paperback
• Number of pages: 64
• EAN: 9783639265620
• ISBN: 3639265629
• ID: 06833875
• Publisher: VDM Verlag
• Weight: 104 g
• Dimensions: 229 × 152 × 4 mm
• Date of publishing: 17. June 2010

Trending among others

---

---

---