Categories: Lesson Notes

SS3 First Term Data Processing Lesson Note – Parallel and Distributed Database

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

Sunday

Share
Published by
Sunday

Recent Posts

List of Universities Offering Veterinary Medicine in Nigeria

Veterinary medicine is the branch of medicine that deals with the prevention, diagnosis, and treatment…

3 months ago

List of Universities Offering Anthropology in Nigeria

Anthropology is the scientific study of human beings and their cultures. It encompasses a wide…

3 months ago

List of Universities Offering Sociology in Nigeria

Sociology is the scientific study of human society, culture, and behavior. It examines the social…

3 months ago

List of Universities Offering Social Work in Nigeria

Social Work is a profession dedicated to helping individuals, families, and communities to cope with…

3 months ago

List of Universities Offering Religious Studies in Nigeria

Religious studies is an academic discipline that explores the beliefs, practices, and history of various…

3 months ago

List of Universities Offering Public Administration in Nigeria

Public administration is the field of study and practice that focuses on the organization and…

3 months ago