Centralised and Client server DBMS Architecture

Duration: 6 min

This video lesson is available to enrolled students.

Return to /learn/EMRS-CS-TIER-2/database-management/basics-of-dbms/data-model-architecture-components/asset-centralised-and-client-server-dbms-architecture after enrolling

Inside: a video lesson and guided study material.

Module outline

  1. Computer Systems and Organisation: Basics of COA, Cache Memory Organization, Introduction to OS, Digital Systems & Boolean Basics, Logic Gates & Hardware, Number System, Number Representation
  2. Computer Networks: Introduction to CN, Data Communication, Net Layer: IP Addressing, Application Layer, Hardware basics
  3. Database Management: Basics of DBMS, Relational Model & Functional Dependencies, Keys & Integrity Constraints, SQL
  4. Introduction to Python: Introduction to Python, Tokens, Variables, Data Types, I/O, Operators & Expressions, Control Flow & Looping, Collections & Strings, Functions & Modules, File Handling & Data Analysis
  5. Emerging Trends: Emerging Trends and AI, Sets, Relations, Functions and Discrete Mathematics / समुच्चय, संबंध, फलन और विविक्त गणित, Trade, Marketing and Consumer Protection / व्यापार, विपणन एवं उपभोक्ता संरक्षण, Internet of Things, Cloud Computing, Solid State Physics and Electronics / ठोस अवस्था भौतिकी और इलेक्ट्रॉनिकी, Network Access Technologies
  6. Artificial Intelligence: Simple and Compound Interest / साधारण और चक्रवृद्धि ब्याज
  7. Digital Society & Cyber Law: Society, Law & Ethics, Cyber Safety and Security, Teaching Aids and Educational Technology / शिक्षण सहायक सामग्री एवं शैक्षिक तकनीकी, Computer Software, डिजिटल समाज, नैतिकता और साइबर कानून / Digital Society, Ethics and Cyber Law, Digital India and Online Services, Culture, Socialisation and Social Control / संस्कृति, समाजीकरण और सामाजिक नियंत्रण, Web Publishing & Hosting
  8. Application Software: MS Office Applications, Operating System, Terms & Abbreviations, Computer Hardware, Language Design, C Fundamentals
  9. EMRS Tier 2 Live Classes Notes: EMRS TGT/PGT Live Class, Subjective Notes
  10. Full Mock Test:
AI summary & chapters

AI Summary

An AI-generated summary of this video lecture.

The video presents a lecture on database management system (DBMS) architectures, focusing on centralized and client-server models. It begins by defining a centralized DBMS as a single system that integrates all components—DBMS software, hardware, application programs, and user interface processing software—into one location. The instructor explains that users can connect remotely via a terminal, but all processing occurs at the central site. This concept is visually reinforced with a hand-drawn diagram showing multiple terminals connected to a central processing unit labeled 'centralized'. The lecture then transitions to a more detailed, structured diagram titled 'A Physical Centralized Architecture' (Figure 2.4). This diagram illustrates the layered architecture, showing how terminals and monitors connect to a network, which in turn connects to the software layer (including DBMS, compilers, and application programs) running on an operating system. The operating system manages the hardware/firmware layer, which includes the CPU, memory, disk, and I/O devices. The instructor uses red annotations to highlight key components like 'Software', 'Operating System', and 'Hardware/Firmware', and to draw connections between the layers, emphasizing the flow of data and control in a physical centralized system.

Chapters

  1. 0:00 – 2:00 00:00-02:00

    The video opens with a slide titled 'Centralized and Client-Server DBMS Architectures'. The instructor defines a 'Centralized DBMS' as a system that combines all components—DBMS software, hardware, application programs, and user interface processing software—into a single system. The key point is that while users can connect through a remote terminal, all processing is done at the centralized site. The instructor begins to draw a simple diagram on the slide, sketching several terminal boxes at the bottom and a central box at the top, which will represent the centralized system.

  2. 2:00 – 5:00 02:00-05:00

    The instructor continues to build the diagram for the centralized architecture. He draws lines from the multiple terminal boxes to a central, larger box, which he labels 'centralized'. He then adds a downward arrow from the top of the central box, indicating that processing occurs there. The diagram visually represents the concept that multiple users (terminals) access a single, central processing unit. The instructor's hand is visible, actively drawing and annotating the diagram to illustrate the flow of interaction in a centralized system.

  3. 5:00 – 6:05 05:00-06:05

    The slide changes to a new diagram titled 'A Physical Centralized Architecture' (Figure 2.4). This detailed diagram shows the layered structure of a centralized system. The instructor uses red annotations to highlight the 'Software' layer (containing DBMS, compilers, application programs), the 'Operating System' layer, and the 'Hardware/Firmware' layer (including CPU, memory, disk, and I/O devices). He draws arrows to show the flow of data and control between these layers, emphasizing the physical connections and the hierarchical organization of the system components.

The lecture progresses from a conceptual definition of a centralized DBMS to a detailed physical architecture. It starts by explaining the core idea that all processing is centralized, even with remote users. This is then illustrated with a simple, hand-drawn diagram showing terminals connecting to a central unit. The lesson culminates in a more formal, structured diagram that breaks down the system into distinct layers—software, operating system, and hardware—showing how they interact to form a complete, physical centralized architecture. The progression demonstrates how a high-level concept is translated into a tangible, layered system design.

Loading lesson…