DEV Community πŸ‘©β€πŸ’»πŸ‘¨β€πŸ’»

DEV Community πŸ‘©β€πŸ’»πŸ‘¨β€πŸ’» is a community of 970,177 amazing developers

We're a place where coders share, stay up-to-date and grow their careers.

Create account Log in
Cover image for DBMS 3-tier architecture.βœ‹βœ‹βœ‹βœ‹
stalin s
stalin s

Posted on

DBMS 3-tier architecture.βœ‹βœ‹βœ‹βœ‹

DBMS 3-tier architecture divides the complete system into three inter-related but independent modules as shown in the above image(cover image).

Presentation layer / User layer✨✨✨: This tier is presented before the user who knows nothing regarding the other existing complex databases underneath. This tier can provide multiple views of the databases, generated by the application residing in the application tier.

Application tier✨✨: This is the middle-lined tier between the database and the presentation tier and acts as a connection between the end-user and the database. This tier holds the programs and the application server along with the programs that could access the database. This is the last layer that the users are made aware of . It provides a complete abstraction to the database layer.

Database tier✨: This tier holds the primary database along with all the data and the query language for processing. The relations of data with their constraints are also defined at this level.

Advantages:

βœ‹ Enhanced scalability.
βœ‹ data integrity.
βœ‹ security.

Disadvantages:
βœ‹ complexity of implementation and communication between client and server.

Top comments (0)

🌚 Friends don't let friends browse without dark mode.

Just kidding, it's a personal preference. But you can change your theme, font, etc. in your settings.

The more you know. 🌈