newsql: the best of both "oldsql" and "nosql"

RISE OF

NEWSQLTeam members :1. Hemang Tailor2. Sushant Choudhary3. Vinay Jain

What is NEWSQL???

Combination of Traditional SQL and NOSQL First time NEWSQL term used in 2011 Matthew Aslett used this Guarantees ACID Properties

WHY NEEDED :

VERSIONS

JAVA SQL

WHAT IS REALLY NEW INNEWSQL……………………

EXAMPLE :

Traditional SQL

NOSQL

NEWSQL NUODB AND

STORAGE :

ACID PROPERTIES :TRADITIONAL SQL NOSQL

NEWSQLBASICALLY AVALIABLE SOFT STATE EVENTUAL CONSISTENT

Scalability :

CAP THEOREM :

PERFORMANCE :

CONSISTENCY :

IN MEMORY DATABASE :TRADITIONAL SQL NOSQL

NEWSQL

SECURITY : Overcomes Drawback of NOSQL. Provides

Better authentication. Better confidentiality. Better authorization.

NODEJS INTEGRATION :

Traditional SQL

NOSQL

NEWSQL The benchmark consisted of Node.js instances simultaneously executing Voter transactions against the VoltDB database.  Each Node.js instance processed transactions at throughput of ~11,000 per second, and scaling was highly linear from 32 to 64 instances, at which point the benchmark had achieved aggregate throughput of 695,000 TPS.

OLTP :

BIG DATA :TRADITIONAL SQL NOSQL

NEWSQL

QUERY LANGAUGE : TRADITIONAL SQL – Structured Query language NOSQL- UNQL,CQL………… NewSQL- SQL

COMPARISON :PROPERTIES TRADITIONAL

SQLNOSQL NEWSQL

ACID PROPERTY

IN MEMORY DB

BIG DATA

RDBMS

APPLICATION : The world's largest distributed database Store data across multiple data centers, millions of

machines and trillions of rows. Internally used by Google. Has a true time API to avoid latency problems. Supports Google's Advertising business. It is fault tolerant to large scale outages. Offers very high availability and latency (Aiming for

99% and 50 ms) Spanner has evolved from a Bigtable-like versioned

key-value store 

VENDORS :

REFERENCES : Stonebraker, Michael (2011-06-16). "NewSQL: An Alternative to

NoSQL and Old SQL for New OLTP Apps". Communications of the ACM Blog. Retrieved 2012-07-06

Hoff, Todd (2012-09-24). "Google Spanner's Most Surprising Revelation: NoSQL is Out and NewSQL is In". Retrieved 2012-10-07

Cattell, R. (2011). "Scalable SQL and NoSQL data stores". ACM SIGMOD Record 39 (4): 12. doi:10.1145/1978915.1978919

Venkatesh, Prasanna (2012). "NewSQL - The New Way to Handle Big Data" (published 2012-01-30). Retrieved 2012-10-07.

http://nosql-database.org/ http://www.mysql.com/ http://newsql.sourceforge.net/