NoSQL and SQL

 

NoSQL and SQL Databases – Presentation Transcript

  1. Seminar and Progress ReportA comparison between SQL (Conventional) & NOSQL (WebScale) Databases using various scenarios Gaurav Paliwal 0071641507 B.Tech (Information Technology) 8th Semester
  2. What is NoSQLThis does NOT mean “No SQL”
  3. What is NoSQLThis does mean “Not ONLY SQL”
  4. Why is Not only SQLGoogle once ran off of 40,000 MySQL installations
  5. Why is Not only SQLFacebook was at one point spending $1M per month for specialized database hardware to serve their pictures.
  6. Why is Not only SQLThese unviable solutions led to a re-evaluation of existing database technologies and led to the Not-Only-SQL (NoSQL) movement.
  7. The rise of Not only SQL – 1 Googles Way
  8. The rise of Not only SQL – 11. Google invented for BigTable database.
  9. The rise of Not only SQL – 11. Google invented for BigTable database.2. BigTable maps two arbitrary string values (row key and column key)and timestamp (hence three dimensional mapping) into associatedarbitrary byte array.
  10. The rise of Not only SQL – 11. Google invented for BigTable database.2. BigTable maps two arbitrary string values (row key and column key)and timestamp (hence three dimensional mapping) into associatedarbitrary byte array.3. It is not a relational database and can be better defined as a sparse,distributed multi-dimensional sorted map.
  11. The rise of Not only SQL – 11. Google invented for BigTable database.2. BigTable maps two arbitrary string values (row key and column key)and timestamp (hence three dimensional mapping) into associatedarbitrary byte array.3. It is not a relational database and can be better defined as a sparse,distributed multi-dimensional sorted map.4. BigTable is designed to scale into the petabyte range across “hundredsor thousands of machines, and to make it easy to add more machines tothe system and automatically start taking advantage of those resourceswithout any reconfiguration”.
  12. The rise of Not only SQL – 2 Facebooks Way
  13. The rise of Not only SQL – 21. It is a NoSQL solution that was initially developed by Facebook andpowers their Inbox Search feature.
  14. The rise of Not only SQL – 21. It is a NoSQL solution that was initially developed by Facebook andpowers their Inbox Search feature.2. Jeff Hammerbacher, who led the Facebook Data team at the time, hasdescribed Cassandra as a BigTable data model running on an AmazonDynamo-like infrastructure.
  15. The rise of Not only SQL – 21. It is a NoSQL solution that was initially developed by Facebook andpowers their Inbox Search feature.2. Jeff Hammerbacher, who led the Facebook Data team at the time, hasdescribed Cassandra as a BigTable data model running on an AmazonDynamo-like infrastructure.3. Cassandra is an open source distributed database managementsystem.
  16. The rise of Not only SQL – 21. It is a NoSQL solution that was initially developed by Facebook andpowers their Inbox Search feature.2. Jeff Hammerbacher, who led the Facebook Data team at the time, hasdescribed Cassandra as a BigTable data model running on an AmazonDynamo-like infrastructure.3. Cassandra is an open source distributed database managementsystem.4. It is an Apache Software Foundation top-level project designed tohandle very large amounts of data spread out across many commodityservers while providing a highly available service with no single point offailure.
  17. The rise of Not only SQL – OthersHadoop / HBaseHypertableAmazon SimpleDBMongoDBTerrastoreCouchDBMemcacheDBAnd Many others {{The list is Endless}}.
  18. Benefits of NoSQL Databases 1. Elastic scaling
  19. Benefits of NoSQL Databases 2. Big data
  20. Benefits of NoSQL Databases 3. Goodbye DBAs
  21. Benefits of NoSQL Databases 4. Economics
  22. Benefits of NoSQL Databases 5. Flexible data models
  23. NoSQL comparison with SQL 1. ACID
  24. NoSQL comparison with SQL 2. CAP
  25. NoSQL comparison with SQL 3. Maturity
  26. NoSQL comparison with SQL 4. Support
  27. NoSQL comparison with SQL5. Analytics and business intelligence
  28. NoSQL comparison with SQL 6. Administration
  29. NoSQL comparison with SQL 7. Expertise
  30. NoSQL comparison with SQL Practical “Head On”
  31. NoSQL comparison with SQL Questions

Google Hoaxes (April Fool) for year 2010

Google Hoaxes (April Fool) for year 2010 :

Snippet from http://en.wikipedia.org/wiki/Google%27s_hoaxes#2010

—————————

Nuclear Google

Apparent Google Jail Page

Google Translate for Animals

Google Street View available in Anachrome 3D

When using Google Street View you can change the view to display (faux?) anachrome 3D images. It can be enabled by clicking on the orange Street View icon, now depicting a man that is wearing Red/Cyan glasses. The man seems happy when wearing the glasses, unhappy when he just has them on his head. NOT A HOAX, actually works.

Google Maps OCCA

Google Australia changed directions for to use Australian Slang terms in the direction results. Examples of the altered directions include “You need to go south towards [street name] mate”, “Hang a right when you get to [street name]”, “Chuck a left when you get to [street name]”, “Ya gotta take the turn off onta [street name]” and saying “Ya might have to cough up some cash along here” to indicate toll booths.

Search results generated in different times

Google’s search results page displayed the time taken to load the results in different units than seconds; for example microfortnights, microweeks, nanocenturies, epochs, femtogalactic years, parsecs, skiddo, jiffies, shakes of a lamb’s tail, gigawatts, hertz, Planck times, centons, warp factors and “times the velocity of an unladen swallow”.

Youtube logo made out of ASCII art

The logo of YouTube was changed to an ASCII-style one made out of 1s.

YouTube videos with ASCII art

The Youtube logo is a reference to all the videos having a new quality setting, namely “TEXTp”. According to a notice underneath the videos, viewing the video with this quality setting enabled allows YouTube to save one US dollar ($1) per second on bandwidth costs. The notice also remarks on the source of this new “feature”, wishing the reader a happy April Fool’s Day.

April Fools 2010 – Animal Translator BETA

For April Fools day 2010, Google placed a link on the main page, advertising a new Google Animal Translator service to add to their Language Translator service. Clicking the link would take you to a page advertising an app for Android phones for the translator, with the tagline being “Bridging the gap between animals and humans”.
—————————