I find data models and scalability design for popular applications, such as facebook and Linkedin to be quite fascinating.
Here is the data model of facebook, which has been reverse engineered.
Here is the Data API documentation.
Some thoughts on the data model, and the power using associations.
