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:
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.
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
To gain full access to the note: DOWNLOAD FILE
Veterinary medicine is the branch of medicine that deals with the prevention, diagnosis, and treatment…
Anthropology is the scientific study of human beings and their cultures. It encompasses a wide…
Sociology is the scientific study of human society, culture, and behavior. It examines the social…
Social Work is a profession dedicated to helping individuals, families, and communities to cope with…
Religious studies is an academic discipline that explores the beliefs, practices, and history of various…
Public administration is the field of study and practice that focuses on the organization and…