In this tutorial, We will study the database management system (DBMS) architecture, types of DBMS architecture 1 tier architecture, 2 tier architecture, and 3 tier architecture. So let us start.
Database architecture is focused on the development, designing, maintenance, and implementation of computer programs that are used to store and organize information.
A database architect helps in the development and implementation of software to meet the user requirement. Database architecture uses languages to design a particular type of software for business organizations. The design of a DBMS highly depends upon its architecture. The DBMS can be distributed, centralized or decentralized depending upon its architecture.
1. In this, there is only one server and multiple clients are there.
2. Only the user interface will be there.
3. In this, we will use the file server rather than using the database server.
4. These are mainly used where there are less frequent changes in the data and there are no multiple users accessing the data.
5. Basically, a one-tier architecture helps in keeping all of the elements of an application, including the interface, middleware and back end data, at only one place.
For example - Let us say we want to fetch the records of employees from the database and the database is available on the computer system, so the request to fetch employee details will be done by the computer and data will be fetched from the database. This type of system is referred to as a local database system.
1. It is a client-server architecture. Here two layers will be there the client tier and the database tier.
2. There is direct communication, therefore, faster than 1 tier architecture.
3. In this, we use a database server.
4. In this, the database system and DBMS application are present at the server machine and the client machine respectively. The two machines are connected with each other via a reliable network.
5. All the clients will be communicating with the database server which is present in the organization.
6. Whenever the client machine makes a request to access the database located at the server using a query language like SQL, the server performs the request on the database and returns the result to the client.
The application connection interface like JDBC, ODBC are generally used for the interconnection between server and client.
7. There is no intermediate layer between the client and the server.
1. In this, there will be three layers: the client tier, business logic tier, and the database tier.
2. In this, the client application does not directly communicate with database systems present. But they communicate with server applications and the server application communicates internally with the database system.
3. This architecture separates ties depending upon the complexity of users and how users use the data present on the database.
4. It is a completely web-based application.
In this end users operate and have no idea about the existence of databases beyond this point.
It is also known as the application tier. In this, there is an abstract view of the database for the user. It is the middle layer.
In this database resides along with its query processing language.