Logo
×

DBMS Tutorial | Database Management System

Database Management System (DBMS) tutorial is all about managing and maintaining the data effectively. Our DBMS tutorial is designed for beginners as well as professionals.

What is Data?

Data is a real-world entity or an object. Data is a distinct piece of information or facts that need to be processed. It can be in any form like text, number, picture, measurements, and bytes.
Example: Ankit, Delhi, 12, 80.

What is Information?

When data are processed, organized, structured, and interpreted in a given context, so as to make them useful and meaningful, they are called information.  
Example: Name - Ankit, City - Delhi, Class – 12, Marks – 80.

what is Information

What is Database?

A database is an organized collection of inter-related data, which helps in insertion, deletion, and retrieval of data efficiently. The database is also used to organize the data or information in the form of tables, views, schemas, reports, etc.


Note: Using the database, you can easily access, update, and delete any information.

Database Management System (DBMS)

A database management system or DBMS is a software used for creating and managing the data in the database easily and effectively. It is basically a set of programs that allow users to store, modify/update, and retrieve information from the database as per the requirements. DBMS also provides security and protection to the database. DBMS acts as a middle layer between the database and the user.

Example: MySQL, MS SQL Server, Oracle, SQL, DB2, Microsoft Access, etc. are different types of database management system.

Characteristics of DBMS

There are various characteristics of a database management system, but following are some important characteristics:

  • A database management system (DBMS) should be able to store any kind of data in a database.
  • Any database management system should be able to support ACID (atomicity, consistency, isolation, durability) properties.
  • The Database management system allows more than one users to access the same database at the same time.
  • Backup and recovery are the two main methods that allow users to protect their data from damage or loss.
  • It provides multiple views for different users in one organization.
  • DBMS follows the concept of normalization to minimize the redundancy of a relation.
  • It provides users query language, using which they can easily insert, retrieve, update, and delete the data in a database.

Advantage of DBMS

  • Minimal data redundancy or data duplicacy.
  • Easy access to data from the database using the query language.
  • DBMS provides backup and recovery methods which create an automatic backup of data from software and hardware failures and restores the data if required.
  • Minimized data consistency.
  • Better data integration.
  • DBMS can applies integrity constraint to the data in the database.
  • DBMS increases consistency and reduces updating errors.

Disadvantages of DBMS

  • A database management system is complex and time consuming to design.
  • Cost of software and hardware is high to run DBMS software.
  • DBMS consumes a large amount of main memory as well as a huge amount of disk space to make it run efficiently.
  • If the database is damaged because of any software or hardware failure, all the application programs will be implicitly affected, which are dependent on it.
  • Initial training is required for all the users and programmers to use the DBMS software.

DBMS Concepts

DBMS ER Model

DBMS Relational Model

DBMS Normalization

DBMS Transaction

DBMS Indexing

Misc

Related Topics

What is a Database

A database is a structured collection of data that is often kept electronically on a computer system. Typically, a database is managed by a database management system (DBMS). Together, the...

9 minutes read.

View Serializability in DBMS

View Serializability It is a type of serializability that can be used to check whether the given schedule is view serializable or not. A schedule called as a view serializable if it is view...

4 minutes read.

Database for library management system

The database can be considered the container where the data or information can be stored electronically in a computer system. Most mobile applications and websites run our day-to-day activities by...

5 minutes read.

Evaluating DBMS

There are various database management systems available in the market. Each type has its features and can be used for varied purposes. The large number of DBMS makes it difficult...

4 minutes read.

Why we need Distributed Database Management System

Assuming there is a very strong single machine having properties like: Heaps of memory.Gigantic measure of dependable stockpiling with very quick I/O.Incredible handling rate and processing power (10s, 100s and might...

4 minutes read.

ER Diagram for Company Database in DBMS

What is ER Diagram? An ER diagram (short for Entity Relationship Diagram), also known as an ERD, is a diagram that shows the relationships of a set of entities stored in...

7 minutes read.

DBMS Architecture

This is the first step when creating a database management system. The architecture of a database management system plays an important role in determining the actual design and layout of...

4 minutes read.

Enforcing Integrity Constraints in DBMS

Introduction Integrity constraints are rules that specify the conditions that must be met for the data in a database to be considered valid. These constraints help to ensure the accuracy and...

2 minutes read.

What is Transaction in DBMS

A transaction is a collection of logically related operations which reads and possibly updates the various data items in the database. Usually, a transaction is initiated by a user program written in high-level...

3 minutes read.

Fundamentals Of Distributed DBMS

Fundamentals of DDBMS Here we are going to talk about the Fundamentals of DDBMS. But first, we need to know about Distributed databases to understand the Distributed Database Management System. Distributed Database: It is...

4 minutes read.

Relational algebra in DBMS

Relational algebra in DBMS Relational algebra is a procedural query language used to retrieve the data from a database in a different way. It works on the relational model. It performs...

3 minutes read.

Advantages of RDBMS

The relational database management system collects related data stored in tabular format. The data is stored in rows and columns, where rows usually represent the individual entity of the collected...

6 minutes read.

Redundancy in Database Management System

Redundancy in a database management system (DBMS) refers to the duplication of data within the database. This duplication can occur in multiple ways, such as having multiple copies of the...

13 minutes read.

DBMS Architecture

Architecture of Database Management System DBMS architecture helps in development, implementation, design, and maintenance of a database that store and organize information for agencies, businesses, and institutions. It is the base of any database...

2 minutes read.

Cardinality in DBMS

Cardinality in DBMS Cardinality is the relationship between two or more entities (table). It shows how all the entities are connected. In DBMS, all the entities and tables are interconnected with...

2 minutes read.

Disadvantages of DBMS

Disadvantages of DBMS With the vast list of advantages, there are some following disadvantages or limitations of the database management system. 1. High Cost The high cost of software and hardware is the...

2 minutes read.

Hashing in DBMS: Static and Dynamic

Hashing in DBMS: Hashing is the technique of the database management system, which directly finds the specific data location on the disk without using the concept of index structure. In the...

4 minutes read.

Levels of Locking in DBMS

There are several levels of locks that can control the access to the elements stored at various levels in the Database. There can be multiple levels of the locks. These...

6 minutes read.

Concurrent Execution of Transaction

In the transaction process, a system usually allows executing more than one transaction simultaneously. This process is called a concurrent execution. Advantages of concurrent execution of a transaction Decrease waiting time or...

4 minutes read.

Difference between DBMS and RDBMS

Database Management System A DBMS is system software which is used to store and manage the data in the database. It was introduced in 1960 for storing the data or information. This system allows...

3 minutes read.