The content is just an excerpt from the complete note for SS3 First Term Data Processing Lesson Note – Parallel and Distributed Database. Check below to download the complete DOCUMENT

WEEK SIX                                                                           

TOPIC:  PARALLEL AND DISTRIBUTED DATABASE

CONTENT: 

  1. Architecture for parallel database
  2. Introduction to distributed databases

Sub-topic 1

Architecture for parallel database

Parallel Database

A parallel database system, is one that seeks to improve performance through parallel implementation of various operations such as loading data, building indexes, and evaluating queries.

Architecture for parallel database

The basic idea behind parallel database is to carry out evaluation steps in parallel whenever possible in order to improve performance.

Three main architectures have been proposed for building DBMSs.

  1. In a shared-memory system, multiple CPU are attached to an interconnection network and can access a common region of main memory.
  2. In a shared-disk system, each CPU has a private memory and direct access to all disks through an interconnection network.

iii.       In a shared-nothing system, each CPU has local main memory and disk space, but no two CPUs can access the same storage area; all communication between CPUs is through a network connection.

The three architectures are illustrated below: (diagram attached)

Advantages of Parallel Databases

  1. Higher Performance: with more CPUs available to an application, higher speedup and scaleup can be attained.

To gain full access to the note: DOWNLOAD FILE

Copyright warnings! Do not copy.