NewSQL overview

#1

Post by lelf » Fri, Feb 13, 2015, 9:20 AM UTC

NewSQL overview
slideshare.net

Re: NewSQL overview

#2

Post by ddorian43 » Fri, Feb 13, 2015, 1:05 PM UTC

Is there any open-source/free newsql db ?

Re: NewSQL overview

#3

Post by xtrumanx » Fri, Feb 13, 2015, 1:10 PM UTC

For anyone else too lazy to read the slides to find out what NewSQL is, this is slide 13:

    NewSQL: definition

    "A DBMS that delivers the scalability and flexibility 
    promised by NoSQL while retaining the support for SQL 
    queries and/or ACID, or to improve performance for 
    appropriate workloads."

    451 Group

Re: NewSQL overview

#4

Post by mathnode » Fri, Feb 13, 2015, 1:17 PM UTC

ddorian43 wrote: post #2

Is there any open-source/free newsql db ?

Slide 27. VoltDB.

Or use posgres-xc, or mariadb 10 with galera and maxscale. Postgres has JSON storage. MariaDBB has dynamic and virtual columns, and the CONNECT engine which can now directly create new or edit existing JSON files using the SQL interface, instead of dedicated functions for JSON manipulation.

https://mariadb.com/kb/en/mariadb/connect-json-table-type/

Re: NewSQL overview

#5

Post by ddorian43 » Fri, Feb 13, 2015, 1:25 PM UTC

mathnode wrote: post #4

ddorian43 wrote: post #2

Is there any open-source/free newsql db ?

Slide 27. VoltDB. Or use posgres-xc, or mariadb 10 with galera and maxscale. Postgres has JSON storage. MariaDBB has dynamic and virtual columns, and the CONNECT engine which can now directly create new or edit existing JSON files using the SQL interface, instead of dedicated functions for JSON manipulation. https://mariadb.com/kb/en/mariadb/connect-json-table-type/

voltdb free has no HA

postgres-xc/xl has no HA

Maxscale looks like it doesn't yet offer sharding

Re: NewSQL overview

#6

Post by 0942v8653 » Fri, Feb 13, 2015, 1:50 PM UTC

Is there a non-slideshare link?

Re: NewSQL overview

#7

Post by drapper » Fri, Feb 13, 2015, 1:52 PM UTC

xtrumanx wrote: post #3

For anyone else too lazy to read the slides to find out what NewSQL is, this is slide 13: NewSQL: definition "A DBMS that delivers the scalability and flexibility promised by NoSQL while retaining the support for SQL queries and/or ACID, or to improve performance for appropriate workloads." 451 Group

Better one is on the next slide:

- SQL as a primary interface

- ACID support for transactions

- Non-locking architecture

- High per-node performance

- Scalable, shared nothing architecture

Michael Stonebraker

Re: NewSQL overview

#8

Post by alexandre_m » Fri, Feb 13, 2015, 2:56 PM UTC

ddorian43 wrote: post #2

Is there any open-source/free newsql db ?

CockroachDB is promising.

https://github.com/cockroachdb/cockroach

Inspired by Google Spanner.

Re: NewSQL overview

#9

Post by jrullmann » Fri, Feb 13, 2015, 3:12 PM UTC

ddorian43 wrote: post #2

Is there any open-source/free newsql db ?

Take a look at the Overview slide of the presentation, where this information is listed for each database the author discussed: http://image.slidesharecdn.com/newsql-2015-150213024325-conv...

Re: NewSQL overview

#10

Post by moondowner » Fri, Feb 13, 2015, 3:28 PM UTC

The first time I ran into the NewSQL terminology was when I checked out CockroachDB: https://github.com/cockroachdb/cockroach

'A Scalable, Geo-Replicated, Transactional Datastore' written in Go, influenced by Google's Spanner.