DBMS Concepts

DBMS Tutorial Components of DBMS. Applications of DBMS The difference between file system and DBMS. Types of DBMS DBMS Architecture DBMS Schema Three Schema Architecture. DBMS Languages.

DBMS ER Model

ER model: Entity Relationship Diagram (ERD) Components of ER Model. DBMS Generalization, Specialization and Aggregation.

DBMS Relational Model

Codd’s rule of DBMS Relational DBMS concepts Relational Integrity Constraints DBMS keys Convert ER model into Relational model Difference between DBMS and RDBMS Relational Algebra DBMS Joins

DBMS Normalization

Functional Dependency Inference Rules Multivalued Dependency Normalization in DBMS: 1NF, 2NF, 3NF, BCNF and 4NF

DBMS Transaction

What is Transaction? States of transaction ACID Properties in DBMS Concurrent execution and its problems DBMS schedule DBMS Serializability Conflict Serializability View Serializability Deadlock in DBMS Concurrency control Protocols

Difference

Difference between DFD and ERD

Misc

Advantages of DBMS Disadvantages of DBMS Data Models in DBMS Relational Algebra in DBMS Cardinality in DBMS Entity in DBMS Attributes in DBMS Data Independence in DBMS Primary Key in DBMS Foreign Key in DBMS Candidate Key in DBMS Super Key in DBMS Aggregation in DBMS Hashing in DBMS Generalization in DBMS Specialization in DBMS View in DBMS File Organization in DBMS What Is A Cloud Database What Is A Database Levels Of Locking In DBMS What is RDBMS Fragmentation in Distributed DBMS What is Advanced Database Management System Data Abstraction in DBMS Checkpoint In DBMS B Tree in DBMS BCNF in DBMS Advantages of Threaded Binary Tree in DBMS Advantages of Database Management System in DBMS Enforcing Integrity Constraints in DBMS B-Tree Insertion in DBMS B+ Tree in DBMS Advantages of B-Tree in DBMS Types of Data Abstraction in DBMS Levels of Abstraction in DBMS 3- Tier Architecture in DBMS Anomalies in Database Management System Atomicity in Database Management System Characteristics of DBMS DBMS Examples Difference between Relational and Non-Relational Databases Domain Constraints in DBMS Entity and Entity set in DBMS ER Diagram for Banking System in DBMS ER Diagram for Company Database in DBMS ER Diagram for School Management System in DBMS ER Diagram for Student Management System in DBMS ER Diagram for University Database in DBMS ER Diagram of Company Database in DBMS Er Diagram Symbols and Notations in DBMS How to draw ER-Diagram in DBMS Integrity Constraints in DBMS Red-Black Tree Deletion in DBMS Red-Black Tree Properties in DBMS Red-Black Tree Visualization in DBMS Redundancy in Database Management System Secondary Key in DBMS Structure of DBMS 2-Tier Architecture in DBMS Advantages and Disadvantages of Binary Search Tree Closure of Functional Dependency in DBMS Consistency in Database Management System Durability in Database Management System ER Diagram for Bank Management System in DBMS ER Diagram for College Management System in DBMS ER Diagram for Hotel Management System in DBMS ER Diagram for Online Shopping ER Diagram for Railway Reservation System ER Diagram for Student Management System in DBMS Isolation in DBMS Lossless Join and Dependency Preserving Decomposition in DBMS Non-Key Attributes in DBMS Data Security Requirements in DBMS DBMS functions and Components What is Homogeneous Database? DBMS Functions and Components Advantages and Disadvantages of Distributed Database Relational Database Schema in DBMS Relational Schema Transaction Processing in DBMS Discriminator in DBMS

DBMS Architecture
2019-07-30 12:33:17

DBMS Architecture

Architecture of Database Management System

DBMS architecture helps in development, implementation, design, and maintenance of a database that store and organize information for agencies, businesses, and institutions. It is the base of any database management system, which allows it to perform the functions effectively and efficiently. The whole concept of DBMS depends upon its architecture. It can be designed as centralized, decentralized, or hierarchical.
The database management system architecture can be seen as either a single-tier or multi-tier, but logically, it can be of two types: 2-tier architecture and 3- tier architecture.

Architecture of Database Management System

1-tier Architecture

In 1-tier architecture, the database is directly available to the DBMS user for executing the SQL queries and storing data in it. Any changes or updates that are done here will be reflected directly to the database in the database management system.
Generally, 1-tier architecture is used for the development of applications where a programmer or developer directly communicates with the database for a quick response.

tier Architecture

2-tier Architecture

The 2-tier Architecture of DBMS is based on a client-server machine. In this type of architecture, applications on the client-side can interact directly with the database at the server-side. For this interaction between client and the server, application programming interface (API) like Open Database Connectivity (ODBC) and Java Database Connectivity (JDBC).
This architecture gives poor performance when there are a large number of users at the client machine to access the database.

Examples of 2-tier architecture are Oracle, Sybase, Microsoft SQL Server, etc.

2-tier Architecture

3-tier Architecture

The DBMS 3-tier architecture consists of another layer between the client and the server. In this architecture, the client cannot directly interact with the server. Its features, such as data backup, recovery, security, and concurrency control make it the most commonly used architecture for designing the database management system.
The 3-tier architecture consists of the following layers:

  • Presentation layer: This layer is also known as the client layer. It is the front end layer in the 3-tier architecture and consists of a user interface. The main purpose of this layer is to communicate with the application layer.
  • Application layer: This layer is also known as the business logic layer. It acts as a middle layer between the client and the database server for exchange of partially processed data.
  • Database layer: The data or information is stored in this layer. This layer contains a method to connect with the database and to perform operations such as insert, update, and delete.
3-tier Architecture