Explains the client server architecture /three tier architecture of DBMS in details

Client server architecture (explains the client server architecture of DBMS/explains three tier architecture of DBMS): -

Client server architecture is an architectural deployment style that describes separation of functionality into layers with each segment being tier that can be located on a physically separate computer. A client server architecture separate its tier from each other based on the complexity of user and how they used the data present in the database. It is the most widely used architecture to design a DBMS.

A.      Database tier: - At this tier database resides along with its query processing languages. We also have the relation that define the data and their constrains at this level.

     B.    Application (middle) tier: - At this tier reside the application server and program that access database. For a user this application tier presents and abstracted view of database. Hence application tier/layer sits in the middle and acts as mediator between the end user and database.

      C.    Presentations (user) tier: - End users operate on this tier and they know nothing about any existence of database beyond this layer. At this layer multiple views of the database can be provided by application. All views are generated by application that resides in application tier.