Types of database management system (Types of dbms)

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:

Centralized DBMS (CDBMS):

Parallel DBMS:

Distribute DBMS:

Client/Server DBMS:


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)


READ MORE

I am blog master. My website name is World Teaches. My website niche is education related information. https://www.worldteachesus.com/
Follow
Cards you may also be interested in
Structural BIM Modeling Services - ASC Technology Solutions.
asctechno
1
0
0
WHO’s International Clinical Trials Registry Platform (ICTRP)
noahbenzuk90
2
0
0
WhatsApp vs GroupMe | Which one is the Best?
shahzadiNoor
4
1
1
Impact of COVID-19 on Telecoms Industry
eblogging
1
0
0
Address verification - Melissa Singapore Melissa’s Global Address Verification service verifies addresses for 240+ countries and territories at the point of entry and in batch to ensure only valid billing, shipping, and contact addresses are entered.
melissasg
1
0
0
Essential tools in data analytics- Tableau
analyticscourse
1
0
0
Email Marketing: A New Form of Digital Marketing
vaibhavaryson
3
0
0
Chụp hình sống ảo ở đâu đẹp tại TPHCM?
meobalovn
3
0
0
How does a TCP 3-Way Handshake work?
sangwan77
1
1
0
MEP BIM Modeling Services - BIM Outsourcing Services
asctechno
1
0
0
Open MSG file on Mac Outlook
vaibhavaryson
2
0
4
Best CCNA Course In Mumbai
vedasyspro
1
0
0
Coding: How To Earn Money While You Pursue Coding?
vaibhavaryson
3
0
0
6 Lí do Bạn nên sử dụng Camera IP thay cho Camera Analog truyền thống
Vivaio
1
0
0
Latest Lead4Pass Fundamentals DP-900 exam practice questions and DP-900 exam dumps
lead4pass6666
1
1
0
A talented matlab homework helper
ethansmith62060
1
0
0
Advantages of Integrating Cryptocurrency with MLM
SajinRajan
1
0
0
Latest Lead4Pass CCNP 300-820 exam practice questions and 300-820 exam dumps
lead4pass6666
1
0
0
Architectural BIM Services - BIM Modeling Services
asctechno
1
0
0
Cisco Users Email List | Cisco Customers Mailing Database | Cisco Leads
b2bdatabase
1
0
0
4.7 Star App Store Review!
Cpl.dev***uke
The Communities are great you rarely see anyone get in to an argument :)
king***ing
Love Love LOVE
Download

Select Collections