Architecture of DBMS : 3 Tier Architecture

 Application architecture of DBMS.

Basically, there are two types of architecture of DBMS:

1. Two tier architecture 
2. Three tier architecture.

Two tier architecture-

The application is partitioned into a component that resides at the client machine, Which invokes database system functionality at the server machine through query language statements. 

Application program interfaces standards like ODBC (Open database connectivity) and JDBC (Java database connectivity) are used for interaction between the client and the server. 

Three tier architecture-

The client machine acts as a merely a front end does not contain any direct database calls. Instead, the client end communicates with an application server, usually through a form interface. 

The application server in turn communicates with the database system to access data. Three tier applications are more appropriate for large applications, and for applications that run on the world wide web. 

                             

Conclusion-

These were some of the point discussed in the post- Architecture of DBMS

There is more coming with the next post keep reading...