Sharding and partitioning in DBMS Theory - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is partitioning in databases?

Partitioning is the process of dividing a large database table into smaller, more manageable pieces called partitions. Each partition holds a subset of the data, often based on a specific column value like date or region.

beginner

Define sharding in simple terms.

Sharding is a type of database partitioning where data is split across multiple servers or machines. Each shard holds a portion of the data, helping to spread the load and improve performance.

intermediate

How does sharding differ from partitioning?

Partitioning divides data within a single database or server into parts, while sharding splits data across multiple servers or machines. Sharding is a form of horizontal scaling, whereas partitioning is often within one system.

beginner

Give a real-life example of when sharding is useful.

Imagine a social media app with millions of users. Sharding lets the app store user data on different servers based on user location or ID, so no single server gets overloaded and the app runs faster.

intermediate

What are common ways to partition data?

Data can be partitioned by range (e.g., dates), list (e.g., countries), or hash (using a function to evenly distribute data). These methods help organize data for faster access and easier management.

What does sharding primarily help with?

A Compressing data to save space

B Distributing data across multiple servers

C Encrypting database data

D Backing up data regularly

Sharding splits data across multiple servers to improve performance and scalability.

Which of these is a common partitioning method?

A Backup partitioning

B Encryption partitioning

C Range partitioning

D Compression partitioning

Range partitioning divides data based on ranges like dates or numbers.

Partitioning usually happens within:

A A single database or server

B Multiple servers worldwide

C Only cloud databases

D Backup storage systems

Partitioning divides data inside one database or server.

Which scenario best fits sharding?

A Backing up data to an external drive

B Splitting a table into smaller parts on one server

C Encrypting sensitive data in a database

D A large website spreading user data across servers

Sharding spreads data across servers to handle large scale and traffic.

Hash partitioning means:

A Using a function to evenly distribute data

B Dividing data by date ranges

C Grouping data by country names

D Encrypting data with a hash

Hash partitioning uses a function to spread data evenly across partitions.

Explain the difference between sharding and partitioning in databases.

Think about where the data is divided and why.

Describe a real-life example where sharding would improve a system's performance.

Consider popular apps or websites with many users.