@abhishekchandra

OLTP vs OLAP: Understanding the Key Differences

Jul 21, 2025 · 2 min read · OLTP means Online Transaction Processing and OLAP means Online Analytical Processing. OLTP (Online Transaction Processing) OLTP databases supports the day to day transactions. It’s a scenario database for storing day to day sales, people coming in, l...

How Data Stays Organized: The Magic of Relational Databases

Jun 29, 2025 · 9 min read · Disclaimer: This article focuses only on Relational Databases and how it came into existence. Please follow the DBMS series to understand the Databases and Management Systems completely. Why Relational Database Model (HISTORY)? To understand why rela...

Understanding Databases: Backbone of Modern Technology

Jun 9, 2025 · 5 min read · Disclaimer: This article contains very basic information related to the Databases. Please follow the series to understand the Databases and Management Systems completely. Why is Database? Let’s rewind to mid 1990s, when there was an e-commerce boom. ...

Selection Sort Algorithm Explained!

Nov 30, 2022 · 6 min read · In the previous article, I explained how the Bubble Sort algorithm works. Please have look at the Bubble Sort algorithm first before reading this article as it will be easier for you to learn the Selection Sort algorithm having Bubble Sort in mind. S...

Bubble Sort Algorithm Explained!

Nov 29, 2022 · 8 min read · Introduction Sorting is a process of arranging a list of items in an order, so that the items in the list are arranged either in ascending order or descending order. Sorting is a very common process that we can also see it in our daily lives, like th...