How Data is stored in Relational Database

It’s important to understand how database stores data internally, understanding this allows us to understand why a query runs fast or slow. Before diving in, let’s clear out some computer fundamentals, all the data on a computer is stored as streams of 1s and 0s as blocks/pages on the drive, Databases use these blocks and…

Indexes in SQL

Introduction to Indexes in RDBMS

The database is used to store data and help us to query complex queries. As time passes every table becomes heavy the number of rows a particular table will increase. This will lead to a slow response of queried data. Indexing addresses this problem, what essentially an index does is sort the data in such…


Introduction to ACID

ACID is the acronym for four relational database properties know as Atomicity, Consistency, Isolation, and Durability. Relational Databases provide these features and we will see why these features are needed and what they are. What is Transaction in database? The transaction is a collection of SQL statements that act as a single. Consider this transaction….


Types of Databases

Over the years, there were many competing approaches to data storage and querying. The oldest and best-known database is a relational database, where the data is organized into relations called a table. To overcome the drawbacks of Relational Database like scalability, a document model database is introduced the term NoSql got famous. The term NoSQL…


An Introduction to Database

A database is a collection of data, arranged in such a way that you can access and manage it easily. The database is vast topic concepts like index, ACID, CAP theorem, types of databases, normalization, Sharding, Consistency, MapReduce, Eventual Consistency is some of the interesting topics in this field. This blog will be a series…