Non-SQL Agnostic Resilience Level

Question

It seems to me that at the end of the day most NoSQL databases are in their main repositories of keys / values, which means that you must create a layer that can be an agnostic of a NoSQL database.

This level will only use CRUD operations (put, set, delete), but it will reveal more complex functions, and you can switch the base database with minimal effort, be it Mongo, Redis, Cassandra, etc.

Will building something like this be of value to many people, and does it already exist?

thanks

Answer 1

There kundera and DataNucleus

Answer 2

NuoDB is an elastically scalable SQL / ACID database that uses the Key / Value model for storage. Today it runs on top of Amazon S3 (as well as standard file systems) and can support any KV store in principle. At the moment, the access method is SQL, but the system can easily support other languages ​​and data access methods, if this is a general requirement.

Barry Morris, NuoDB Inc.

Answer 3

UnQL stands for Unstructured Query Language. It is an open query language for JSON, semi-structured and document databases.

Answer 4

It is impossible to build such a thing.

As a thought experiment, I suggest taking, for example, Redis, MongoDB and Cassandra, and developing an API of this level.

These NoSQL solutions have completely different characteristics and serve different purposes. Trying to create a common API for them is how to create a common API for an SQL database, a spreadsheet document, a text file, and gmail.

As long as you can think of something, it will be completely pointless.

Different needs require different tools.

Answer 5

PlayOrm is another solution that is built on cassandra but has a pluggable interface for hbase, mongodb, etc. etc. 20/30 years ago, they said the same thing about RDBMS, but more and more united. I suspect that you will see a lot in the nosql database, as well as complement each other with sets of functions.

currently they have significantly different sets of functions, but at the core there is a set of operations that are very similar.

PlayOrm actually builds a query language that works with any noSQL provider, so S-SQL scalable SQL can work with cassandra, hadoop, etc. etc.

later, Dean