Local Secondary Index vs. Global Secondary Index
Secondary Index A secondary index is used in databases to help speed up queries when we want to grab data from popular columns or if we »
Sharding User IDs of Celebrities
Problem When you are partitioning (or sharding) database writes across multiple nodes based on a User ID, a typical partitioning algorithm is to use a basic »
Data Sharding: Twitter Posts
Scenario Let's begin with a Twitter-like service that allows you to tweet new posts. The service has very high read and write traffic , we'll say ~10k »
Sharding Techniques
Introduction Sharding can be summarized as a technique in which a database table can be split into multiple database servers to optimize read/write performance. Benefits »
RDBMS Optimization
Indexing Probably the easiest tweak to implement. It can usually be done with one SQL command. However, an index should be made based on a good »