Benefits of Database Sharding

by Jim J
Relational databases maintain and keep data reliable. Updating the database by adding, removing, or changing data is easy with relationships and data integrity offered by relational databases. NoSQL on the other hand is another way of managing data without the complications in setting up a relational database, the cons being difficulty to maintain. An important benefits is better scalability and performance than relational databases with large amounts of data. Database sharding offers a middle grand between the two; it allows for performance and scalability benefits of NoSQL, but maintains data integrity akin with relational databases. With database sharding, the computing power of the relational database is broken up into many severs each with their own CPU, memory, and disk thus resulting in better performance than traditional relational databases.

Nowadays, the number of applications that require data is increasing. The growing number of smartphone apps that require constant communication with a database and updating large amounts of information require a relational database easy to maintain and equally important with performance benefits.

Important factors users consider when using an app is the performance on their smartphone. Nowadays, the majority of users have trouble limiting their app usage and thus opt for optimized apps that efficiently manage the smartphone’s processing power and require less time out of the user to function. A relational database with data sharding feature allows for all of these benefits.

Works Cited

“Scaling Big Data with Your Relational Database.” Database Trends and Applications 26.1 (2012): 24-. ABI/INFORM Complete. Web. 4 June 2012.

3 thoughts on “Benefits of Database Sharding

  • April 28, 2012 at 11:26 pm

    I would believe that with this idea of database sharding it would greatly improve some part of the database process. However beside splitting relational database into different severs what can this technique actually do to help developer with the development of a relational database. Is splitting the database into separate hard drive really help with performance or save disk space?

  • April 28, 2012 at 11:32 pm

    I don’t think sharding will help in the development of the database, it will still be complicated as it is with relational databases, from what I understand, the benefits of easy implementation of a NoSQL database are nonexistent in a relational database with data sharding, data sharding simply improves the performance matching performance of a NoSQL database in supporting constant access to large amounts of data.

  • April 29, 2012 at 2:01 pm

    I guess it all depends on the application, by allocating the database that gets more use with its own server and cpu I can see how it might perform better, but I can imagine this might be more costly ….

Comments are closed.