Function of Client and Server environment - Softkhazana

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.