GOVT. E. RAGHVENDRA RAO P.G.
SCIENCE COLLEGE
BILASPUR (C.G)
DEPARTMENT OF COMPUTER
APPLICATION
SUBJECT :- Database Design and
RDBMS
GUIDED BY :- TOPIC :- Database architecture SUBMITTED BY :-
Mr . Vivek Tiwari Roll no. :- 21166 Roshan Kashyap
CONTENT
◇ DBMS ARCHITECTURE
◇ TYPES OF DBMS ARCHITECTURE
● 1 TIER ARCHITECTURE
● 2 TIER ARCHITECTURE
● 3 TIER ARCHITECTURE
◇ REFERENCE
DATABASE ARCHITECTURE
●The DBMS design depends upon its architecture
●DBMS architecture depends upon how users are connected to the database to get their request done.
●It is a client server architecture.
●Client – Client is a machine or computer on which user works.
●Server – It serves the client according to their request.
TYPES OF DBMS ARCHITECTURE -
The Architecture of DBMS can be seen as either single tier or multiple tiers.
1-tier Architecture
2-tier Architecture
• 3-tier Architecture
1-TIER ARCHITECTURE-
In this architecture, the database is directly available to the user. It means
the user can directly sit on the DBMS and uses it.
Any changes done here will directly be done on the database itself. It
doesn’t provide a handy tool for end users.
• The 1-Tier architecture is used for development of the local application,
where programmers can directly communicate with the database for
the quick response.
2-TIER ARCHITECTURE
The 2-Tier architecture is same as basic client-server. In the two-tier architecture, applications on the client
end can directly communicate with the database at the server side. For this interaction, API’s like: ODBC,
JDBC are used.
The user interfaces and application programs are run on the client-side.
The server side is responsible to provide the functionalities like: query processing and transaction
management.
• To communicate with the DBMS, client-side application establishes a connection with the server side.
3-TIER ARCHITECTURE
The 3-Tier architecture contains another layer between the client and server. In this architecture, client
can’t directly communicate with the server.
The application on the client-end interacts with an application server which further communicates with the
database system.
End user has no idea about the existence of the database beyond the application server. The database also
has no idea about any other user beyond the application.
• The 3-Tier architecture is used in case of large web application.
REFERENCE
● FUNDAMENTALS OF DATABASE SYSTEMS BOOK BY RAMEZ ELMASRI
● WWW.JAVATPOINT.COM
● WWW.GEEKSFORGEEKS.COM
● WWW.SLIDESHARE.COM
THANK YOU
