Lesson Notes By Weeks and Term - Senior Secondary 3
Parallel and distributed database II
Parallel and distributed database II
Term: 2nd Term
Week: 4
Class: Senior Secondary School 3
Age: 17 years
Duration: 40 minutes of 2 periods each
Date:
Subject: Data Processing
Topic:- Parallel and distributed database II
SPECIFIC OBJECTIVES: At the end of the lesson, pupils should be able to
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 parallel database |
Students pay attention |
|
STEP 2 EXPLANATION |
He defines and explains distributed database
|
Students pay attention and participates |
|
STEP 3 DEMONSTRATION |
He then discusses the advantages and disadvantages of distributed 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
DISTRIBUTED DATABASE
In a distributed database, data is stored in different systems across a network. For Example, in mainframes, personal computers, laptops, cell phones, etc.
Advantages of distributed database:
1) In a distributed database, data can be stored in different systems like personal computers, servers, mainframes, etc.
2) A user doesn’t know where the data is located physically. Database presents the data to the user as if it were located locally.
3) Database can be accessed over different networks.
4) Data can be joined and updated from different tables which are located on different machines.
5) Even if a system fails the integrity of the distributed database is maintained.
6) A distributed database is secure.
Disadvantages of distributed database:
1) Since the data is accessed from a remote system, performance is reduced.
2) Static SQL cannot be used.
3) Network traffic is increased in a distributed database.
4) Database optimization is difficult in a distributed database.
5) Different data formats are used in different systems.
6) Different DBMS products are used in different systems which increases in complexity of the system.
7) Managing system catalog is a difficult task.
8) While recovering a failed system, the DBMS has to make sure that the recovered system is consistent with other systems.
9) Managing distributed deadlock is a difficult task.
EVALUATION: 1. Define distributed database
CLASSWORK: As in evaluation
CONCLUSION: The teacher commends the students positively