What are the advantages and disadvantages of client and distributed databases?

Client Server & Distributed Database

Client Server: The current era is the era of information technology. And in this era everything is normal to be covered by computer network. Computer networks can be of different types. PC based network based on client server software is called client server. Client server network is the most accepted and trusted network. Client-server databases are used in cases where multiple users need to work at the same time or at different times through the same database connection. In this system there is a central computer, called the server computer and the computer/terminal connected to it is called the client. The main database is permanently stored on the server and remote users can access the server computer's database by connecting to the client, server computer. The client can share all the resources of the server. Again, the server computer can also assist the client computer if necessary.

The operation of client server database can be divided into two parts namely-

(i) Front-End

(ii) Back End.

The server is called the back end of the database. A database administrator usually works in the back end. Structural changes in the database, determining the number of users, etc. are done in the back end. (Terminal) are called the front end of the database. The database can be accessed from the front end, but no changes can be made.

Let's say, the database information of an educational institution is stored on a server computer. Computer for examination department is client-1 and computer for account department is client-ii. In this case, client-1 copies and uses necessary data related to examination from server and client-2 copies and uses accounting database from server.

Advantages of Client Server--

The client server network can be used alone. Decision making, analysis, etc. programs can be done with the help of client server software, due to which the use of client server in various types of accounting packages is increasing rapidly. Pay roll, budgeting, customer service etc. program management and control can be done efficiently with the help of client server.

Distributed Database --

A server controlled network database is called a distributed database. Client-server approach is preferred in distributed database management. In this way, each workstation can create, modify, edit, etc. databases individually, and the central database changes according to the latest status of the workstations' databases. The central database on the server can also change the database data reading, data description language, etc. of the workstations. In this way, in the distributed database system, the latest information can be collected from the database of the workstations through the central database of the server and the management and control of the databases of the workstations can be done.

The biggest advantage of distributed database is that it looks like physically separate database. But logically it is a unified aggregate state, which can be used by all users in the network. The database that a user directly accesses from here is called a local database. If the user accesses a database other than the local database, it is called a remote database. When a local database receives data from a remote database, the local database is called a client and the remote database is called a server.

Distributed Database: Distributed database management for organizations such as government or private large organizations, banks, insurance, commercial organizations, industries, etc., who need to exchange information with branch offices or centers located in different places at all times. method is required.