Select three websites from the top 500 list: http://www.alexa.com/topsites Provi

Question

Select three websites from the top 500 list: http://www.alexa.com/topsites Provide insight into the following questions for each website: What do you think the most important requirements/attributes are for their database? How do you think their tables/entities are structured? Does this site have any potential bottlenecks? What language/technologies do they use to interact with databases? (For some insight into this, check out this tool: https://wappalyzer.com/ ) Do they have a security policy? If so, do they mention databases and any policies regarding them?

Explanation / Answer

Consider the first site google.com :

The most important requirement for this site is the search query.As the google is search engine. It requires the query given by the user shoulb be relevant. Google requires the database to store the informations of all sites related to given query. The entities and table in google are stored in non structure datbase.Google uses the Google File System(GFS) for its all operations and storage.Bottleneck is the stage where performance of system is slow.

In case of google system bottleneck is when user enter very long query which has no meaning.

Since the google search engine uses keywords for searching.

Google has its own security policies implemented.

b) In case of facebook,the whole data of users and related stuff are stored in the big tables and database called HDFS .HDFS stands for Hadoop file system. It is similar to the Google GFS.To interact with the database of facebook we can use java language Hadoop APIs and also we can use Hadoop shell for querying the database.

I think the site has no bottleneck .It is a good social site.

facebook.com also have their security policies.

c)Yahoo.com

yahoo.com is also good site providing the search engine and mail services and question and answer boards to the users. yahoo.com also make uses of Big database such HDFS and database like DynamoDb and Mysql.

All the bottlenecks in yahoo.com are solved afterwards.Similary we can use any language API to access the database.

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.