![]() The process continues until every table in ![]() Quite straightforward: take entities that are complex and extract Normalisation is described by Louis Davidson ~ Pro SQL Server 2008 Relational Database Design and Implementation as This is my thought of how it would work, but I know there is millions of pictures on Snapchat servers, so I'm not sure how the speed of querying a large table like that would work, or how else it would be organized.Īll good, future-proofed databases are normalised to some extent. My question is: How does an app like Snapchat go about storing its data (do you think)?ĭoes it just have one huge table of all the images? Meaning when someone uploads and app, does it create an object/row in a large table with the picture, who sent it, recipients, date, etc.? And then when the user logs in, does the app query that large table for all objects in that large table that has the currently logged in users id associated with recipients? But of course, I'm sure that is nothing compared to a real database. I have developed a few small database iPhone apps with, so what somewhat of an idea of how a database works. I am a highschool student who is interested in developing apps and learning more about databases and servers, so please bear with me if this is the wrong place to ask or if it's a obvious answer.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |