smarttypes/SmartTypes — Issue #1: Time based table partitioning and sharding
Author: smarttypes
Created: 2011-10-23 21:34:02+00:00
State: open

Right now the schema does not store network history (ie, if a user changes the people they follow -- we're not preserving the old state). It's important to store the old state, so we can see movement + trends in the network.

Also, we want to make sure the storage design scales.

We want to use a combination of table partitioning + db sharding.

The partition + shard key will be time (year_month).