Application Architecture in DBMS
Database applications are usually divided into two or three parts. In a two – tier architecture , the client machine uses query language statement and invokes database system functionally at the server machine. For interaction between the client and the server, application program interface like JDBC and ODBC are used. In a three – tier architecture , the client machine acts as a front end and do not directly call database. Instead, it communicates through forms interface with an application server, and the application server communicates with the database to access data. Figure – 1: Two – tier and three – tier architecture