Lesson Notes By Weeks and Term - Senior Secondary 3

Term: 2^nd Term

Week: 3

Class: Senior Secondary School 3

Age: 17 years

Duration: 40 minutes of 2 periods each

Date:       

Subject:      Data Processing

Topic:-       Parallel and distributed database I

SPECIFIC OBJECTIVES: At the end of the lesson, pupils should be able to

1. Define parallel database
2. Discuss the architectures of parallel database
3. Enumerate the benefits of parallel database

INSTRUCTIONAL TECHNIQUES: Identification, explanation, questions and answers, demonstration, videos from source

INSTRUCTIONAL MATERIALS: Videos, loud speaker, pictures, Data Processing for senior Secondary Education by Hiit Plc, WAPB Computer Studies for Senior Secondary I by Adekunle et al, On-line Materials.

INSTRUCTIONAL PROCEDURES

PERIOD 1-2

PRESENTATION	TEACHER’S ACTIVITY	STUDENT’S ACTIVITY
STEP 1 INTRODUCTION	The teacher reviews the previous lesson on checkpointing and media recovery	Students pay attention
STEP 2 EXPLANATION	He defines and explains parallel database. He also outlines the architectures of a parallel database	Students pay attention and participates
STEP 3 DEMONSTRATION	He the discusses the benefits of parallel database	Students pay attention and participate
STEP 4 NOTE TAKING	The teacher writes a summarized note on the board	The students copy the note in their books

 

NOTE

PARALLEL DATABASE

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.

 

ARCHITECTURES OF PARALLEL DATABASE

1. Shared memory architecture

Where multiple processors share the main memory (RAM)space but each processor has its own disk (HDD). If many processes run simultaneously, the speed is reduced, the same as a computer when many parallel tasks run and the computer slows down.

 

2. Shared disk architecture

Where each node has its own main memory, but all nodes share mass storage, usually a storage area network. In practice, each node usually also has multiple processors.

 

3. Shared nothing architecture

Where each node has its own mass storage as well as main memory.

 

Benefits of Parallel Database

Parallel database technology can benefit certain kinds of applications by enabling:

1. Higher Performance with more CPUs available to an application, higher speedup and scaleup can be attained.
2. Higher Availability Nodes are isolated from each other, so a failure at one node does not bring the whole system down.
3. Greater Flexibility An OPS environment is extremely flexible. Instances can be allocated or de-allocated as necessary.
4. More Users: Parallel database technology can make it possible to overcome memory limits, enabling a single system to serve thousands of users.

 

EVALUATION:    1. Define parallel database

2. Outline the architectures of a parallel database
3. Discuss the benefits of parallel database

CLASSWORK: As in evaluation

CONCLUSION: The teacher commends the students positively