DataBase Management System

DBMS! DBMS! DBMS! Ugghhh What is DBMS and why is it So important now days?

With the rise of the digital economy, data has become an increasingly valuable commodity. Businesses are collecting more data than ever before, and just about every industry now has a data-driven ecosystem. The problem is, not all of this data will be useful in the long run. A lot of data is obsolete or irrelevant by the time it’s collected.
The most important thing is to make sure that the data you collect is stored in a way that allows you to access it easily without having to sort and thats the Exact point where DBMS or Data Base Management System Comes in Place. Lets Learn What DBMS means and how it helps us to manage Data of our Requirement.

What DBMS means?

What is Data base management system? Data base management system is a set of applications that manages the database of an organization. It specifies how data is stored and accessed. Here is a detailed explanation of data base management system.

A database management system or DBMS is Software that is used to create, manage or enhance a database.
DBMS provides an interface to perform various operations like database creation, storing data in it, updating data, creating a table in the database, and more.

Features of Data Base Management System:

• Define Data:

This allows the user to create modify and delete the definition which defines the organisation of the database.

• Update Data:

Provides the access to the users to insert, modify, and delete data from the database.

• Retrieve Data:

This allows the User to retrieve the data from the database based on the requirements.

• Administration of users:

Registers the users and monitors their actions, enforces data security, maintains data integrity.

Characterstics of Data Base Management System:

• To limit the permission of the users.
• Provides multiple views of the single database schema.
• Facilitates security and removes data redundancy.
• Allows multi-user transactions processing and sharing of data.
• Offers both physical and logical data independence.

Types of Data Base Management System:

• Network DBMS
• Relational DBMS
• Hierarchical DBMS
• Object Oriented DBMS

Some of the popular DBMS Software are:

MySQL, PostgreSQL, Oracle, SQL Server, etc.
All these software are based on different types of DBMS available in the market.