A few weeks back I shared a salesforce.com whitepaper that gives the high-level details of the architecture underlying the Force.com platform. For those looking to learn more about the database underpinning the platform you can find even more information in another whitepaper titled “Best Practices for Deployments with Large Data Volumes” [PDF, 629KB]. As someone who does a fair amount of writing I can confidently say this is one of the best salesforce.com whitepapers I’ve ever read. The content is great but the format is what makes it.
The primary purpose of the document is to give architects the options and approaches when dealing with orgs that have, or will have – you guessed it – large amounts of data. As a byproduct though it ends up revealing information about the virtual database shared by all tenants. Salesforce.com has literally built a database within a database (databasception?!) with its own optimising features such as divisions, virtual indexes and skinny tables!
In short, if you ever have to deal with large amounts of data on the Force.com platform, or if you’re just the inquisitive type, I bet you’ll learn at least one new thing from this great whitepaper!