What is a Database Management System?

Database Management System have changed our world as we know it. They are capable of storing data of huge sizes and of business history of years. Providing businesses an opportunity to grow and adapt to the customer needs.There is another term that you should have a great understanding in order to develop your understanding of Database Management System. The Term is Relational Database Management Systems.

Read Additional Article :    What is a Database.
When computers were reduced to the size where they were places on table. Enterprises big and small , all started using computer software to conduct their business. These software had a nice decent interface so that users can use them easily to put information in application which was stored in database , so that later it can be used to process information

Database Management System

Database Management System handles creation, manipulation and data integrity in a database by providing appropriate tools. Manages all users and transactions that are trying to access the database in way that no transaction is lost .

Now you know, what database management system is . It is just a way of storing and managing data in computers. Now this can be in form of files, or tables. But, with RDBM systems , all tables in databases will have a relation between them . This way we are making sure that we are creating a redundancy in our database, because of few things we want to avoid while designing a database is redundancy. If you want to have a read on those things you can read this article : 

Read : Redundancy

For a better understanding of Database Management Systems  . Go through these articles :

Read : What is DDMS

Read : DBMS Models

What is the use of Database Management System

I have yet to see an area of our practical life , where database management system is not involve . Such is its diversity and flexibility. Pick an industry and you will find DBMS in full effect. Your mobile apps , your social media , systems your banks are using , systems your company is using to run business. All of them have a database & database management systems to run their businesses.  Following are few advantages of database management system

  1. Precise & Accurate data management
  2. Easy to understand
  3. SQL Query Processing
  4. Information Sharing
  5. Reporting by Views & Stored Procedures
  6. User activity monitoring
  7. Backup & data recovery management
  8. Data Integrity & Concurrency.

Also read Features of DBMS.

Examples of Database Management System

Few Examples of database management systems are

  1. Microsoft Database Management System SQL Server Studio MS-SQL
  2. Oracle SQL
  3. MySQL
  4. PSQL
  5. DB2

Also read :  SQL Beginner Guide

DBMS has four properties Atomicity, Consistency, Isolation and Durability. This ensures the proper principles to follow to store and retrieve data. Have a read below on these properties.

ACID Properties

Atomicity :  Requires that all operations (SQL requests) of a transaction be completed; if not, then the                transaction is aborted. Because, a transaction is a single, indivisible, logical unit of work

Consistency : ensures that a transaction won’t allow the system to arrive at an incorrect logical state – the data must always be logically correct.  Hence, maintaining the Consistency even in the event of a system failure.

Isolation : Data used during execution of a transaction cannot be used by second transaction until first one is completed

Durability: Indicates permanence of database’s consistent state. When a transaction is complete, the database reaches a consistent state. That state can not be lost even if the system fails. If , a system failure occurs while a transaction is in progress. Then the transaction is completely undone, leaving no partial effects on data.

Stay Tuned and Share with your fellows , if you think this is what you were looking for. Feel free to suggest any changes or alternative view on this topic.

2 Replies to “What is a Database Management System?”

  1. Pingback: BI Talks BI

Leave a Reply