In client and server database systems,
the server contains the whole DBMS and controls all of DBMS at a center
point, while all the users send and receive all information using
database server via the client computer. The functions of database
server is to receives the queries from the user and answers them using
centralized point. Here the main functions of client and server are:
Functions of the Client
A Client is used as front-end to
communicate with the database server. It plays very vital role in the
client and server environment, because maximum interaction of client
continue with the server machines to save and extract information from
database. There are many functions performs by client end:
-
It presents and manages the
user-interface through application program and data manipulation
functions.
-
Database client sends the queries to
the database server that is processed by the server.
-
It interprets the results send by
server and presents the results to user.
-
It also executes the local
application.
-
Client has the ability to process
further the queries results received from server.
-
It can also send and receive messages
to and from different clients in the network environment.
-
It enforces the constraints applied
in the application program.
Functions of the Database Server
The database server contains the DBMS
software and database file and allows the clients to add information in
cartelized database and extract information from the database. The main
functions of database server are:
-
It manages the database stored inside
it.
-
It receives queries or requests from
client, interprets and executes the queries and sends the results of
queries to the relevant clients.
-
It manages the database recovery,
security and backup services of the DBMS.
-
The entire database constrains
that are specified inside the DBMS enforced by the server machine.
-
Database access, users management,
and all control functions are handles by database server.