Database management systems can be classified based on several different criteria. These criteria are given below:
1.Based on data models (Data models):
2.Based on number of users:
Single-user systems:
Such types of systems support only one user at a time.
Multi-user systems:
Such types of systems support multiple users concurrently.
3.Based on purposes or use:
Transactional DBMS:
Decision Support DBMS:
Data warehouse:
4.Based on site locations:
1.Centralized database system (Centralized dbms architecture)
The following figure illustrates the centralized database system.
Description:
In a centralized database system, a database is kept at single physical location.
Also, a single processor is used to provede central control.
Different users can access this database from local machines or from remote machines.
Advantages:
Operations such as insert, update, delete, backup, query, recovery are easier to accomplish.
Disadvantages:
Problems such as system crash in central computer results in system failure, as no any user can access the database.
All terminals must have connection with the central computer, and this incurs cost in networking.
2.Parallel database system (Parallel architecture)
3.Distribute database system (Distribute architecture)
4.Client/Server database system (Client/Server dbms architecture)
