Can You Write Down The Types Of Databases?

The databases may be of different types but there are two generic database architectures. These are:
(i) Centralized Databases (ii) Distributed Databases
Centralized Databases
A database who's all data is located at a single computer (or site) and multiple users can access that database is known as centralized database. A centralized database provides an efficient way to access and update data. These databases are usually used in computer network environments. The examples of centralized databases are:
(i) Personal computer databases
(ii) Client/Server databases,
(iii) Central computer databases

Distributed Databases.Many organizations/departments have sub-offices in different cities and countries. In such cases, the distributed databases are used instead of centralized databases. A distributed database is a single logical database, which is spread physically across computers in multiple locations (such as cities or countries). For example, some of the database tables may be maintained at one location with a DBMS, while another group of database tables may be maintained at another computer with a DBMS. Suppose multi-campus university database.

Any user at any campus can access data of his campus as well as of other campuses because of mutual communication between database servers at both campuses.
The distributed databases are further divided into two categories.
(i) Homogeneous databases.
(ii) Heterogeneous databases.

Add Comment

Report