• Skip to primary navigation
  • Skip to content
  • Skip to primary sidebar
  • Skip to footer
EDUCBA

EDUCBA

MENUMENU
  • Resources
        • Java Tutorials

          • Cheat Sheet Java
          • Cheat Sheet Python
          • C# vs Js
        • Java Tutorials
        • Python Tutorials

          • Angular 5 vs Angular 4
          • Careers in Python
          • Kali Linux vs Ubuntu
        • Python Tutorials
        • Top Differences

          • Cheat Sheet JavaScript
          • Python Interview Questions
          • Cloud Computing or Virtualization
        • Top Differences
        • Others

          • Resources (A-Z)
          • Top Interview Question
          • Programming Languages
          • Web Development Tools
          • HTML CSS Tutorial
          • Technology Basics
          • Technology Careers
          • View All
  • Free Courses
  • All Courses
        • Certification Courses

          Software Development Course 2
        • All in One Bundle

          All-in-One-Software-Development-Bundle
        • Become a Python Developer

          Python-Certification-Training
        • Others

          • Java Course
          • Become a Selenium Automation Tester
          • Become an IoT Developer
          • Ruby on Rails Course
          • Angular JS Certification Training
          • View All
  • 600+ Courses All in One Bundle
  • Login

Introduction To DBMS

Home » Software Development » Blog » SQL Tutorials » Introduction To DBMS

Introduction To DBMS

Introduction to DBMS

The developer builds an application or software, but Software needs Data to perform day to day operations and analytics over processed data and data is something which is driving the business nowadays to excel in their respective areas of operations. So as a developer, we need a Data Base Management System (DBMS) where we can create, update, delete, administer and moreover to do an analysis on the data. A Database Management System (DBMS) is a software package designed to define, manipulate, retrieve and manage data in a database. let us look at this introduction to DBMS article in detail.

Main Components of DBMS

In the Above Section, we have studied about the Introduction to DBMS, So now we are going ahead with the components of DBMS:

Start Your Free Software Development Course

Web development, programming languages, Software testing & others

Main Components of DBMS

The main components of the introduction to DBMS systems are as follows:

1. Hardware: All the physical devices that are being used in DBMS operations are called the hardware. For example, if we run MySQL server, then the hard disk, RAM, the keyboard comes under Hardware component

2. Software: This is one of the most important components as it contains all the programs that will drive the DBMS functionality. The job of this software is to understand the Database access language and interpret into actual database commands to execute them on the DB.

3. Data: The DBMS system collects, store, process and reads the data. This is yet another important component of the DBMS system. The DBMS contains the actual, operation or the metadata.

Popular Course in this category
Cyber Week Sale
SQL Training Certification (7 Courses, 8+ Projects) 7 Online Courses | 8 Hands-on Projects | 73+ Hours | Verifiable Certificate of Completion | Lifetime Access
4.5 (1,813 ratings)
Course Price

View Course

Related Courses
JDBC Training (6 Courses, 7+ Projects)PHP Training (5 Courses)Windows 10 Training (4 Courses, 4+ Projects)

4. Procedures: Procedure is the general instructions and rules that help in using a DBMS.

5. Database Access Language: It is a query language which is used to write commands to perform CRUD operations like create, read, update and delete.

Characteristics of DBMS

As we have already learned about the Introduction of DBMS. Now, we are going to discuss the Characteristics of DBMS:

  • DBMS supports ACID properties.
  • It stores any kind of Data.
  • Automatically backup the data and supports recovery.
  • It maintains Data Integrity.
  • It controls Data Redundancy to a great extent.
  • It enables the sharing of Data with much ease.
  • It supports Data Security and prevents restriction of unauthorized access.
  • It also represents the complex relationship between Data and views.

applications of DBMS

Applications of DBMS

As we learned about Introduction to DBMS in the above section here are the main applications of DBMS:

 

1. Banking System: DBMS stores customer usual and vital information, stores the transactions, user’s activities, loans, accounts, etc.

2. Telecom: DBMS keeps a track of the calls that are made, network usage, details of the customer, bills, and balances, etc.

3. Airlines: DBMS stores flight information, customer details, flight timings, reservation and booking information, etc.

4. Online Shopping: DBMS stores product information, user’s information, credit information, etc.

5. Educational and Corporate: DBMS stores student’s and employee information, client’s details, training and course information, student/employee performance, etc.

6. Manufacturing and Industry: DBMS is used to keep a track of all units that are manufactured, products that go out and the ingredients that come in, etc.

Advantage And Disadvantage of DBMS

After going through all the components, characteristics and the wide Introduction to DBMS, we are going to explore the advantages and disadvantages of DBMS:

Advantages of DBMS

Let’s see some advantages of DBMS:

Data Redundancy

1. Data Redundancy

Unlike traditional file-system storage, Data Redundancy in DBMS is very less or not present. Data Redundancy occurs when the same data are stored unnecessarily at different places. Data Redundancy is reduced or eliminated in DBMS because all data are stored at a centralized location rather than being created by individual users and for each application. For e.g. Application A and Application B have the same user MARVEL, and we need to store personal information about the user such as Name, age, address, Date of Birth, etc. Not to mention, this user has also access to different application, so in traditional file-based system, there is a need to maintain separate file system for each of the application to store user’s information while in DBMS approach, there could be just one centralized location where information can be down streamed to different application as and when needed.

Data Inconsistency

2. Data Inconsistency

In traditional file system storage, the changes made by one user in one application doesn’t update the changes in other application, given both have the same set of details. While this is not the case with DBMS systems as there is a single repository of data that is defined once and is accessed by many users, and data are consistent.

Data Sharing

3. Data Sharing

Data Sharing is the primary feature of Database management systems. DBMS system allows users and applications to share Data with multiple applications and users. Data are stored in one or more servers in the network and there is some software locking mechanism that prevents the same set of data from being changed by two people at the same time. While the file system doesn’t have this capability.

data searching

4. Data Searching

Searching and retrieving of data is very easy in DBMS systems. The need to write separate programs for each of the search is eliminated as in the case with a traditional file-based approach. In DBMS, we can write small queries to search for multiple information at a time from the data from DB servers.

Data security

5. Data Security

DBMS systems provide a strong framework to protect data privacy and security. DBMS ensures that only authorized users have access to data and there is a mechanism to define access privileges.

Data Concurrency

6. Data Concurrency

In DBMS, Data are stored in one or more servers in the network and that there is some software locking mechanism that prevents the same set of data from being changed by two people at the same time.

 Data Integration

7. Data Integration

Data integration is a process of combining the data residing at different locations and present the user with a unified view of data. DBMS systems allow Data Integration with much feasibility.

Data Access

8. Data Access

While in traditional file-based approach, it might take hours to look for very specific information that might be needed in the context of some business emergency, while DBMS reduces this time to a few seconds. We can write small queries which will search the Database for you and it will retrieve the information in the fastest way possible due to its inbuilt searching operations.

Decision making

9. Decision making

Improved Data Sharing and better-managed data allow business to make quality business decisions which will promote the growth of the organization.

Data Backup and Recovery

10. Data Backup and Recovery

DBMS provides a strong framework for Data backup, users are not required to back up their data periodically and manually, it is automatically taken care by DBMS. Moreover, in case of a server crash, DBMS restores the Database to its previous condition.

Data Migration

11. Data Migration

There are some data which are access very frequently while there are few that aren’t. So, DBMS provides the capability to access the frequently accessed data as quickly as possible.

Data Tuning

12. Data Tuning

DBMS allows the user to fine-tune their data i.e. to improve performance.

Low Maintenance Cost

13. Low Maintenance Cost

Though DBMS systems might be costly at the time of purchase but their maintenance involves a very minimal cost.

Data Loss is almost eliminated

14. Data Loss is almost eliminated

With DBMS, one can keep information for thousands of years, provided we don’t see the doomsday. Data security and very low storage cost (as compared to our previous generations) in the current century cut any possibility of Data Loss.

Data Atomicity

15. Data Atomicity

An atomic transaction is one in which all of the database actions occur or none of them do. It is the duty of DBMS to store a complete transaction in the database. If any transaction is partially completed, then it rolls backs them. For e.g. if we make an online purchase, money is deducted from our account while if the purchase is somehow failed, then no money is deducted or if it gets deducted, it gets returned within few days.

Data Atomicity

Image Source: https://www.geeksforgeeks.org/acid-properties-in-dbms/

Disadvantages of DBMS

Let’s see some disadvantages of DBMS:

  • Cost of hardware and software
  • Technical staff requirement
  • Management Complexity
  • Frequent upgrade/Management cycles

Recommended Articles

This has been a guide on Introduction to DBMS. Here we have discussed the main components, characteristics, advantages, and disadvantages of DBMS. You may also look at the following articles to learn more –

  1. RDBMS Interview Questions with Answers
  2. Differences between DBMS vs RDBMS
  3. HADOOP vs RDBMS|Know The 12 Useful Differences
  4. Supply Chain Management Process in SME

SQL Training Certification (7 Courses, 4+ Projects)

7 Online Courses

8 Hands-on Projects

73+ Hours

Verifiable Certificate of Completion

Lifetime Access

Learn More

0 Shares
Share
Tweet
Share
Reader Interactions
Leave a Reply Cancel reply

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

Primary Sidebar
Technology Blog Tutorials
  • SQL Tutorial
    • MySQL Queries
    • PL/SQL Data Types
    • Joins in MySQL
    • GROUP BY clause in SQL
    • SQL WHERE Clause
    • SQL Constraints
    • Jspinner
    • SQL SELECT Query
    • Cursors in PL/SQL
    • SQL Date Function
    • Cursors in SQL
    • CASE statement in PL/SQL
    • MS SQL Interview Questions
    • SQL Joins Interview Questions
    • Wildcards in MySQL
    • Table in SQL
    • Wildcard Characters
    • SQL Alter Command
    • Transactions in SQL
    • Foreign Key in SQL
    • First Normal Form
    • SQL Insert Query
    • Types of Joins in SQL
    • ORDER BY Clause in SQL
    • Wildcard in SQL
    • Database in SQL?
    • What is PL/SQL?
    • PostgreSQL Data Types
    • Second Normal Form
    • Advantages of DBMS
    • Introduction To DBMS
    • Hierarchical Database Model
    • What is Procedure in SQL
  • Database Management (71+)
  • Ethical Hacking Tutorial (33+)
  • HTML CSS Tutorial (47+)
  • Installation of Software (54+)
  • Top Interview question (188+)
  • Java Tutorials (196+)
  • JavaScript (71+)
  • Linux tutorial (32+)
  • Network Security (85+)
  • Programming Languages (232+)
  • Python Tutorials (89+)
  • Software Development Basics (321+)
  • Software Development Careers (38+)
  • String Functions (12+)
  • Technology Commands (38+)
  • Top Differences (368+)
  • Web Development Tools (33+)
  • Mobile App (60+)
Technology Blog Courses
  • JDBC Training Course
  • PHP course
  • Windows 10 Training
Footer
About Us
  • Who is EDUCBA?
  • Sign Up
  •  
Free Courses
  • Free Course Programming
  • Free course Python
  • Free Course Java
  • Free Course Javascript
  • Free Course on SQL
  • Free Course on Web Design
  • Free HTML Course
  • Free Android App Development Course
Certification Courses
  • All Courses
  • Software Development Course - All in One Bundle
  • Become a Python Developer
  • Java Course
  • Become a Selenium Automation Tester
  • Become an IoT Developer
  • Ruby on Rails Course
  • ASP.NET Course
  • VB.NET Course
  • Bootstrap Training Course
  • Become a Linux System Administrator
  • PHP Course
  • Joomla Training
  • HTML Course
Resources
  • Resources (A To Z)
  • Java Tutorials
  • Python Tutorials
  • Top Differences
  • Top Interview Question
  • Programming Languages
  • Web Development Tools
  • HTML CSS Tutorial
  • Technology Basics
  • Technology Careers
  • Ethical Hacking Tutorial
  • SQL Tutorials
  • Digital Marketing
Apps
  • iPhone & iPad
  • Android
Support
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions

© 2019 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Software Development Course

Web development, programming languages, Software testing & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Software Development Course

Web development, programming languages, Software testing & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Software Development Course

Web development, programming languages, Software testing & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Software Development Course

Web development, programming languages, Software testing & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

Let’s Get Started
Please provide your Email ID
Email ID is incorrect

Cyber Week Offer - SQL Training Certification (7 Courses, 4+ Projects) View More

Cyber Week Offer - Cyber Week Offer - SQL Training Certification (7 Courses, 4+ Projects) View More