Pr.Pg Next Pg

RDBMS – Relational Database Management System tutorials

The client/Server Database Model

 

 

  • RDBMS stands for Relational Database Management System

  • Technically, the term client/server refers to any two cooperating processes.

  • The client process requests a service from server process. The server process in turn handles the request from client and it responds it.

  • The client process and the server process may be on different computers or on same computer. It’s the cooperation between processes that is significant, not the physical location.

  • In contrast to desktop database, which make the clients do all the work, client/server database works differently.

  • Here database client prepares a SQL request (Just a small text message) and sends it to the database server. The Server in turn reads and processes the request.

  • Inside the server the security is checked, the indexes are searched, the data is retrieved or manipulated.

  • When server side code is executed, the final result is then sent back to client.

  • All the database work is preformed within the database server. If the client requests a dataset, the dataset is prepared within the server and a copy of data is sent to the client.

  • The actual data and indexes never leave the server.

  • So when client requests an INSERT, UPDATE or DELETE operation, the server receives the SQL request and processes request internally.

 

Following are some example of RDBMS – used by CLIENT/SERVER environment

  • MS-SQL SERVER from MICROSOFT CORPORATION

  • ORACLE from ORACLE CORPORATION

  • DB2 from IBM

  • SYBASE from SYBASE Inc.

  • INFORMIX from INFORMIX Software

 

 


Pr.Pg border                                              Next Pg