Parallel and Distributed Database Management Systems for SS 3

Class: SS 3
Term: First Term
Week: 6
Age: 16 years
Duration: 45 minutes
Subject: Data Processing
Curriculum Theme: Database Management Systems
Previous Lesson: Parallel and Distributed Databases
Topic: Parallel and Distributed Databases
Subject Matter: Distributed DBMS architecture: Storing data in a distributed; DBMS

Specific Objectives

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

Cognitive Domain

• Define a Distributed Database Management System (DDBMS).
• Identify the key components of a distributed DBMS architecture.
• Explain how data is stored in a distributed DBMS.
• State the importance of distributed and parallel DBMS architecture.

Affective Domain

• Appreciate the benefits of distributed database systems.
• Participate actively in discussions about distributed DBMS architecture.

Psychomotor Domain

• Draw a simple diagram illustrating distributed DBMS architecture.
• List examples of distributed DBMS architecture components.

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:

• Chart illustrating distributed DBMS architecture
• Whiteboard and markers
• Computer with projector (if available) to show examples of distributed systems

Rationale for the Lesson

This lesson provides students with a foundational understanding of distributed database systems, which are prevalent in modern computing environments. Understanding DDBMS architecture and data storage mechanisms is essential for students pursuing careers in data management, network administration, and software development, enabling them to design and manage robust data solutions.

Prerequisite/Previous Knowledge

Students should have a basic understanding of database concepts, database management systems (DBMS), and networking principles.

Lesson Content/Board Summary

Parallel and Distributed Databases

Distributed Database Management System (DDBMS)

A Distributed Database Management System (DDBMS) is a database system where data is stored across multiple physical locations, and processing is distributed among various interconnected computer systems. These systems work together to make the collection of data appear as a single, logical database to the user.

Importance of Distributed and Parallel DBMS

The importance of distributed and parallel DBMS includes:

1. Improved Performance: Data can be processed in parallel, leading to faster query execution.
2. Increased Reliability and Availability: If one site fails, other sites can continue to operate, ensuring data availability.
3. Scalability: Systems can be easily expanded by adding more nodes as data and user demands grow.
4. Data Locality: Data can be stored closer to where it is most frequently used, reducing network traffic and improving response times.
5. Cost-Effectiveness: Can use cheaper commodity hardware distributed across a network.

Distributed DBMS Architecture

Distributed DBMS architecture involves multiple computers (nodes) connected via a network, each managing a portion of the database. Key architectural components include:

1. Local DBMS: Each site in the distributed system has its own local DBMS that manages the data stored at that site.
2. Communication Network: This connects the different sites, allowing them to exchange data and control information.
3. Distributed Transaction Manager: Coordinates transactions that span multiple sites, ensuring atomicity, consistency, isolation, and durability (ACID properties).
4. Data Dictionary/Catalog: Stores metadata about the entire distributed database, including data fragmentation and replication information.
5. Query Processor: Optimises and executes queries across multiple sites.

Common distributed DBMS architectures include:

1. Client-Server Architecture: Clients send requests to servers that manage data. In a distributed setup, multiple servers might manage different parts of the database.
2. Peer-to-Peer Architecture: All nodes have equal capabilities and responsibilities, sharing data and processing tasks.
3. Homogeneous DDBMS: All sites use the same type of DBMS software.
4. Heterogeneous DDBMS: Different sites may use different types of DBMS software, requiring middleware for integration.

Storing Data in a Distributed DBMS

Data storage in a distributed DBMS typically involves two main strategies:

1. Fragmentation:

• Definition: Breaking down a global relation (table) into smaller pieces (fragments) and storing these fragments at different sites.
• Types:
  1. Horizontal Fragmentation: Dividing a table into subsets of rows. Each fragment contains a subset of tuples (rows) of the original table. For example, customer data for Lagos can be stored in Lagos, and for Abuja in Abuja.
  2. Vertical Fragmentation: Dividing a table into subsets of columns. Each fragment contains a subset of attributes (columns) of the original table, along with the primary key to link them. For example, customer personal details in one site, and order history in another.
  3. Mixed Fragmentation: A combination of horizontal and vertical fragmentation.

• Definition: Storing copies of data fragments at multiple sites.
• Benefits:
  1. Increased Availability: If one site with a data copy fails, another site with a copy can serve requests.
  2. Improved Performance: Queries can be directed to the nearest available copy, reducing network latency.
• Challenges:
  1. Consistency: Ensuring all copies of data remain identical and up-to-date after modifications.
  2. Storage Overhead: Requires more storage space for multiple copies.

Teaching Methods/Instructional Techniques

Discussion, Explanation, Question and Answer, Chart Presentation, 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 why a single, central database might have limitations for large organizations or global operations.

Pupils’ Activity: Students respond to questions about traditional databases and their limitations.

Learning Point: Limitations of central databases

Step 2: Introduction to Distributed DBMS

Time: 7 minutes

Teaching Skill: Explanation/Definition

Teacher’s Activity: The teacher introduces the concept of a Distributed Database Management System (DDBMS), explaining that data is spread across multiple locations but appears as one logical database. The teacher also states the importance of distributed and parallel DBMS.

Pupils’ Activity: Students listen attentively and ask clarifying questions about DDBMS.

Learning Point: DDBMS definition and importance

Step 3: Exploring DDBMS Architecture

Time: 8 minutes

Teaching Skill: Chart Presentation/Explanation

Teacher’s Activity: The teacher uses a chart to illustrate the components of a distributed DBMS architecture, explaining each part (e.g., local DBMS, network, transaction manager). The teacher lists examples of distributed DBMS architecture components.

Pupils’ Activity: Students observe the chart, listen to the explanation, and identify the components.

Learning Point: DDBMS architectural components

Step 4: Discussing DDBMS Architectures

Time: 6 minutes

Teaching Skill: Discussion/Elaboration

Teacher’s Activity: The teacher discusses different types of DDBMS architectures, such as client-server, peer-to-peer, homogeneous, and heterogeneous, providing simple examples for each.

Pupils’ Activity: Students participate in the discussion, comparing and contrasting the different architectures.

Learning Point: Types of DDBMS architectures

Step 5: Data Storage – Fragmentation

Time: 7 minutes

Teaching Skill: Explanation/Examples

Teacher’s Activity: The teacher explains the concept of data fragmentation (horizontal and vertical) as a method of storing data in a distributed DBMS, providing clear examples for each type.

Pupils’ Activity: Students listen, take notes, and ask questions to understand fragmentation.

Learning Point: Data fragmentation methods

Step 6: Data Storage – Replication

Time: 5 minutes

Teaching Skill: Explanation/Comparison

Teacher’s Activity: The teacher explains data replication, its benefits (availability, performance), and challenges (consistency). The teacher compares it with fragmentation.

Pupils’ Activity: Students understand replication, its pros and cons, and how it differs from fragmentation.

Learning Point: Data replication concepts

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 Distributed Database Management System?
2. List two components of DDBMS architecture.
3. Explain the difference between horizontal and vertical fragmentation.
4. State one importance of using a distributed DBMS.

Pupils’ Activity: Pupils answer orally and in writing.

Learning Point: DDBMS understanding check

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 Distributed DBMS architecture and data storage into their notebooks.

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

Learning Point: Recording lesson notes

Step 9: Conclusion

Time: 1 minute

Teaching Skill: Summarising

Teacher’s Activity: The teacher briefly reminds students that distributed databases are crucial for handling large amounts of data efficiently and reliably across various locations, making them vital in today’s interconnected world.

Pupils’ Activity: Students listen and prepare for the next lesson.

Learning Point: DDBMS importance reinforced

Continuous Assessment/Further Study

Type: Homework

Instruction: Answer the following questions in your notebook:

1. Draw a simple diagram showing a distributed database system with at least three sites.
2. Research and write a short paragraph on a real-world example of a distributed database system (e.g., used by a bank, an e-commerce company).
3. Discuss the advantages and disadvantages of data replication in a distributed DBMS.

Lesson Keywords

• DDBMS – Distributed Database Management System, a database system where data is stored across multiple physical locations.
• Fragmentation – The process of dividing a database table into smaller pieces (fragments) for distributed storage.
• Replication – Storing copies of data fragments at multiple sites in a distributed database.
• Homogeneous DDBMS – A distributed database system where all sites use the same type of DBMS software.
• Heterogeneous DDBMS – A distributed database system where different sites may use different types of DBMS software.

Differentiation

For weaker learners: Provide simplified diagrams and focus on the basic definitions of DDBMS, fragmentation, and replication. Offer more direct questions during the review. Allow them to work in pairs for the homework assignment.

For faster learners: Encourage them to research specific distributed database technologies (e.g., Apache Cassandra, Google Spanner) and discuss their unique architectural features. Challenge them to think about consistency models in replicated data.

Suggested Lesson Videos

For further understanding, search on YouTube for:
Distributed Database Management Systems architecture SS3

Teacher Guide for Using This Lesson Plan

Before the lesson, ensure you have a clear chart or diagram of distributed DBMS architecture ready. Prepare simple, relatable examples for fragmentation and replication to make the concepts concrete. Start by linking the topic to students’ existing knowledge of centralized databases and their limitations. During the lesson, encourage active participation through questions and discussions. Guide students through the architectural components and data storage methods step-by-step. Allow sufficient time for students to copy the Board Summary notes after the evaluation. For the homework, emphasize the importance of independent research and critical thinking.