Skip to content

Category Archives: DBMS

A parallel DBMS is a DBMS that runs across multiple processors or CPUs and is mainly designed to execute query operations in parallel, wherever possible.… Read More
Three-Tier Architecture :The 3-Tier architecture, intermediate servers handle the client request, which coordinates the execution of the client request with subordinate servers. It adds middle… Read More
Introduction of Shared Memory Segment :The quickest kind of IPC accessible is shared memory. There is no kernel participation in transmitting data between processes after… Read More
Parallelism in a query allows us to parallel execution of multiple queries by decomposing them into the parts that work in parallel. This can be… Read More
JOINS :Joins in SQL are used to combine rows from multiple tables on a specific condition, which is a relation between the columns of two… Read More
Surrogate key also called a synthetic primary key, is generated  when a new record is inserted into a table automatically by a database that can… Read More
In this article, we will discuss the overview of the Database Approach and will mainly focus on its characteristics. Also, we will cover the Characteristics… Read More
In this article, we will discuss the overview of DDL commands and will understand DDL commands like create, alter, truncate, drop. We will cover each… Read More
In MySQL date is a data type and by default follows the format ‘YYYY-MM-DD’ but by using date formatting functions we can format date and… Read More
In this article, we will discuss the overview of transaction, deadlock and will focus on update conflicts with the concurrent update and understand with the… Read More
In this article, we will discuss the overview of computer-based controls and will discuss computer-based control available in a multi-user database environment in detail. Let’s… Read More
Overview :The concept of ‘Self Stabilization’ was first proposed by Dijkstra in 1974. It is a general technique for non-masking distributed systems. It is a… Read More
Just a Bunch Of Disks : JBOD (stands for “Just a Bunch Of Disks”) is referred as the collection of hard disks with one single… Read More
In this article, we will discuss the overview of SQL and will mainly focus on Concepts and Queries and will understand each with the help… Read More
In this article, we will look into the process of querying the sum of all values in a column of a database table. But before… Read More