Database Architecture
Database management systems architecture will help us understand the
components of database system and the relation among them.The architecture
of DBMS depends on the computer system on which it runs.
The design of a DBMS depends on its architecture. The architecture of a DBMS can be
seen as either single tier or multi-tier.
Types of DBMS Architecture
There are three types of DBMS architecture:
1. Single tier architecture
2. Two tier architecture
3. Three tier architecture
Single tier architecture
In this type of architecture, the database is readily available on the client
machine; any request made by client doesn’t require a network connection to
perform the action on the database.
For example, If you want to fetch the records of employee from the database, the
database is available on your computer system, so the request to fetch employee
details will be done by your computer and the records will be fetched from the
database by your computer as well. This type of system is generally referred as
local database system.
Two tier architecture
In two-tier architecture, the Database
system is present at the server machine and the
DBMS application is present at the client
machine, these two machines are connected
with each other through a reliable network a
Whenever client machine makes a
request to access the database present at
server using a query language like sql, the
, server perform the request on the database and returns the result back to the
client. The application connection interface such as JDBC, ODBC are used for
the interaction between server and client.
Three tier architecture
In three-tier architecture, another layer is present between the client
machine and server machine. In this architecture,
the client application doesn’t communicate
directly with the database systems present at the
server machine, rather the client application
communicates with server application and the
server application internally communicates with
the database system present at the server.
End user has no idea about the existence
of the database beyond the application server.
The database also has no idea about any other
user beyond the application. The 3-Tier
architecture is used in case of large web
application.
DBMS database models
A Database model defines the logical design and structure of a database
and defines how data will be stored, accessed and updated in a database
management system.
1. Hierarchical Model
This database model organises data into a
tree-like-structure, with a single root, to which
all the other data is linked. The hierarchy starts
from the Root data, and expands like a tree,
adding child nodes to the parent nodes.In this
model, a child node will only have a single
parent node.This model efficiently describes
many real-world relationships.. The main
drawback of this model is that, it can have
only one to many relationships between
nodes.
Database management systems architecture will help us understand the
components of database system and the relation among them.The architecture
of DBMS depends on the computer system on which it runs.
The design of a DBMS depends on its architecture. The architecture of a DBMS can be
seen as either single tier or multi-tier.
Types of DBMS Architecture
There are three types of DBMS architecture:
1. Single tier architecture
2. Two tier architecture
3. Three tier architecture
Single tier architecture
In this type of architecture, the database is readily available on the client
machine; any request made by client doesn’t require a network connection to
perform the action on the database.
For example, If you want to fetch the records of employee from the database, the
database is available on your computer system, so the request to fetch employee
details will be done by your computer and the records will be fetched from the
database by your computer as well. This type of system is generally referred as
local database system.
Two tier architecture
In two-tier architecture, the Database
system is present at the server machine and the
DBMS application is present at the client
machine, these two machines are connected
with each other through a reliable network a
Whenever client machine makes a
request to access the database present at
server using a query language like sql, the
, server perform the request on the database and returns the result back to the
client. The application connection interface such as JDBC, ODBC are used for
the interaction between server and client.
Three tier architecture
In three-tier architecture, another layer is present between the client
machine and server machine. In this architecture,
the client application doesn’t communicate
directly with the database systems present at the
server machine, rather the client application
communicates with server application and the
server application internally communicates with
the database system present at the server.
End user has no idea about the existence
of the database beyond the application server.
The database also has no idea about any other
user beyond the application. The 3-Tier
architecture is used in case of large web
application.
DBMS database models
A Database model defines the logical design and structure of a database
and defines how data will be stored, accessed and updated in a database
management system.
1. Hierarchical Model
This database model organises data into a
tree-like-structure, with a single root, to which
all the other data is linked. The hierarchy starts
from the Root data, and expands like a tree,
adding child nodes to the parent nodes.In this
model, a child node will only have a single
parent node.This model efficiently describes
many real-world relationships.. The main
drawback of this model is that, it can have
only one to many relationships between
nodes.
