Sharding is a very important concept that helps the system to keep data in different resources according to the sharding process. The word “Shard” means “a small part of a whole“. Hence Sharding means dividing a larger part into smaller parts. In DBMS, Sharding is a type of DataBase partitioning in which a large database is divided or partitioned into smaller data and different nodes. These shards are not only smaller, but also faster and hence easily manageable.
Consider a very large database whose sharding has not been done. For example, let’s take a DataBase of a college in which all the student’s records (present and past) in the whole college are maintained in a single database. So, it would contain a very very large number of data, say 100, 000 records. Now when we need to find a student from this Database, each time around 100, 000 transactions have to be done to find the student, which is very very costly. Now consider the same college students records, divided into smaller data shards based on years. Now each data shard will have around 1000-5000 students records only. So not only the database became much more manageable, but also the transaction cost each time also reduces by a huge factor, which is achieved by Sharding. Hence this is why Sharding is needed.
Bạn đang xem: What is Sharding in DBMS?
Xem thêm : Why Shiba Inu Is Dropping This Week
In a sharded system, the data is partitioned into shards based on a predetermined criterion. For example, a sharding scheme may divide the data based on geographic location, user ID, or time period. Once the data is partitioned, it is distributed across multiple servers or nodes. Each server or node is responsible for storing and processing a subset of the data.
To query data from a sharded database, the system needs to know which shard contains the required data. This is achieved using a shard key, which is a unique identifier that is used to map the data to its corresponding shard. When a query is received, the system uses the shard key to determine which shard contains the required data and then sends the query to the appropriate server or node.
Nguồn: https://pinkcloud.edu.vn
Danh mục: News
This post was last modified on Tháng năm 8, 2024 10:59 sáng
Hey there, fellow Californian drivers! Are you tired of shelling out a fortune for car…
We have chosen NY Central Mutual, Geico, Progressive, Erie Insurance and USAA as the best…
Rochester, NY, is a beautiful city with diverse neighborhoods and unique driving conditions. Whether you're…
Are you a New York driver on the hunt for the most affordable car insurance?…
Are you a Rochester, NY, resident wondering, "How much is car insurance in Rochester, NY?"…
Looking for affordable and reliable car insurance in Rochester, NY? You're in the right place!…