Introduction of DBMS (Database Management System)

Himmat Kumar Nov 14, 2024, 7:13 AM
DBMS
Views 126
Blog Thumbnail

DBMS INTRODUCTION

A database management system (DBMS) refers to the technology for creating and managing databases. DBMS is a software tool to organize (create, retrieve, update, and manage) data in a database. The main aim of a DBMS is to supply a way to store up and retrieve database information that is both convenient and efficient. Usually, people use software such as dBase IV or V, Microsoft Access, or Excel to store data in the form of a database.

Why use DBMS?

  • To develop software applications in less time.
  • Data independence and efficient use of data.
  • For uniform data administration.
  • For data integrity and security.
  • For concurrent access to data, and data recovery from crashes.
  • To use user-friendly declarative query language.

Where DBMS is used

  • Airlines: reservations, schedules, etc.
  • Telecom: calls made, customer details, network usage, etc.
  • Universities: registration, results, grades, etc.
  • Sales: products, purchases, customers, etc.
  • Banking: all transactions, etc.

Advantages of DBMS

A DBMS manages data and has many benefits. These are:

  • Data independence: Application programs should be as free or independent as possible from details of data representation and storage. DBMS can supply an abstract view of the data for insulating application code from such facts.
  • Efficient data access: DBMS utilizes a mixture of sophisticated concepts and techniques for storing and retrieving data competently. This feature becomes important in cases where the data is stored on external storage devices.
  • Data integrity and security: If data is accessed through the DBMS, the DBMS can enforce integrity constraints on the data.
  • Data administration: When several users share the data, integrating the administration of data can offer significant improvements. Experienced professionals understand the nature of the data being managed and can be responsible for organizing the data representation to reduce redundancy and make the data to retrieve efficiently.

Components of DBMS

  • Users: Users may be of any kind such as DB administrator, system developer, or database users.
  • Database application: Database application may be departmental, personal, organization's and/or internal.
  • DBMS: Software that allows users to create and manipulate database access.
  • Database: Collection of logical data as a single unit.

Comments

Please login to leave a comment.

No comments yet.

Related Posts

what-is-data-guide
318 viewsDBMS
Himmat Regar Jun 23, 2025, 4:03 PM

What Is Data? A 2025 Guide to Types, Lifecycle & FAQs

what-is-data-model-in-dbms
210 viewsDBMS
Himmat Kumar Nov 22, 2024, 11:43 AM

what is Data Model in DBMS?

types-of-queries-in-dbms
143 viewsDBMS
Himmat Kumar Dec 23, 2024, 8:33 AM

Types of Queries in DBMS

what-is-database-definition-types-examples
735 viewsDBMS
Himmat kumar regar May 12, 2025, 5:32 AM

What is a Database? Definition, Types, Examples & FAQs ...

what-is-a-blog
164 viewsMarketing
Himmat Kumar Mar 12, 2025, 7:06 AM

What is a Blog? Understanding Its Purpose, Structure, a...

how-to-create-table-in-mysql
228 viewsMySQL
Himmat Kumar Nov 12, 2024, 3:56 AM

how to create table in MySQL database?

websocket-in-laravel-guide
1262 viewsLaravel
Himmat Kumar Apr 3, 2025, 2:10 PM

WebSocket in Laravel - A Complete Guide

modern-login-form-html-css
234 viewsHTML
Himmat Kumar Mar 4, 2025, 12:57 AM

Creating a Modern Login Form with HTML & CSS

getting-started-with-html-setup-edit-run-code-in-browser
323 viewsHTML
Himmat Kumar Jul 25, 2024, 1:09 PM

Getting Started with HTML: Setup, Edit, and Run Your Co...

laravel-cookies-guide
1077 viewsLaravel
Himmat Regar Jun 1, 2025, 2:23 PM

Laravel Cookies: Secure, Encrypted & Easy (Guide 2025)