Database Management Systems
Last updated
Was this helpful?
Last updated
Was this helpful?
The main Four Types of Database Management Systems are:
Hierarchical database
Network database
Relational database
Object-Oriented database
In a Hierarchical database model, data is arranged in a hierarchical or tree-like structure, and stored either top-down or bottom-up format. The organization of data is based on a parent-child relationship, where parents can have multiple children, while children can have only one parent.
RDBMS is the basis for Structured Query Language, and for all modern database systems like MS SQL Server, IBM DB2, Oracle, MySQL, Postgres, etc.
A popular alternative to relational databases, take a variety of forms and allow you to store and manipulate large amounts of unstructured and semi-structured data. Examples include key-value stores, document stores and graph databases.
Types of NoSQL Databases:
Column-oriented Graph
Graphs based
Document-oriented
Key-value Pair Based
It is used to handle data coming in low velocity.
It is used to handle data coming in high velocity.
It gives only read scalability.
It gives both read and write scalability.
It manages structured data.
It manages all type of data.
Data arrives from one or few locations.
Data arrives from many locations.
It supports complex transactions.
It supports simple transactions.
It has single point of failure.
No single point of failure.
It handles data in less volume.
It handles data in high volume.
Transactions written in one location.
Transactions written in many locations.
Support ACID properties compliance
Doesn’t support ACID properties
Its difficult to make changes in database once it is defined
Enables easy and frequent changes to database
Schema is mandatory to store the data
Schema design is not required
Deployed in vertical fashion.
Deployed in Horizontal fashion.
Field
Application
Airline
Flights, reservations, schedules, tickets, etc.
Banking
Clients, account activities, loans, balances etc.
Library
Book information, borrower information, issue date, etc.
Education
Student information, courses, departments, grades, etc.
Telecommunication
Call records, usage, bills, balances etc.
Social Media
User data, demographics, preferences, etc.
E-Commerce
Customer data, purchases, invoices, etc.
Human Resources
Employee information, salary, payroll, deductions, etc.
Manufacturing
Supplier information, product details, quantities, etc.
(free plan option)
(Enterprise plan available)
(NoSQL / document-oriented)
(NoSQL)
