I was wondering if there are any standard languages or API's for accessing NoSQL databases (or at least BigData or Column store) databases?
Or do you have to learn the domain specific language for each vendor's contribution?
Traditional SQL developers looking warily at the rapid growth of NoSQL databases need not worry about transferring their skills to a new programming paradigm, as UnQL, the query language specification for NoSQL, features many of the same constructs as SQL itself.
Today, we have around 300 exabytes of unstructured data and it is increasing by the day. The predicted rise of unstructured data is at 56% per annum, compared to 12% for the structured data; this is why “NoSQL database" is believed to be the database of the future.
The REST API for Oracle NoSQL Database Cloud Service provides HTTPS endpoints to perform operations such as creating and deleting tables and indexes, populating and accessing data in tables, and accessing table usage metrics. You can view a list of all REST Endpoints.
NoSQL Databases in next 3–5 Years With many big companies like Amazon and Oracle providing NoSQL services the NoSQL database industry is about to grow in the coming years.
One potentially interesting one is AppScale which provides a unified API for HBase, Hypertable, MySQL Cluster, Cassandra, Voldemort, MongoDB, MemcacheDB and Redis. The API is defined by Google for the Google App Engine and is available for Java, Python and Go.
Relational database have the SQL language.
NoSQL databases are of different types: graph, columns, document. key value, etc.
They are all specific to handle. Maybe one type could have a unified language, but between them, that would be not so natural. So yes you have to use/learn the API for each type.
At another level, if you use java as a programming language, you may use spring data which proposes a set of libraries to access those databases. I did not use it but with it you will be able to compare the APIs between the different database types quite easily.
Then you have this question that seems well related to yours: Are there any NoSQL standards emerging?
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With