Online Learning Platform

DBMS > Inroduction > What is Database Management System (DBMS)?

A database management system (DBMS) is a software package for creating and managing databases. It helps users to store, retrieve, query and manage data into the database.

The primary purpose of a DBMS is

  • It provides a systematic method of creating, updating, storing, and retrieving the data stored in a database.
  • It enables end users and application programmers to share data, and
  • it enables data to be shared among multiple applications.
  • It provides facilities for controlling data access, enforcing data integrity, managing concurrency control, and restoring a database.

Well-known DBMSes include:

Ms Access – a lightweight relational database management system (RDMS) included in Microsoft Office.
Amazon RDS – a native cloud DBMS that offers engines for managing MySQL, Oracle, SQL Server, PostgreSQL and Amazon Aurora databases.
Apache Cassandra - an open-source distributed database management system known for being able to handle massive amounts of data.
MySQL – an open-source relational database management system (RDBMS) owned by Oracle.
MariaDB - an open-source fork of MySQL.
Oracle - a proprietary relational database management system optimized for hybrid cloud architectures.
SQL Server – an enterprise-level relational database management system from Microsoft that is capable of handling extremely large volumes of data and database queries.

 

Prev
Why do we use database rather than files?
Next
What is Application Program?
Feedback
ABOUT

Statlearner


Statlearner STUDY

Statlearner