Last updated: Jan 24, 2022

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.
Difference Between View And Materialized View
In this article, we will discuss what are views, materialized view, their properties, and the difference between the view and materialized view.
Introduction to Apache Spark EASY
This article will discuss the concepts involved in Apache Spark including its features, applications, benefits along with some frequently asked questions.
Installing and Working with Apache Spark EASY
In this article, we will discuss installing and working with Apache Spark for different operating systems, such as Windows, Mac, and Ubuntu.
Apache Spark with Scala EASY
In this blog, we will discuss about the powerful combination of Apache Spark with Scala followed by its basic concepts and implementations
Isolation in DBMS EASY
In this blog, we will learn about Isolation in DBMS. We will understand its core concepts, its usage, and much more for better understanding.
Aries Recovery Algorithm in DBMS EASY
In this article, we will learn about the Aries Recovery Algorithm in DBMS in detail, including its phases, key features, and practical examples.
Introduction to Spark Streaming EASY
This article walks you through spark streaming, its working, uses, advantage and hands on with spark streaming.
Cursor in DBMS EASY
In this article, we will discuss what cursors are, how they work, and the different types of cursors available in DBMS.
Tuple in DBMS EASY
In this blog, we will learn about Tuple in DBMS. We will understand its core concepts, its usage, and much more for better understanding.
Introduction to Spark SQL EASY
This article discusses Spark SQL, its features, various libraries, and some examples.
Types of Database MEDIUM
In this blog, we will learn about Types of Databases. We will learn about its characteristics, features, and much more for better understanding.
Indexing and Hashing in DBMS EASY
In this article, we will talk about the concepts of indexing and hashing in database management systems (DBMS) and understand their differences with the help of proper examples.
Network Model in DBMS EASY
In this article, we will discuss the network model in more detail, including its structure, advantages, disadvantages, features, operations, & how it differs from the hierarchical model.
Advantages of DBMS EASY
In this blog, we will learn about the Advantages of DBMS. We will learn the Advantages of DBMS Over Traditional File System
Primary Key in Database EASY
In this blog, we will learn about Primary Key in Database. We will understand its core concepts, its usage, and much more for better understanding.
Dirty Read Problem in DBMS
In this blog, we will learn about Dirty Read Problem in DBMS. We will see why it occurs and how to overcome the Dirty Read Problem in DBMS.
Domain Constraints in DBMS EASY
In this blog, we will learn about Domain Constraints in DBMS. We will understand its core concepts, its usage, and much more for better understanding.
Foreign Key MEDIUM
In this blog, we will learn about Foreign Key. We will learn about Foreign key problems, their usage and much more for better understanding.
Graph Algorithms in Spark GraphX MEDIUM
This article will discuss graph algorithms in Spark GraphX and elaborate about their applications in programming with their code implementations.
Big Data Orchestration Using Apache Airflow MEDIUM
This article will discuss Big Data Orchestration using Apache Airflow, its components, installation steps and some advantages and disadvantages.
What are Resilient Distributed Dataset (RDD)?
In this blog, we will learn about the Resilient Distributed Dataset. It is a data structure used in Apache Spark.
Advantages and Disadvantages of Apache Spark EASY
This article covers the concept of advantages and disadvantages of Apache Spark.
RAID in DBMS EASY
RAID is primarily used for data protection, allowing two data copies to be maintained, one on each disc. It's frequently seen in high-end servers and a few tiny workstations.

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 of DBMS (Database Management System) EASY
DBMS stands for Database Management System. It's software to manage and organize databases, allowing storage, retrieval, and manipulation of data.
Transaction Management in DBMS
In this article, we will discuss transaction management in databases, its operations, transaction states, rollback recovery, use cases, and its disadvantages.
Three Schema Architecture of DBMS MEDIUM
In this blog, we will discuss all three schema architecture of dbms, including their definition, structure and advantages of this model.
Attributes in DBMS EASY
DBMS (database management system) stores, organizes, retrieves, and manages data. It acts as an interface between the database and the user.
Application of DBMS - Database Management System EASY
Applications of DBMS 1. Railway Reservation System 2. Library Management System 3. Banking 4. Healthcare 5. E-commerce
Characteristics of Database Approach in DBMS EASY
Characteristics of Database Approach in dbms 1. Integrity of Data 2. Data Independence 3. Data Security 4. Sharing of data
What is RDBMS(Relational Database Management System)? EASY
In this article, we will discuss what is RDBMS (Relational Database Management System) along with it's key features, example and benefits.
Recovery Techniques in DBMS EASY
This article discusses recovery techniques in DBMS and types of recovery techniques in DBMS in detail.
Difference between Schema and Instance MEDIUM
This article explains the difference between schema and instance in DBMS, highlighting their definitions, types, and importance in efficient database design.
DynamoDB vs MongoDB
In this blog, we will discuss what are DynamoDB and MongoDB and the key differences between them.
Relational Calculus in DBMS MEDIUM
Relational Calculus in DBMS is just another way of formulating queries. It is non-procedural and a declarative query language.
Data Models
This article will discuss the various data models in DBMS. We shall analyse each of the data models.
DBMS Storage System
In this blog, we will learn about the storage system in DBMS, types of storage devices, memory hierarchy in the computer system.
Data Independence in DBMS EASY
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.
Difference Between OLAP and OLTP MEDIUM
In this article, we will discuss the difference between OLAP and OLTP, the two famous terminologies which are commonly mistaken for one another.
Query Processing in DBMS EASY
Query processing is a process of translating a user query into an executable form. It helps to retrieve the results from a database.
Database Design Tools
This blog introduces the concept of Database Design Tools and covers the various types of software tools that help design databases efficiently.
Cardinality in DBMS EASY
In this blog, we will discuss about the Cardinality in DBMS, how the mapping cardinalities work, the cardinality types, and how cardinality impacts the database.
Join Dependency in DBMS MEDIUM
In this article, we will cover one of the popular database dependencies, the Join dependency. We will start by discussing what dependencies are.
Data Abstraction in DBMS EASY
Data abstractions in DBMS refer to the hiding of unnecessary data from the end-user. Database systems have complex Data Structures and relationships.
What is Schema in DBMS MEDIUM
In this blog, we'll get to know Schema in DBMS describes how the data should be organized and it also represents the logical constraints that are applied to the data.
OLAP Operations in DBMS
OLAP (Online Analytical Processing) operations in DBMS include roll-up, drill-down, slice, dice, pivot, and drill-through for data analysis.
Referential Integrity in DBMS EASY
Reference means the action of mentioning something for some information and integrity means the status of being whole.
Joins in DBMS EASY
Combine data from multiple tables with joins in DBMS. Learn types, syntax, and how to extract insights. A comprehensive guide for Joins in DBMS
Conflict Serializability in DBMS MEDIUM
Conflict serializability in DBMS ensures schedules are equivalent to serial ones in terms of conflicting operations' execution order.
Redundancy in DBMS EASY
In this article, we'll explore data redundancy in DBMS with examples and address its problems in DBMS (Database Management System).
Candidate Key in DBMS EASY
Discover the importance of candidate keys in database management systems for ensuring unique and efficient data organization. Essential for Database Design

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.
Relational Data Models
In this blog, we will discuss Relational Data Models - a vital topic of DBMS(Database Management System).
Anomalies in DBMS MEDIUM
Explore the concept of Anomalies in DBMS in this informative web resource. Read on to discover its types causes,and how to avoid them.
Data Integrity Constraints in DBMS EASY
In this article, we will discuss the introduction to data Integrity Constraints, Types of Integrity Constraints, and examples with explanations.
Difference between strong entity and weak entity MEDIUM
Learn about the key differences between strong and weak entities and their features in database design, including their definitions, characteristics, and examples.
Hierarchical Model in DBMS EASY
In this blog, we will learn about the Hierarchical Model in DBMS. We will understand its core concepts, syntax, advantages and disadvantages and learn about parameters and much more for better understanding.
Dimensional Data Modeling
In this blog, we'll learn dimensional data modeling, different kinds of schemas and see the comparison between these schemas.
Data Warehouse Modeling
In this blog, we'll learn about data modeling, data modeling types, and types of data warehouse models. Read the blog to learn more.
Relational Algebra
This article will cover the various operations in relational algebra, along with examples of each of them. We will learn all about relational algebra.

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.
Lock Based Protocol in DBMS MEDIUM
Locking protocol in database management system is like a set of rules for managing access to data in databases.
Checkpoint in DBMS MEDIUM
In this article, we will learn about the checkpoints in DBMS and their types. We will also cover the advantages of using a checkpoint in DBMS.
Implementation of Locking
In database management systems, locking techniques control concurrency. In this article, you will learn about locking and the implementation of locking in DBMS.
Graph-based protocol
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.
Two-Phase Locking
This blog introduces lock-based protocols and their types. This blog is about two-phase locking in DBMS with their types.
Timestamp Based Protocol in DBMS
This blog will discuss Time-stamp Based Protocol in DBMS.
Conservative 2-Phase Locking
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.
Multiple Granularity Locking in DBMS EASY
Multiple Granularity in DBMS involves organizing data at various levels of detail, enhancing efficiency and flexibility in information retrieval and management.
Multiple Granularity in DBMS EASY
Multiple Granularity in DBMS involves organizing data at various levels of detail, enhancing efficiency and flexibility in information retrieval and management.
Thomas Write Rule in DBMS EASY
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.
Serializability in DBMS MEDIUM
Learn about Serializability in DBMS with its types i.e conflict and view serializability. Read in detail about testing serializability in DBMS with examples.
States of Transaction in DBMS EASY
DBMS transaction states: Active, Partially Committed, Committed, Failed, and Aborted, ensuring database consistency throughout the transaction lifecycle.
Log Based recovery in DBMS EASY
Log-based recovery in DBMS ensures data preservation and recovery during system failures. The DBMS records every transaction on stable storage for easy data access during failures.
Starvation in DBMS EASY
Explore starvation in DBMS: uncover its causes, discover effective solutions and prevention methods, and understand the surprising advantages of managing starvation

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 in DBMS EASY
Indexing is a technique used in database management systems (DBMS) to speed up the retrieval of data. This article discusses the different types of indexing in DBMS and how they are implemented.
Index Statement In MySQL EASY
In this blog, we will discuss how to create and drop an index column in MySQL and index statement benefits.
Multi-Value Index in MySQL EASY
This blog discusses the concept of a multi-value index in MySQL with various examples in detail.
Introduction to B-Tree
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.
Indexing in DBMS EASY
Indexing in DBMS boosts database query performance by utilizing data structures. It speeds up search times and enhances data retrieval efficiency, leading to faster query results.
Delete Operation in B-Tree
This article discusses the delete operating in B-tree by covering all the potential edge cases in detail.
B+ Tree in DBMS MEDIUM
B++ Trees are a type of self-balancing tree data structure that are used to store and retrieve large amounts of data efficiently.
Comparison between B Tree and B+ Tree
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).
Bitmap Indexing in DBMS EASY
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.
Inverted index
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.
Difference between Inverted Index and Forward Index
This article will learn about the difference between the inverted and forward index, the working of both types of indexing, and their importance.
SQL Queries On The Clustered And Non-clustered Indexes
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.

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.
SQL Introduction
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.
Difference between join and subquery MEDIUM
Sql Join is a mechanism used to combine data from two or more tables based on a related column or set of columns, whereas subqueries are used to retrieve data based on the results of another query.
PIVOT and UNPIVOT in SQL MEDIUM
This article covers the concept of PIVOT and UNPIVOT operators in SQL.

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.
Pros and Cons of Using SQL vs NoSQL Databases EASY
In this article, we will discuss various pros and cons of using SQL and NoSQL databases in detail.
What Is MYSQLDUMP?
In this blog, we will learn about MySQL dump. We will also how to use MySQL dump and MYSQLDUMP in Action. .
Integrity Constraint Violation EASY
Integrity Constraint Violation occurs when a database rule is broken. It leads to inconsistent or invalid data. We will learn how to handle and prevent these violations.
Author Arya27
0 upvotes
MySQL REGEXP operator EASY
In this blog, we will learn about the MySQL regex operator.
Reset MySQL Root Password
In this blog, we will learn about how to reset MySQL root password. We will also understand MySQL Root Password and its importance.
Materialized View in SQL MEDIUM
SQL views and materialized views are two powerful tools that help manage and retrieve data effectively.
MERGE Statement in SQL EASY
In this article, we will discuss the MERGE statement in detail, understanding its syntax, usage, & important points to keep in mind while working with it.
Savepoint in SQL EASY
In this blog, we will learn about Savepoint in SQL. We will understand its core concepts, its usage, and much more for better understanding.
cte in sql server EASY
A Common Table Expression, abbreviated as CTE, is a named temporary result set that you can reference within a SELECT, INSERT, UPDATE, or DELETE statement.
SQL vs Pandas EASY
In this article, we will learn about the difference between SQL and Pandas.
Data Independence in DBMS EASY
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.
SQL vs MYSQL
In this blog, we'll define SQL and MySQL, as well as investigate the distinctions between them, also we will discuss relational databases.
Data Manipulation Language EASY
This article will cover the data manipulation language in SQL. This will also cover the different types of DML commands and importance of it.
Author Shiva
0 upvotes
Difference between File System and DBMS EASY
Learn what is file system and DBMS. In this article will also cover the key differences between file system vs dbms.
Difference between GROUP BY and ORDER BY EASY
The ORDER BY clause sorts the data in ascending or descending order. Whereas the GROUP BY clause groups the tuples(rows) based on the similarities of columns.
Difference Between DELETE and TRUNCATE EASY
In this article, we will discuss about the difference between DELETE and TRUNCATE statements, their syntax, properties, and usage.
Difference between Oracle and SQL Server
In this article, we will discuss the difference between Oracle and SQL Server in detail.
MySQL vs PostgreSQL
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.
What is PARTITION BY in SQL? EASY
PARTITION BY is a clause in SQL that is used to divide a result into partitions for the computations. It has analytical functions such as RANK(), DENSE_RANK(), and ROW_RANK().
Understanding the Difference Between PostgreSQL vs MSSQL Server
In this article, we will discuss the difference between PostgreSQL and MSSQL server.
A guide to TimescaleDB
This blog explains the details of TimescaleDB in which we talk about when we use timescaleDB, its architecture and installing Timescale cloud.

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.
Introduction to NoSQL
In this blog, we are going to learn about NoSQL, where to use it followed by its advantages and disadvantages.
Types of NoSQL Databases
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.
MongoDB vs RavenDB
In this blog, we will learn about No-SQL databases, and we compared two No-SQL databases - MongoDB and RavenDb based on various properties.
Node in Apache Cassandra MEDIUM
The article covers the concept of Cassandra components, data replication, and a node in Apache Cassandra, along with some frequently asked questions.