Parallel and Distributed Databases for SS 3

Class: SS 3
Term: First Term
Week: 5
Age: 16 years
Duration: 45 minutes
Subject: Data Processing
Previous Lesson: Crash Recovery Methods and Write-Ahead Log Protocol
Topic: Parallel and Distributed Database
Subject Matter: architecture for parallel database: introduction to distributed database

Specific Objectives

By the end of the lesson, pupils/students should be able to:

Cognitive Domain

• Define parallel database.
• Define distributed database.
• Explain the architecture for parallel database systems.
• Identify different types of parallel database architectures.

Affective Domain

• Appreciate the importance of parallel and distributed databases in modern data management.
• Participate actively in class discussions.

Psychomotor Domain

• Illustrate the different architectures for parallel databases.

Reference Materials

The following resources were used in planning this lesson:

• 2025 Revised 9 Years Basic Education Curriculum
• Relevant State Unified Scheme of Work
• Data Processing for Senior Secondary Schools Textbook
• The HeadTeacher Scheme of work

Instructional Materials

The teacher will teach this lesson with the aid of:

• A chart showing architectures for parallel databases (shared-memory, shared-disk, shared-nothing).
• Whiteboard and markers.
• Projector (optional, for displaying diagrams).

Rationale for the Lesson

This lesson is important as it introduces students to advanced database concepts essential for managing large volumes of data efficiently. Understanding parallel and distributed databases prepares students for careers in data management and system design, where scalability and performance are critical.

Prerequisite/Previous Knowledge

Students should have a basic understanding of database concepts, including database systems, data storage, and the need for efficient data retrieval.

Lesson Content/Board Summary

Parallel and Distributed Database

Definition of Parallel Database

A parallel database system is a database system that seeks to improve performance by parallelizing various operations, such as loading data, building indexes, and evaluating queries. It utilizes multiple CPUs and disks to execute operations in parallel.

Architecture for Parallel Database

Parallel database architectures are designed to distribute data and processing across multiple resources to enhance performance and scalability. The main types include:

1. Shared-Memory Architecture:
   1. In this architecture, all processors share a common main memory.
   2. Access to data is fast because all processors can directly access any part of the database in memory.
   3. However, scalability is limited due to potential memory contention and bus bottlenecks as the number of processors increases.
   4. It is typically used in tightly coupled systems with a small number of processors.
2. Shared-Disk Architecture:
   1. All processors have their own private memory but share access to all disks.
   2. Each processor can directly access any disk, allowing for flexible data partitioning.
   3. This architecture offers better scalability than shared-memory systems because memory is not shared.
   4. However, cache coherence and locking mechanisms are complex to manage, as multiple processors might try to access and modify the same data block on disk.
3. Shared-Nothing Architecture:
   1. Each processor has its own private memory and its own private disk(s).
   2. Data is partitioned across the disks, and each processor manages its own portion of the database.
   3. This architecture offers the highest scalability and fault tolerance because processors operate independently.
   4. Communication between processors is done via a high-speed interconnection network.
   5. It is more complex to implement and manage data distribution and query optimization.

Introduction to Distributed Database

A distributed database is a database in which storage devices are not all attached to a common processing unit. It is stored on multiple computers, located in the same physical location or spread over a network, and appears to users as a single logical database.

1. Characteristics of Distributed Databases:
   1. Data Distribution: Data is fragmented and stored across multiple sites.
   2. Location Transparency: Users do not need to know where the data is physically stored.
   3. Replication: Copies of data can be stored at multiple sites for availability and performance.
   4. Concurrency Control: Mechanisms are in place to manage simultaneous access to data across different sites.
   5. Distributed Query Processing: Queries are broken down and executed across multiple sites.
2. Advantages of Distributed Databases:
   1. Improved reliability and availability.
   2. Enhanced performance through parallel execution.
   3. Easier scalability.
   4. Better data sharing and local autonomy.

Teaching Methods/Instructional Techniques

Discussion, Explanation, Question and Answer, Demonstration, Guided Practice

Instructional Procedures

Step 1: Introduction

Time: 5 minutes

Teaching Skill: Engaging/Activating prior knowledge

Teacher’s Activity: The teacher greets the students and asks them to recall what they know about traditional database systems and the challenges of managing very large datasets. The teacher then introduces the topic of parallel and distributed databases as solutions to these challenges.

Pupils’ Activity: Students respond to the teacher’s questions and listen attentively to the introduction.

Learning Point: Database challenges overview

Step 2: Definition of Parallel Database

Time: 7 minutes

Teaching Skill: Explaining/Defining

Teacher’s Activity: The teacher defines a parallel database system, emphasizing its goal of improving performance by using multiple processors and disks. The teacher uses simple examples to illustrate the concept.

Pupils’ Activity: Students listen, ask questions for clarification, and note down the definition.

Learning Point: Parallel database definition

Step 3: Architecture for Parallel Database (Shared-Memory)

Time: 8 minutes

Teaching Skill: Explaining/Illustrating

Teacher’s Activity: The teacher explains the shared-memory architecture for parallel databases, using the provided chart or drawing a simple diagram on the board. The teacher highlights its characteristics, advantages, and limitations.

Pupils’ Activity: Students observe the diagrams, listen to the explanation, and ask questions.

Learning Point: Shared-memory architecture

Step 4: Architecture for Parallel Database (Shared-Disk)

Time: 7 minutes

Teaching Skill: Explaining/Comparing

Teacher’s Activity: The teacher explains the shared-disk architecture, comparing it with the shared-memory model. The teacher uses the chart to illustrate its components and discusses its benefits and challenges.

Pupils’ Activity: Students listen, compare the architectures, and engage in a brief discussion.

Learning Point: Shared-disk architecture

Step 5: Architecture for Parallel Database (Shared-Nothing)

Time: 7 minutes

Teaching Skill: Explaining/Contrasting

Teacher’s Activity: The teacher explains the shared-nothing architecture, emphasizing its high scalability and fault tolerance. The teacher contrasts it with the previous two architectures and discusses its implementation complexities.

Pupils’ Activity: Students listen, identify key differences, and ask clarifying questions.

Learning Point: Shared-nothing architecture

Step 6: Introduction to Distributed Database

Time: 6 minutes

Teaching Skill: Defining/Describing

Teacher’s Activity: The teacher introduces the concept of a distributed database, explaining how data is spread across multiple locations but appears as a single logical unit. The teacher briefly mentions its characteristics and advantages.

Pupils’ Activity: Students listen and grasp the fundamental idea of distributed databases.

Learning Point: Distributed database concept

Step 7: Evaluation/Review

Time: 5 minutes

Teaching Skill: Questioning/Assessment

Teacher’s Activity: The teacher evaluates the learning by asking the following questions:

1. What is a parallel database?
2. Mention two types of parallel database architectures.
3. Briefly explain the shared-memory architecture.
4. What is a distributed database?

Pupils’ Activity: Pupils answer orally and in writing.

Learning Point: Understanding database concepts

Step 8: Note-Taking

Time: 4 minutes

Teaching Skill: Guided Writing

Teacher’s Activity: The teacher guides pupils/students to copy the essential Board Summary notes on parallel and distributed databases into their notebooks.

Pupils’ Activity: Pupils/students copy the notes carefully into their notebooks.

Learning Point: Recording lesson information

Step 9: Conclusion

Time: 1 minute

Teaching Skill: Summarizing

Teacher’s Activity: The teacher briefly summarizes the key concepts of parallel and distributed databases, emphasizing their role in high-performance data management.

Pupils’ Activity: Students listen and reflect on the lesson.

Learning Point: Lesson consolidation

Continuous Assessment/Further Study

Type: Homework

Instruction: Answer the following questions in your notebook.

1. Differentiate between shared-disk and shared-nothing parallel database architectures.
2. List three advantages of using a distributed database system.
3. Research and write a short paragraph on a real-world application where a parallel database would be essential.

Lesson Keywords

• Parallel Database – A database system that uses multiple processors and disks to execute operations concurrently.
• Distributed Database – A database stored on multiple computers across a network, appearing as a single logical unit.
• Shared-Memory Architecture – Parallel database architecture where all processors share a common main memory.
• Shared-Disk Architecture – Parallel database architecture where processors have private memory but share access to all disks.
• Shared-Nothing Architecture – Parallel database architecture where each processor has its own private memory and disk(s).

Differentiation

For weaker learners: Provide simplified diagrams and focus on the basic definitions of parallel and distributed databases. Offer more direct questions during evaluation.
For faster learners: Encourage them to research specific examples of companies or systems that utilize parallel or distributed databases and present their findings.

Suggested Lesson Videos

For further understanding, search on YouTube for:
“Parallel and Distributed Databases Explained SS3”
“Types of Parallel Database Architectures”

Teacher Guide for Using This Lesson Plan

Before the lesson, ensure you have clear visual aids, such as charts or diagrams, illustrating the three main parallel database architectures. Begin by linking the new concepts to students’ existing knowledge of basic databases to make the transition smoother. Guide students through the definitions and explanations, ensuring they grasp the core differences between each architecture. Encourage active participation through questions and discussions. Allow sufficient time for students to copy the Board Summary notes after the main explanations and before the conclusion. Pay attention to common misconceptions about how data is shared or distributed in each architecture.