NuoDB vs Mongo DB.

Hi,

you can find a very detailed comparison on vschart for this.

This should put you in the right direction.

Cheers

tks.

but what is right is they both NoSQL and scaleable in RAM  ? the web site : https://www.nuodb.com/ keep saying it is the distributed SQL databae for next generation of banking, why is it ? MongoDB can't ?

some company even use MS SQL and NuoDB  together to do virtual banking ! no other choice other than NuoDB ?

usually what is the admin tools and backup/restore and monitoring tools for NuoDB ?

we can also see this:

https://www.nuodb.com/product/database-comparison

https://www.nuodb.com/sites/default/files/graphics/conceptual-diagrams/database-decision-tree_text_FINAL.jpg

can't see why nuodb is the choice of virtual banking and other DB can't ! the community edition can only do 3x cluster, so people have to pay anyway.

and it seems saying nuoDB is the only DB can do scale out on demand ! MongoDB cna't do it ?

only NuoDB can offer Reliability and performance along with elasticity ??? seems not possible ? then all traditional DB like Oracle should die ?

NuoDB is structured SQL DB, and what nuoDB can't do when compare with MS SQL, Oracle traditional database?

Suggestion: Open another question describing your application asking for design assistance.

For example, if MariaDB/MySQL is tuned correctly, where all I/O occurs through memory buffers, then MariaDB/MySQL runs near same speed as NoSQL databases, with the flexibility of SQL.

Unless your application consists of only simple hashed lookups (one key -> one value), usually best to stick with MariaDB tuned to run out of memory.

In fact, if your data access pattern is write heavy, you can use the MyRocks Storage Engine. This Engine runs Facebook. It's highly unlikely you'll ever approach Facebook level traffic, so even with write heavy access, using MariaDB will likely be faster (or close) to NoSQL products.

"Suggestion: Open another question describing your application asking for design assistance."

sorry, nothing like this, just an high level overview.

"For example, if MariaDB/MySQL is tuned correctly, where all I/O occurs through memory buffers, then MariaDB/MySQL runs near same speed as NoSQL databases, with the flexibility of SQL.".

e..g innoDB buffer pool big enough ?

" usually best to stick with MariaDB tuned to run out of memory."

how to make MariaDB put tables in the memory ?memory optimized table ?

"In fact, if your data access pattern is write heavy, you can use the MyRocks Storage Engine."

knew that, but how can we split the traffic into innoDB and MyRocks separate ? ProxySQL ?

"using MariaDB will likely be faster (or close) to NoSQL products."

but it is not only about speed, is about NoSQL is for unstructured data, right?

the reason I ask is, I have question on why a virtual bank company, new started, use 4 x different types of DB, PostgreSQL, MSSQL, MariaDB, NuoDB( for all new project, in this direction), MongoDB !80% of their DB is on PostgreSQL, and few of them use MS SQL and MariaDB, and MonogDB and NuoDB is the feature.

so I am not sure why has this usage too ! probably application driven !  MongoDB and NuoDB all RAM DB but one no structure and one structure SQL based.

"For example, if MariaDB/MySQL is tuned correctly, where all I/O occurs through memory buffers, "

you seems has a lot of experience on MariaDB, what kind of tuning involve to make MariaDB faster than MongoDB ?