Lesson Notes By Weeks and Term - Senior Secondary 3

Parallel and distributed database II

Get it on Google Play
Get it on the Apple App Store
  1. Home
  2. Lesson Notes By Weeks and Term
  3. Senior Secondary 3
  4. 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

  1. Define distributed database
  2. Discuss the advantages and disadvantages of distributed 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 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

  1. Discuss the advantages and disadvantages of                    distributed database

CLASSWORK: As in evaluation

CONCLUSION: The teacher commends the students positively