DATABASE ARCHITECTURE IN DBMS

Database architecture is logically divided into two types.
  • 2 tier client- server architecture
  • 3 tier client- server architecture

Two-tier Architecture

-It is like a client server architecture.
-Direct communication takes place between client and server.
-No intermediate between client and server.

-Advantages:
   -Easy understand, maintain and modify.
   -Faster Communication.

-Disadvantages:
   -Performance decreases when number of users increases.
   -It is not cost effective.

Three-tier Architecture

-It has three layers (tiers) which are:
   -Client Layer: It is the interface between the user and the system. It contains GUI part of the system.
   -Middle Layer: It contains most of the business logic and communicates between the client layer and database layer.
   -Database Layer: It manages the database.

-Used in web based application.

-Advantages:
   -Easy to maintain and modify without affecting other modules.
   -Improved Security as client can not access the database easily. 
   -Improved performance.
   -Fast Communication.
   -Improve Data Integrity.

Related Post

  • DATABASE USERS IN DBMS DATABASE USERS Database users are the persons who interact with the database and take the benefits of database. The ...
  • DBMS-TRANSACTION MANAGEMENT INTRODUCTION A transaction is a collection of logical operations which occurs in a database.It is executed as ...
  • DATA INDEPENDENCE IN DBMS Data Independence is the capacity to modify a scheme definition in one level without affecting a scheme definiti ...
  • DATA ABSTRACTION IN DBMS Data abstraction is a process of hiding the implement details (such as how the data are stored and maintained) and re ...
  • Database Schema and Instance DATABASE SCHEMA The Database Schema is the description of the organization or structure of a database. It is specif ...
Previous
Next Post »