What does partitioning mean in regards to a database?
Partitioning a database means taking various parts of the data stored in the database and separating them into various partitions, or pieces. This is often done to accommodate load balancing, or to help provide smaller database sets that can be worked on by independent server systems.
Webinar: Moving Relational Databases Beyond the Traditional Register Here |
In a partitioned database, some partitioned sets may be shared across various nodes or servers. Others will be housed independently in one node.
Different types of partitioning included range partitioning, list partitioning and hash partitioning. In range partitioning, engineers partition a single database table by splitting it up into multiple key ranges. List partitioning involves taking a top-level identifier and grouping data sets into a partitioned database node. Hash partitioning uses a hash function to sort out the partitioning of data sets.
Engineers also talk about “shards” in horizontal partitioning. A database shard is held in its own server to, again, accommodate load balancing or load sharing. Database partitioning is a growing phenomenon as relational databases and other tools handle increasing volumes of data in the age of big data and analytics.
Tags
Written by Justin Stoltzfus | Contributor, Reviewer

Justin Stoltzfus is a freelance writer for various Web and print publications. His work has appeared in online magazines including Preservation Online, a project of the National Historic Trust, and many other venues.
More Q&As from our experts
- What is the difference between little endian and big endian?
- How can unstructured data benefit your business's bottom line?
- What are some of the dangers of using machine learning impulsively without a business plan?
Related Terms
- Database
- Relational Database
- NoSQL
- SQL Server
- Load Balancing
- Relational Database Management System
- Virtual Memory
- Random Access Memory
- Synthetic Backup
- SQL Server
Related Articles

Data Quality: Why Diversity is Essential to Train AI

How to Set Up a Static IP Address

AI in the Enterprise: 3 Key Application Areas

5 Ways AI is Changing Art
Tech moves fast! Stay ahead of the curve with Techopedia!
Join nearly 200,000 subscribers who receive actionable tech insights from Techopedia.
- The CIO Guide to Information Security
- Robotic Process Automation: What You Need to Know
- Data Governance Is Everyone's Business
- Key Applications for AI in the Supply Chain
- Service Mesh for Mere Mortals - Free 100+ page eBook
- Do You Need a Head of Remote?
- Web Data Collection in 2022 - Everything you need to know