tags:

views:

112

answers:

1
+3  Q: 

What is Facebook's database schema for messages like?

How does Facebook structure their data for messages. I have heard they use Cassandra for inbox search, but is this the only technology they use?

+2  A: 

Here's how the Facebook database schema might look like.

I doubt it actually looks like this, because such a normalized scheme wouldn't be very scalable. Check out Data Management, Facebook-style.

the_void  2010-07-04 10:52:09

related questions

How do you determine how far to normalize a database?
Tips for database design in a web application
How do you deal with polymorphism in a database?
Database Patterns
Is it okay to have a lot of database views?
Extra tables or non-specific foreign keys?
Implementing a '20 Questions'-like Wizard in a Database
Database Design for Revisions?
Which database table Schema is more efficient?
How do you build a ratings implementation?
How should I model a field that can contain both numeric and string values in SQL Server 2005?
What if analysis on multi dimensional cubes (OLAP)
Data model for a extensible web form
Database Schema Diagram Design Tool
Good strategy for leaving an audit trail/change history for DB applications?
How do you recommend implementing tags or tagging
One database or many?
Suitable E-R notation for introductory DB design course? Good/free diagram tools?
What is the best strategy for retainment of large data sets?
Query a union table with fields as columns.
When is a file just a file?
Database triggers
What are the advantages of using a single database for EACH client?
Database, Table and Column Naming Conventions?
Auto Generate Database Diagram MySQL