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.
-Improved Security as client can not access the database easily.
-Improved performance.
-Fast Communication.
-Improve Data Integrity.
