DBMS Architecture
The architecture of the DBMS influences its design. Numerous PCs, web servers, database servers, and other network-connected components are handled by the standard client/server architecture.Numerous PCs and a workstation connected by a network make up the client/server architecture.
The architecture of DBMSs is dependent on how users connect to the database in order to complete their requests.
Types Of DBMS Architecture
Depending on the needs of the application, we employ different kinds of DBMS architecture. Here, various DBMS architecture types are covered.- Architecture in One-Tier
- Architecture in Two Tiers
- Architecture in Three Tiers
1-Tier Architecture
In this architecture, the user can access the database directly. It indicates that the user can use the DBMS directly while sitting on it.Any changes you make here will be immediately reflected in the database. It doesn't give customers a useful tool.
When creating a local application, programmers can interact directly with the database using the 1-Tier architecture, enabling prompt responses.
Advantages Of 1-Tier Architecture
Basic Architectural Design: Because it only requires one machine to maintain, the 1-Tier Architecture is the easiest to set up.Cost-Effective: The implementation of 1-Tier Architecture is inexpensive because it doesn't require any additional hardware.
Simple to Put into Practice: 1. Tier Architecture is mostly utilized in small projects due to its ease of deployment.
Example Of 1-Tier Architecture
We set up our database and SQL server on our local system so that we could learn the Structure Query Language (SQL). With the help of this SQL server, we can perform some tasks and communicate with the relational database directly without a network connection. A single-tier database management system is demonstrated by the entire setup used to learn SQL queries.2-Tier Architecture
Basic client-server design is the same as the 2-tier architecture. Applications running on client computers can interact directly with the server-side database in a two-tier architecture. APIs like ODBC and JDBC are used for this kind of interaction.
Client-side software is used to run application programs and user interfaces.
Functionalities such as transaction management and query processing are provided by the server side.
The client-side application creates a connection with the server side in order to communicate with the DBMS.
Advantages of 2-Tier Architecture
Easy to Access: The database is easily accessed thanks to the 2-Tier Architecture, allowing for quick retrieval.Scalable: By adding clients or updating hardware, we can quickly expand the database.
Low Price: Compared to 3-tier and multi-tier architecture, 2-tier architecture is less expensive.
Simple Deployment: Compared to 3-Tier architecture, 2-Tier architecture is simpler to implement.
Easy: With just two components, 2-Tier Architecture is simple and easy to understand.
Example Of 2-Tier Architecture
Imagine that you went to a bank to take out some cash. The banker will use his credentials (an API call) to access the server-side database and verify whether there is sufficient balance after entering the withdrawal amount and account information on the withdrawal slip. An illustration of a two-tier database management system architecture is this client-server setup.3-Tier Architecture
An additional layer sits between the client and server in the three-tier architecture. There is no direct communication between the client and the server in this architecture.The database system is further communicated with by the application server, which is in communication with the client-end application.
The end user is not aware that the database exists outside of the application server.. Furthermore, other than the application, the database knows nothing about any other user.
When a large web application is involved, the 3-Tier architecture is used.
Advantages Of 3-Tier Architecture
More scalability: The dispersed deployment of application servers contributes to more scalability. There's no need for the client and server to establish separate connections now.Maintaining Data Integrity is the responsibility of the 3-Tier Architecture. The existence of an intermediary layer between the client and the server allows for the prevention or elimination of data corruption.
Three-Tier Architecture Enhances Security. Unauthorized data access is decreased by this kind of model, which forbids direct client-server communication.
