×
Home Discussions Write at Opengenus IQ
×
  • DSA Cheatsheet
  • HOME
  • Track your progress
  • Deep Learning (FREE)
  • Join our Internship 🎓
  • RANDOM
  • One Liner

Database Management System (DBMS)

Database Management System (DBMS) is an important domain giving ideas on managing data and running queries on it. It helps you to use Database in real systems efficiently.

Database Management System (DBMS)

Database Indexing

Database indexing is a technique to enhance the speed of data retrieval in a database. An index is a data structure that allows quick access to rows in a table, similar to a book's index helping you find topics quickly without reading every page.

Vidhi Srivastava Vidhi Srivastava
Database Management System (DBMS)

Understanding Transactional Replication in SQL Server

Transactional replication is a popular method for keeping multiple SQL Server instances synchronized by capturing changes from one server (publisher) and applying them to others (subscribers). We will explore its key aspects along with code samples and best practices.

Shreyash Meshram
Database Management System (DBMS)

Codd’s Rules in DBMS

In this article at OpenGenus.org, we learn about Codd's Rules in Database Management Systems (DBMS).

Kavya Mothukuri
Python

Exploring MySQL Connector for Python: A Beginner's Guide

Are you stepping into the world of Python and databases? If so, you're likely to encounter various libraries that facilitate the interaction between your Python scripts and databases. One such powerful tool is mysql-connector-python.

Harsh Vardhan Mahawar
Database Management System (DBMS)

SQL Queries [All Queries you need] with examples

In this article at OpenGenus, we have covered a brief overview of SQL and its importance in database management along with explanation of SQL queries and their role in retrieving data from databases.

Arravelly Keerthi
Software Engineering

SQL vs SQLite vs NoSQL vs MySQL: A Comprehensive Comparison

In this article at OpenGenus, we will explore the differences and similarities between MYSQL, SQLite, SQL, and NoSQL, helping you make an informed decision based on your specific requirements.

Sentayhu Berhanu Sentayhu Berhanu
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.

Shreyas Sukhadeve Shreyas Sukhadeve
Database Management System (DBMS)

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.

Shreyas Sukhadeve Shreyas Sukhadeve
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.

Manish Kumar Manish Kumar
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.

APIPAWE KATOTO Daniel
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.

Manish Kumar Manish Kumar
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.

Manish Kumar Manish Kumar
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.

Manish Kumar Manish Kumar
Software Engineering

Basic SQLite commands

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

Manish Kumar Manish Kumar
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.

Dharmik Patel Dharmik Patel
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.

Dharmik Patel Dharmik Patel
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.

Nimrat Matharoo
OpenGenus IQ © 2025 All rights reserved â„¢
Contact - Email: team@opengenus.org
Primary Address: JR Shinjuku Miraina Tower, Tokyo, Shinjuku 160-0022, JP
Office #2: Commercial Complex D4, Delhi, Delhi 110017, IN
Top Posts LinkedIn Twitter
Android App
Apply for Internship