Database Management System (DBMS)

Cluster Indexing

Cluster indexing is a technique used in database management systems (DBMS) to improve the efficiency of queries involving range searches and sorting. It involves organizing the data in a table based on one or more attributes, called the clustering key.

Primary Indexing in DBMS

Primary indexing is a type of indexing used in databases to improve the speed of accessing data by creating an index based on the primary key of a table.

Database Management System (DBMS)

SQLite - Viewing Data

In this article at OpenGenus, we learn about streamlining database queries by using views. By creating a view that combines data from multiple tables, we can simplify complex queries and improve query readability.

System Design

7 Rs of database migration

The 7 Rs of database migration are a collection of tactics for planning and carrying out a database migration project. These tactics aid in decision-making and offer a foundation for effective database migration.

Database Management System (DBMS)

SQLite - Deleting Database

In this article at OpenGenus, we explain how to delete data safely from SQLite tables using commands like DELETE and DROP TABLE, as well as foreign key constraints like ON DELETE.

Database Management System (DBMS)

SQLite - Writing database

This Article at OpenGenus teaches how to write data to an SQLite database using SQL statements. Explains the basic syntax and usage of INSERT INTO statement. This includes examples for inserting data into a table with and without specifying columns.

Database Management System (DBMS)

SQLite - Designing Database

This article at OpenGenus outlines the process of developing a database utilizing an external file, while also showcasing the tables' data structure and type. It is intended to provide a clear and concise approach to database design.

Software Engineering

Basic SQLite commands

In this article, we have listed and explained how to use some of the basic SQLite commands in detail.

System Design

File Systems in Database

In this article, we will learn what is file organization and what are benefits of doing it. We already know that data is stored in database, when we refer this data in terms of RDBMS we call it collection of inter-related tables.

System Design

Sharding

Sharding is a technique used in database architecture to partition a large database into smaller, more manageable pieces called shards. Each shard contains a subset of the data in the larger database, and is stored on a separate server or cluster of servers.

Software Engineering

Different Normal Forms / Normalization in DBMS

We have explored Normalization in Database Management System (DBMS) in depth along with different normal forms like first normal form, second normal form, boyce codd normal form and others.