Welcome to tutorial series of DBMS.If you are new to DBMS then you’re welcome. And If you are thinking ,you are good at DBMS then its for you guys only to recall the concepts.

If you want to work in software industry you should know at least basics of DBMS. As far as placement is concern , they ask very simple query like INSERT,UPDATE,DELETE,TYPES OF JOIN etc. There is no technical interview without DBMS questions.

In this tutorial,we will discuss very basics of DBMS like what is DBMS ?, Characteristics, Advantages, Dis-advantages and when not to use DBMS etc.

What is DBMS?

Database Management System (also known as DBMS) is a software for storing and retrieving users’ data by considering appropriate security measures. It allows users to create their own databases as per their requirement.

The DBMS accepts the request for data from an application and instructs the operating system to provide the specific data. In large systems, a DBMS helps users and other third-party software to store and retrieve data.

Characteristics of DBMS:

• Provides security and removes redundancy.
• Self-describing nature of a database system
• Insulation between programs and data abstraction
• Support of multiple views of the data
• Sharing of data and multi-user transaction processing
• DBMS allows entities and relations among them to form tables.
• It follows the ACID concept ( Atomicity, Consistency, Isolation, and Durability).
• DBMS supports multi-user environment that allows users to access and manipulate data in parallel.

Advantages of DBMS:

• DBMS offers a variety of techniques to store & retrieve data
• DBMS serves as an efficient handler to balance the needs of multiple applications using the same data
• Uniform administration procedures for data
• Application programmers never exposed to details of data representation and storage.
• A DBMS uses various powerful functions to store and retrieve data efficiently.
• Offers Data Integrity and Security
• The DBMS implies integrity constraints to get a high level of protection against prohibited access to data.
• A DBMS schedules concurrent access to the data in such a manner that only one user can access the same data at a time
• Reduced Application Development Time

Disadvantage of DBMS:

• Cost of Hardware and Software of a DBMS is quite high which increases the budget of your organization.
• Most database management systems are often complex systems, so the training for users to use the DBMS is required.
• In some organizations, all data is integrated into a single database which can be damaged because of electric failure or database is corrupted on the storage media
• Use of the same program at a time by many users sometimes lead to the loss of some data.
• DBMS can’t perform sophisticated calculations

When not to use a DBMS system?

Although, DBMS system is useful. It is still not suited for specific task mentioned below:

Not recommended when you do not have the budget or the expertise to operate a DBMS. In such cases, Excel/CSV/Flat Files could do just fine.