Architecture in DBMS:-

➺ A Database architecture is a Representation of DBMS Design. it can be centralized, decentralized, or hierarchical design.

➺ Database architecture helps to design, create, implement and understand the parts of the database management system.

➺ A DBMS architecture divides the Database system into individual units that can be modified, altered, changed, or removed independently.

◆ Types of Dbms Architecture:-

➺ 1-Tier Architecture

➺ 2-Tier Architecture

➺ 3-Tier Architecture

➺It is the simplest architecture of the Database management system.
➺ In this client, server, and database all reside on the same system.
➺ Database is directly connected with the user. So the user can directly sit and uses a database.
➺ Any changes done here will directly be done on the database itself.
➺ 1-Tier Architecture used by programmer and designer. It is rarely used in the production industry.

➺ 2-tier architecture is also called Client-Server architecture.
➺ In this application Software and UI(user interface) runs on the client side and that application directly communicates with the server.
➺ 2-tier architecture client is directly connected with the database server.
➺ client requests service from the server and the server produces data for the client.
➺ Client/user Requests data in a High-level language and first Database server converts it into a low-level language after that performs an operation on the DB file or after that sends data to the client.
➺ 2-tier architecture is best when we have a limited number of the user.
➺ 2-tier architecture fails, when the number of user increase.
➺ It has less security.
➺ Ex.:- Board exam results website gets slow / fails when the number of users increases. they use 2 tier architecture.

➺ 3 -tier Architecutre is the most popular client-server architecture.
➺ It is an extension of 2-tier client-server architecture.
➺ Three Tier architecture consists of the business layer(application Software, Presentation layer(PC, Smartphone), and Database server.
➺ 3 -tier Architecture has a business layer/application layer between the client and server.
➺ In 3 tier architecture, client is not directly connected with Database(server).
➺ client request is processed by the business layer / Application layer and it converts into low-level language and then After that sends it to the server for processing.
➺ it has more security because the client is not directly connected to the server.
➺ it is mostly used in large web applications.
➺ ex:- Facebook, Google, Instagram etc.

You might like this :-

○History of computer
○Codd's 12 Rules
○ACID Properties in DBMS
○DBMS vs RDBMS