Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What format do sites like Facebook use to store data for personal profiles?

I recently started dealing with large sets of data stored in XML files. I've always wondered how Facebook and other networking sites store all the information associated with individual profiles (name, profile picture, wall posts, etc.) and I feel like XML is definitely not the best way to store so much information. I've tried finding information about it with google but haven't been having too much luck.

How do huge sites such as Facebook store and deal with so much data? I would really like to do some reading about this, so if you know of any good websites please let me know!

like image 640
Kurtis Avatar asked Jul 03 '11 06:07

Kurtis


People also ask

What is the format of the data that is pulled Facebook?

When you request a copy of your information on Facebook, you can choose to receive it in an HTML or JSON format: HTML: An easy to view format of your data on Facebook. You'll receive a ZIP file that, once opened and extracted, will contain an HTML file named index that you can open like a web page on your web browser.

What type of database does Facebook use?

Facebook was developed from the ground up using open source software. The site is written primarily in the PHP programming language and uses a MySQL database infrastructure.

How is Facebook data stored?

Each data center houses tens of thousands of computer servers, which are networked together and linked to the outside world through fiber optic cables. Every time you share information on Facebook, the servers in these data centers receive the information and distribute it to your network of friends.

What is Facebook information file?

The file, which can take less than ten minutes to create and download, contains all of your Facebook history, including photos, private messages and other highly intrusive information, such as: The names of the Facebook profiles you've visited and when. Your entire Facebook search history.


1 Answers

Rather than being stored in an XML file, Facebook uses a relational database--specifically, a modified version of MySQL. If you're interested in their implementation, the MySQL official site has a whole page of articles related to Facebook's MySQL usage at http://www.mysql.com/customers/view/?id=757

like image 110
UtopiaLtd Avatar answered Nov 15 '22 17:11

UtopiaLtd