BeginnersBook

  • Home
  • Java
    • Java OOPs
    • Java Collections
    • Java Examples
  • C
    • C Examples
  • C++
    • C++ Examples
  • DBMS
  • Computer Network
  • Python
    • Python Examples
  • More…
    • jQuery
    • Kotlin
    • WordPress
    • SEO
    • JSON
    • JSP
    • JSTL
    • Servlet
    • MongoDB
    • XML
    • Perl

Introduction to DBMS

Last Updated: July 24, 2022 by Chaitanya Singh | Filed Under: DBMS

DBMS stands for Database Management System. We can break it like this DBMS = Database + Management System. Database is a collection of data and Management System is a set of programs to store and retrieve those data. Based on this we can define DBMS like this: DBMS is a collection of inter-related data and set of programs to store & access those data in an easy and effective manner.

What is DBMS?

  • DBMS is a software that is used to manage the data. Some of the popular DBMS softwares are: MySQL, IBM Db2, Oracle, PostgreSQL etc.
  • DBMS provides an interface to the user so that the operations on database can be performed using the interface.
  • DBMS secure the data, that is the main advantage of DBMS over file system.
  • DBMS also secures the data from unauthorised access as well as corrupt data insertions. It allows multiple users to access data simultaneously while maintaining the data consistency and data integrity.

DBMS allows following operations to the authorized users of the database:

Data Definition: Creation of table, table schema creation, removal of table definition etc. comes under data definition. It is basically a layout of the table and their relation with the other tables in the database. This allows to properly structure the data in such a way so that the data that is related or dependent on other data in real world can be represented the same way in database.

Data Modification: DBMS allows users to insert, update and delete the data from the tables. These tables contains rows and columns, where row represents a record of data while column represents attributes of the records. You can also bulk update the several records in DBMS with a single click.

Data Retrieval: DBMS allows users to fetch data from the database. Searching and retrieval of data is fast in DBMS. The size of the database doesn’t impact this operation, on the other hand in file system, the size of the data can hugely impact the search operation efficiency.

User administration: DBMS also allows user management such as organizing users in different groups with different access levels. Granting users access to certain tables in database, revoking access from certain users etc. This allows the admin of the database to efficiently manage the access to the database and prevent unauthorised access to the databases.

What is the need of DBMS?

Database systems are basically developed for large amount of data. When dealing with huge amount of data, there are two things that require optimization: Storage of data and retrieval of data.

Storage: According to the principles of database systems, the data is stored in such a way that it acquires lot less space as the redundant data (duplicate data) has been removed before storage. Let’s take a layman example to understand this:
In a banking system, suppose a customer is having two accounts, one is saving account and another is salary account. Let’s say bank stores saving account data at one place (these places are called tables we will learn them later) and salary account data at another place, in that case if the customer information such as customer name, address etc. are stored at both places then this is just a wastage of storage (redundancy/ duplication of data), to organize the data in a better way the information should be stored at one place and both the accounts should be linked to that information somehow. The same thing we achieve in DBMS.

Fast Retrieval of data: Along with storing the data in an optimized and systematic manner, it is also important that we retrieve the data quickly when needed. Database systems ensure that the data is retrieved as quickly as possible.

Purpose of Database Systems

The main purpose of database systems is to manage the data. Consider a university that keeps the data of students, teachers, courses, books etc. To manage this data we need to store this data somewhere where we can add new data, delete unused data, update outdated data, retrieve data, to perform these operations on data we need a Database management system that allows us to store the data in such a way so that all these operations can be performed on the data efficiently.

Database systems are much better than traditional file processing systems which we have discussed in the separate article: DBMS vs File System.

❮ PreviousNext ❯

Top Related Articles:

  1. Database Applications – DBMS
  2. Deadlock in DBMS
  3. DBMS SQL Insert Statement
  4. Decomposition in DBMS – Lossless and Lossy with examples
  5. Transaction Management in DBMS

About the Author

I have 15 years of experience in the IT industry, working with renowned multinational corporations. Additionally, I have dedicated over a decade to teaching, allowing me to refine my skills in delivering information in a simple and easily understandable manner.

– Chaitanya

Comments

  1. joshua says

    May 16, 2016 at 6:05 PM

    so helpful!!!!!!!!

    Reply
  2. Sasha says

    July 5, 2016 at 9:20 AM

    This tutorial is so great! I have looked through so many sites, but this is definitely the best one. :) thanks

    Reply
  3. Suranjith Nishalaka Ranasinghe says

    February 19, 2017 at 5:11 AM

    Actually, this tutorial is so great! I have looked through so many sites, but this is definitely the best one. thanks too much..

    Reply
  4. Punyabrata Rath says

    March 29, 2017 at 7:11 AM

    Everything has been explained in such a simple way that it becomes convenient for everyone to read and understand…

    Reply
  5. jeff says

    April 29, 2017 at 8:41 PM

    Excellent presentation so easy to understand

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

DBMS Tutorial

Basics

  • DBMS Tutorial
  • DBMS Introduction
  • Database Applications
  • DBMS vs File System
  • DBMS vs RDBMS
  • DBMS Architecture
  • Three-level DBMS architecture
  • View in DBMS
  • Abstraction
  • Instance & Schema
  • DBMS languages

Data Models

  • Data Models
  • ER Diagram
  • ER Design issues
  • Convert ER to table
  • DBMS Generalization
  • DBMS Specialization
  • DBMS Aggregration
  • Relational Model
  • Hierarchical Model
  • Constraints
  • Cardinality

Relational Database

  • RDBMS concepts
  • Relational Algebra
  • Relational Calculus
  • Keys Index
  • Primary Key
  • Super Key
  • Candidate Key
  • Foreign Key
  • Composite Key
  • Alternate Key

Normalization

  • Normalization
  • Functional dependency

Transaction Management

  • Transaction Management
  • ACID properties
  • Transaction States
  • DBMS Schedules
  • Serializability
  • Conflict Serializability
  • View Serializability
  • Recoverability Of Schedule
  • Failure Classification
  • Log based Recovery
  • DBMS Checkpoint
  • Deadlock

Concurrency Control

  • Concurrency Control
  • Lock based protocol
  • Timestamp based protocol
  • Validation based protocol

File Organization

  • File Organization
  • Sequential File Organization
  • Heap File Organization
  • Hash File Organization
  • DBMS ISAM
  • B+ File Organization
  • Cluster File Organization

SQL Introduction

  • SQL Introduction
  • SQL Characteristics
  • Advantages of SQL
  • SQL Commands
  • SQL Operators
  • SQL CREATE
  • SQL DROP
  • SQL SELECT
  • SQL INSERT

Copyright © 2012 – 2025 BeginnersBook . Privacy Policy . Sitemap