Database

System Design

Database

6 Resources

  • What is Database?
  • Relational Databases
  • Non-Relational Databases
  • What is database replication?
  • Database Sharding
  • Database Indexing

    • Overview

    When designing any system you will realize that it will require to store some data. That is where a database comes in. Choosing a database for the job can either make or break your system.

    Introduction

    A database is a collection of data stored in a specific way so as to allow efficient storage and retrieval of data.

    A Database Management System(DBMS) is software that interacts with a database providing an interface for creating, modifying, and querying a database. Examples of DBMS include SQL Server, MySQL, PostgreSQL, Oracle, and MongoDB.

    What is Database?

    A database is a collection of data stored in a specific way so as to allow efficient storage and retrieval of data.

    Explore this Resource

    Relational Databases

    Relational databases are also known as Relational Database Management Systems (RDBMS) or SQL databases. They organize and store data in a tabular format of rows and columns, making it easy to understand how data relates to one another. The most important ones are MySQL, SQL Server, PostgreSQL, and Oracle.

    Explore this Resource

    Non-Relational Databases

    Non-relational databases are also known as non-relational database management systems or NoSQL(not only SQL). They are non-tabular. There are four major types of NoSQL databases: document, key-value, wide columns, and graph databases.

    Explore this Resource

    What is database replication?

    Database replication is the process of copying data from one database in a server to one or more replica databases in other servers. The databases become synced.

    Explore this Resource

    Database Sharding

    This degradation in performance can be attributed to the database acting as a bottleneck, resulting in high latency and low throughput. To address this issue, it becomes necessary to scale the database. Two potential approaches to accomplish this are database replication and database sharding.

    In the context of a social media platform with an enormous volume of user-generated data being produced every second, database sharding emerges as a superior solution to alleviate these challenges.

    Explore this Resource

    Database Indexing

    However, if the library has a well-designed indexing system it gets very easy to locate any book. The indexing system will contain a catalog that lists all the books in alphabetical order along with their corresponding shelf numbers.

    By consulting the index, you can easily pinpoint the exact location of a book request saving you time and effort.

    Explore this Resource

    Whenever you're ready

    There are 4 ways we can help you become a great backend engineer:

    The MB Platform

    Join 1000+ backend engineers learning backend engineering. Build real-world backend projects, learn from expert-vetted courses and roadmaps, track your learnings and set schedules, and solve backend engineering tasks, exercises, and challenges.

    The MB Academy

    The “MB Academy” is a 6-month intensive Advanced Backend Engineering BootCamp to produce great backend engineers.

    Join Backend Weekly

    If you like post like this, you will absolutely enjoy our exclusive weekly newsletter, Sharing exclusive backend engineering resources to help you become a great Backend Engineer.

    Get Backend Jobs

    Find over 2,000+ Tailored International Remote Backend Jobs or Reach 50,000+ backend engineers on the #1 Backend Engineering Job Board