Database Management System
A Database Management System(DBMS) is a software system, which allows the storage of related data and provides easy access. DBMS performs important functions which guarantee the integrity and consistency of data in the database. It includes Data Dictionary Management, Data Storage Management, Data Transformation and Presentation, Security Management, Multi-user Access Control, Backup and Recovery Management, Data Integrity Management, Database Access Languages, Application Programming Interfaces, and Database Communication Interfaces.
RAID
By Ankit Kumar
● Published At Feb 2022
The article will guide you through RAID in DBMS and different levels of RAID used for storing duplicate data as a way to use it for backup.... Keep reading ..
Introduction
Database Management System is a Software Tool that is used to insert, retrieve, update and manage data in a database. In this category, you will learn everything that you need to know to get started with Database Management System.
Introduction to DBMS
By Shivani Kumari
● Published At Feb 2022
In this article, you will learn about DBMS(Database Management System), a software that is used to manage databases. ... Keep reading ..
DBMS vs. RDBMS and DBMS vs. file system
By Soumya Agrawal
● Published At Jan 2022
This article will cover the difference between DBMS and RDBMS and file system and DBMS.... Keep reading ..
DBMS Architecture
By Rhythm Jain
● Published At Jan 2022
n this article, we will discuss DBMS Architecture.... Keep reading ..
Data Models
By Ankit Kumar
● Published At Jan 2022
This article will discuss the various data models in DBMS. We shall analyse each of the data models.... Keep reading ..
Database Languages
By Muskan Gupta
● Published At May 2022
This blog covers the concept of Database Languages. ... Keep reading ..
DBMS Storage System
By Apoorv Dixit
● Published At Jan 2022
In this blog, we will learn about the storage system in DBMS, types of storage devices, memory hierarchy in the computer system.... Keep reading ..
Data Independence and ACID Properties
By Sanjana Yadav
● Published At Dec 2021
In this post, wet will cover the concept of Data Independence. With the assistance of various examples, we will learn about the ACID properties, what they stand for, and what each property is used for.... Keep reading ..
Difference between OLTP and OLAP
By Divyansh Jain
● Published At Feb 2022
In this article, we will discuss the difference between OLAP and OLTP, the two famous terminologies which are commonly mistaken for one another.... Keep reading ..
Database Design Tools
By PRASHANT SINGH
● Published At Feb 2022
This blog introduces the concept of Database Design Tools and covers the various types of software tools that help design databases efficiently.... Keep reading ..
ER Diagram and Relational Models
Entity Relationship diagrams and Relational Models help in defining and visualizing the way in which data is going to be stored in the database and the relationships between them.
Entity-Relationship Diagram
Entity Relationship Diagram or ER Diagram is a type of structural diagram used in database design. An ER Diagram contains different symbols and connec
Relational Data Models
By Debarati Ghatak
● Published At Dec 2021
In this blog, we will discuss Relational Data Models - a vital topic of DBMS(Database Management System). ... Keep reading ..
Anomalies in Relational Model
By Shivani Kumari
● Published At Jan 2022
 In this article, we will learn about different anomalies that can occur in a database. We will also see how to deal with these anomalies and learn about normalization.... Keep reading ..
Dimensional Data Modeling
By Amisha Purswani
● Published At Dec 2021
In this blog, we'll learn dimensional data modeling, different kinds of schemas and see the comparison between these schemas. ... Keep reading ..
Data Warehouse Modeling
By Amisha Purswani
● Published At Dec 2021
In this blog, we'll learn about data modeling, data modeling types, and types of data warehouse models. Read the blog to learn more.... Keep reading ..
ER vs Relational Model
By Malay Gain
● Published At Dec 2021
In this article, we will discuss ER vs Relational Model.... Keep reading ..
Relational Algebra
By Ankit Kumar
● Published At Dec 2021
This article will cover the various operations in relational algebra, along with examples of each of them. We will learn all about relational algebra. ... Keep reading ..
Example on Relational Algebra
By Ankit Kumar
● Published At Mar 2022
In this article, we will see an example of relational algebra and also brush up on relational algebra operators.... Keep reading ..
Database Design and Normalisation
Database Design involves defining how data needs to be stored in the database and how that data is interrelated. Normalization helps in making an optimal and more managed design for data storage.
Functional Dependencies
Functional dependency refers to the relationship between two attributes of a table. This relationship can be used to find the value of one attribute w
Normalization
Normalization is the process of removal of data redundancy from a relation or set of relations which may cause insertion, deletion, and update anomali
Inference Rule in DBMS
By Saloni Singhal
● Published At Dec 2021
The objective of this blog is to understand what Inference rules are. ... Keep reading ..
Transaction and Concurrency Control
The transaction is a set of logically related operations. Concurrency Control is the process of managing the simultaneous execution of transactions in shared memory space.
Scheduling
Scheduling is executing the transactions in a particular sequence. Introducing the idea of scheduling and explaining in the Database Management System
Introduction to Concurrency Control
By PRASHANT SINGH
● Published At Dec 2021
This blog is to introduce you to Concurrency Control in SQL. It deals with interleaved execution of more than one transaction.... Keep reading ..
Lock Based Protocol in DBMS
By Amisha Purswani
● Published At Dec 2021
This article will illustrate the basic concepts of Locks and different types of locks with examples and how Locks help maintain a database.... Keep reading ..
Implementation of Locking
By Shivani Kumari
● Published At Dec 2021
In database management systems, locking techniques control concurrency. In this article, you will learn about locking and the implementation of locking in DBMS. ... Keep reading ..
Graph-based protocol
By Ankit Kumar
● Published At Jan 2022
The gist behind the text is to let you know more about the Graph-based protocol method. We will be learning about its type and advantages, and drawbacks.... Keep reading ..
Two-Phase Locking
By PRASHANT SINGH
● Published At Jan 2022
This blog introduces lock-based protocols and their types. This blog is about two-phase locking in DBMS with their types.... Keep reading ..
Two-Phase Locking Protocol
By Shivani Kumari
● Published At Dec 2021
The database should be locked and unlocked in a way that there are no inconsistencies. In this article, you will learn about the two-phase locking protocol. ... Keep reading ..
Conservative 2-Phase Locking
By Ankit Kumar
● Published At Jan 2022
The gist behind the text is to let you know more about the Conservative 2-Phase Locking (C2PL) method. Read the blog to learn more. ... Keep reading ..
Multiple Granularity Locking
By Shivani Kumari
● Published At Jan 2022
In this article, we will learn about granularity and multiple granularity locking in DBMS. Read the blog to learn more.... Keep reading ..
Thomas Write Rule
By Amisha Purswani
● Published At Dec 2021
In this blog, we'll learn what Thomas write rule is. The three conditions we need to check in it. Then we will look at examples of its implementation, its advantages, and disadvantages.... Keep reading ..
Deadlock in DBMS
By Akshat Chaturvedi
● Published At Jan 2022
In this Blog post, we’ll briefly study deadlocks in database management systems and how we can prevent them effectively.... Keep reading ..
Log Based Recovery
By Sanjana Yadav
● Published At Jan 2022
In this post, we will cover the concept of Log Based Recovery in DBMS. We will learn about the need, definition, usage, and implementation of Log Based Recovery in DBMS. ... Keep reading ..
Starvation in DBMS
By Divyansh Jain
● Published At Feb 2022
In this article, we will learn how a process can be starved for an indefinite time to acquire a lock.... Keep reading ..
File Organisation
File organizations deal with the structure in which files are stored in the memory and how to access them.
Introduction to File Organization
By PRASHANT SINGH
● Published At Dec 2021
This blog introduces file organization in the database management system, its objectives, and types of file organization.... Keep reading ..
Hash File Organization
By PRASHANT SINGH
● Published At Dec 2021
This blog is about the Hash File Organizations, how this file organization works, and the principles behind this file organization that is hashing. We will also learn about hashing and its types.... Keep reading ..
B+ Tree File Organization
By PRASHANT SINGH
● Published At Dec 2021
This blog introduces B+ tree file organization in the database, how this file organization works, and the advantages and disadvantages of B+ tree file organization.... Keep reading ..
Indexing in Databases
Indexing is the way of storing information about the data in the database which provides us a way to access data efficiently based on attributes on which indexing is done.
Indexing and its types
By PRASHANT SINGH
● Published At Feb 2022
This blog introduces the concept of Indexing in DBMS. This blog covers the structure of index and index types in DBMS with their suitable examples... Keep reading ..
Introduction to B-Tree
By Amisha Purswani
● Published At Feb 2022
In this blog, we'll learn about B-tree and see algorithms of standard operations like insertion, searching, and deletion in B-tree with examples.... Keep reading ..
Delete Operation in B-Tree
By Ankit Kumar
● Published At Mar 2022
This article discusses the delete operating in B-tree by covering all the potential edge cases in detail.... Keep reading ..
Introduction to B+ Trees
By Reet Maggo
● Published At Dec 2021
This article explains B+ trees' function, structure, and advantages using examples and illustrations.... Keep reading ..
Comparison between B Tree and B+ Tree
By PRASHANT SINGH
● Published At Feb 2022
This blog compares the B Tree and B+ tree and covers the B tree and B+ tree with their examples and role in DBMS(Database Management System).... Keep reading ..
Bitmap Indexing
By Shivani Kumari
● Published At Jan 2022
In this article, we will learn about Bitmap Indexing and how and why it is used. We will also learn about the advantages and disadvantages of using bitmaps.... Keep reading ..
Inverted index
By Ankit Kumar
● Published At Jan 2022
This article will discuss the critical concept of indexing and the use of the inverted index in increasing the search speed in the given database.... Keep reading ..
Difference between Inverted Index and Forward Index
By Shivani Kumari
● Published At Feb 2022
This article will learn about the difference between the inverted and forward index, the working of both types of indexing, and their importance. ... Keep reading ..
SQL Queries On The Clustered And Non-clustered Indexes
By PRASHANT SINGH
● Published At Jan 2022
This blog is about the clustered and non clustered indexes, how and when to use these queries with suitable examples of Clustered and Non clustered indexes, respectively.... Keep reading ..
Structured Query Language
SQL stands for Structured Query Language. SQL is a query language that provides us a way to insert, update, delete and retrieve data from a database.
Basic SQL
Basic SQL Commands helps in doing CRUD operations, doing aggregations, and formatting query results.
Advance SQL
Advanced SQL Commands are those which allow us to perform queries within queries, generate results by joining multiple tables, and perform operations
PL/SQL
In this category, we will be introducing the PLSQL, what it is? How to set up PLSQL in your system and get started with it and don't forget your first
SQL Introduction
By Ankit Kumar
● Published At Jan 2022
This article will discuss the introduction of the structured query language (SQL). We shall see various commands used in SQL and also how it is used.... Keep reading ..
SQL Databases
SQL Databases covers the databases that are based on the programming language called SQL. This category will start with MySQL, and how to install and set it up. It further explains various MySQL features and functions including the representations of various data types and variables. Further, it introduces PostgreSQL and explains its features and how to install and set it. It introduces Oracle and Microsoft SQL. It also shows how SQL differs from MySQL and how MySQL differs from PostgreSQL.
MySQL
In MySQL, we will be introducing what it is and how to install it. As in DBMS, MYSQL is one of the most popular platforms to implement SQL databases,
Oracle
Oracle Database is the first database built for corporate grid computing, the most versatile and cost-effective method of managing data and applicatio
Microsoft SQL
Microsoft SQL Server is a relational database management system that Microsoft has created. It is a database server, which is a software product whose
PostgreSQL
PostgreSQL is an open-source object-relational database system that focuses on flexibility and SQL compliance. Transactions with Atomicity, Consistenc
scroll-indicator
scroll-indicator
SQL vs MYSQL
By Divyansh Jain
● Published At Mar 2022
In this blog, we'll define SQL and MySQL, as well as investigate the distinctions between them, also we will discuss relational databases.... Keep reading ..
MySQL vs PostgreSQL
By Divyansh Jain
● Published At Mar 2022
In this article, we will learn about MySQL and PostgreSQL and the usage of both of these databases. Also, we will learn about the major differences between these two databases.... Keep reading ..
NoSQL Databases
NoSQL databases are non-tabular and cover various types of such non-tabular databases. There are various types such as MongoDB and RavenDB. Further, it covers Redis and what it is. It covers what Redis is and how one can install and get started with Redis, what are the tools and modules associated with Redis. It also covers an introduction to Hbase and its architecture and Features. It covers Hbase's Pros and Cons, the use cases and shell, commands, and table management. it also includes admin and client API and troubleshooting and performance tuning.
Redis
Redis is a free and open-source database. It's an in-memory data structure store that may be used as a distributed, in-memory key-value database, cach
HBase
HBase is a Java-based open-source non-relational distributed database based on Google's Bigtable. It allows you to store vast amounts of sparse data i
Introduction to NoSQL
By Divyansh Jain
● Published At Mar 2022
In this blog, we are going to learn about NoSQL, where to use it followed by its advantages and disadvantages.... Keep reading ..
Types of NoSQL Databases
By Divyansh Jain
● Published At Mar 2022
In this session, we are going to learn about the 4 major types of NoSQL databases. We will be learning about their advantages and disadvantages and their usage.... Keep reading ..
MongoDB vs RavenDB
By Amisha Purswani
● Published At Mar 2022
In this blog, we will learn about No-SQL databases, and we compared two No-SQL databases - MongoDB and RavenDb based on various properties.... Keep reading ..
puzzle icon

Top Problems related to Database Management System