Types of Database Management System
Database management systems can be divided into various categories, namely, client server databases, distributed databases, hypermedia and web databases. They are described below:
Client Server Database: In the client server network system, the server and the work station are both processed, that is, both the server and the workstation can work. As a result, certain tasks can be outsourced to servers and workstations as needed. Workstations can use the server's resources and the server can assist the workstation in processing tasks. Client server database is established based on this concept.
The client sends a request to the server to obtain a service; The server provides data or services according to the client's request and other rules. The operation of client server database can be divided into two, namely—
(1) Front-end
(ii) Back End
The front end of the database system consists of several tools such as forms, reports, graphical user interface facilities etc. All the responsibilities performed by the back end are query editing optimization, concurrency control, recovery etc.
Distributed Database: In a centralized database system, the DBMS and the data are located at a specific address and the control and processing of the data is limited to that address. It is also called centralized database or centralized database.
A distributed database is a network of multiple workstations or computer systems connected to a centrally controlled server. In this method, each workstation is independently responsible for database creation, modification, editing, etc. And the central database kept on the server is changed or updated according to the latest state of the database of the workstations. The central database of the server can change or modify the data text, data description language, etc. of the database of the workstations. Thus, in the distributed database system, the latest information is 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 is done. Client server approach is preferred for distributed database management.
Components of distributed database--
(i) Network Connection Manager
(ii) Transaction Manager
(iii) Query Processor
(iv) Recovery Manager
(v) System Catalog.
Advantages of distributed database
Distributed databases have several advantages, which are included below
(i) Improvement of Credibility
(ii) Greater data availability
(iii) Low cost communication
(v) Local Autonomy
(v) Increased efficiency
(vi) Reduction in time of effectiveness.
Disadvantages of distributed database
Distributed database has many advantages but it also has few disadvantages, which are included
(i) Safety Issues
(ii) Complexity in management and control
(iii) Quality control problem.
Hypermedia Database
Websites store text, audio, video, and graphics in the form of interrelated pages using hypermedia databases. Hypermedia database information management storage is stored in chunks on different interrelated nodes. Any program that can reside or execute on each node. Here the correlation between different records is not organized as in traditional database. Hypermedia database users can access desired information on various topics displayed on web pages at the click of a button.
Comments
Post a Comment