Tutorial Definition Of The Client/server Architecture In Database

Swati Mishra

Content Writer
Server is to manage and stored data where as Client is to transfer the user information to the server and client also interact with user.

In the Client/Server Architecture, the functionality of the application is split between two processes.


  • The Client process: All the data input and the user interface is handling by the Client process.

  • The Server process: All the validation on the data is perform by the Server process.


The Client and the Server process can be on separate machine on the network. User will give information or data to the computer. Such as the Client will provide the user interface for getting input data from the user and the client pass the data to the Server process.


The server process implements the application logic, on the business rule it valid the input data.
It passes an error message to the client if the data is invalid or wrong otherwise data is updated in database.




Client /Server provide the benefits these are describe below:


  • Data sharing: Data kept aside from the client side and stored at a specific location where data will access by the user.

  • Reduces duplication: There is no duplication of data so no inconsistency in data stored. Date is stored centrally and the maintenance of data is easy.
 

Oldwriter

Content Writer
Hello @Swati Mishra, thanks for your informative article.

The other side of the coin regarding the client/server architecture being embedding database processing right into the program at hand, which is a valid choice (and a more proper solution) in many cases.

For instance, the popular web browser Google Chrome uses the SQLite embedded database library, this ensures the database file can be written and read under multiple platforms homogeneously. SQLite is available in the set of operating systems Google Chrome targets and doesn't need a separate setup/installation for the server, which is a big plus towards keeping things compact as you want the user to deal with only one application.

Another good embedded database, which can double as client/server if the case demands it, is the Java-based H2 database engine. You get to choose whether you want your database processing to be embedded or not and enjoy the big benefit of targeting all of the platforms java reaches.
 
Last edited:

Manish Mishra

Content Writer
Nice to see people are covering this section of the forum as well.
Client/server model specifically like sender and receiver. The one who supplies is called client and other that receives is called server.
There is lot more approaches in the database and i am glad OP has explained it better.
 

Swati Mishra

Content Writer
Server is to manage and stored data where as Client is to transfer the user information to the server and client also interact with user.

In the Client/Server Architecture, the functionality of the application is split between two processes.

  • The Client process: All the data input and the user interface is handling by the Client process.

  • The Server process: All the validation on the data is perform by the Server process.



The Client and the Server process can be on separate machine on the network. User will give information or data to the computer. Such as the Client will provide the user interface for getting input data from the user and the client pass the data to the Server process.

The server process implements the application logic, on the business rule it valid the input data.
It passes an error message to the client if the data is invalid or wrong otherwise data is updated in database.




Client /Server provide the benefits these are describe below:


  • Data sharing: Data kept aside from the client side and stored at a specific location where data will access by the user.
  • Reduces duplication: There is no duplication of data so no inconsistency in data stored. Date is stored centrally and the maintenance of data is easy.



Role of Client/Server in database


Client/server role in database is to create co-operation programming in the given application. Server provides function to one or more clients depend upon it needs. Server is described by the service it is offering.
E.g. Web server, web page meant to serve the computing files.

A computer can be a server and also can be client or sometimes both depending on the nature of the application. Serving different data to different clients makes the single computer as a web server and the file server. Client also can communicate with the server within the same computer. Some tasks like synchronizing data or processing files always need to be done by server to server this is also known as server to server communication.




Client/server communication


There is pattern called request-response messaging that is used by clients and server to exchange messages between these two. In order to make communication working computers should have common language and they need to follow the rules that are known to both server and client. A communication protocol needed to make communicate for the rules and languages. Application layer of database is responsible to create the communication between the client and server.

A server can have many requests at a time since the computers are not that fast to perform the response to each of the request. It uses the priority based system to give responses to each in the queue. This is also known as scheduling system in database that makes the communication more effective. The server software maximizes the uptime and limits the server resources.

Generally, this is a service often understands as abstraction and client has no responsibility how the server works. The client only handles responses with the help of application protocol.
 
Top