Couchbase Bets On Standard NoSQL Query Language - InformationWeek
IoT
IoT
Comments
Couchbase Bets On Standard NoSQL Query Language
Newest First  |  Oldest First  |  Threaded View
Charlie Babcock
50%
50%
Charlie Babcock,
User Rank: Author
6/5/2015 | 3:03:20 PM
It's not a standard...yet; can it become one?
DanielaF, understood that JSON object is an unstructured collection of data, that was never presumed otherwise. But the way the system operator decides to collect JSON documents and nest them lends an ordered element to a collection of JSON data that SQL, extended with Nest and Unnest, can support. Or at least that is my understanding of what Couchbase is trying to say. I have no doubt some worthy technology was not included in this discussion but that's true of many stories that we write. The Linkedin discussion is a good addition to these comments.  
DanielaF120
50%
50%
DanielaF120,
User Rank: Apprentice
6/5/2015 | 12:30:44 PM
Long thread on this topic on Linkedin, good to read
https://www.linkedin.com/grp/post/54257-6010072547398336516
DanielaF120
50%
50%
DanielaF120,
User Rank: Apprentice
6/5/2015 | 12:21:46 PM
Re: Charlie bets on extending SQL to JSON data
Charlie, SQL is a wonderful, well defined language. However, it's semantics is defined on flat, homogeneous, non-ordered relations. JSON is ANYTHING BUT a bag of flat, honogeneous, non-ordered relations. It's nested, irregular and has ordered arrays. SQL has NO SEMANTICS defined on JSON structures. SQL doesn't know how to process those.

Saying that we should process JSON with SQL is like saying that we should be processing COBOL structures with LISP. It's a contradition in terms.
DanielaF120
50%
50%
DanielaF120,
User Rank: Apprentice
6/5/2015 | 12:05:24 PM
and BTW, scientific dishonesty...
About the scientific honesty of Yannis Papakonstantinou.....Here is a piece of email that circulated yesterday on plenty of mailing lists.(not by me..) Yannis, as an good academic as he is, should have known better then to ignore the state of the art. BTW, JSONiq is a query language for querying JSON, used already in a variety of products. jsoniq.org It comes with a schema for JSON jsound.org

========================================


In may 2014 3 researchers write a paper entitled

The SQL++ Unifying Semi-structured Query Language, and an Expressiveness Benchmark of SQL-on-Hadoop, NoSQL and NewSQL Databases

which has 65 references to JSONiq.


In April 2015 the same 3 researchers published


The SQL++ Query Language: Configurable, Unifying and Semi-structured

which has zero references to JSONiq.


Does anybody have any suggestions as to roundabout when they started getting funding from Couchbase? 

++++++++++++++++++++++++++++++++++++++
DanielaF120
50%
50%
DanielaF120,
User Rank: Apprentice
6/5/2015 | 11:57:48 AM
cheap technology built by amateurs
This is cheap technology build by amateurs to say the least. Before being a "standard"... this query language, like ANY programming language, has to have a specification, written down, that describes what the semantics of the language is. I have been asking for one since this marketing campaign started and I have been answered "Dana, Please consider real world deployments, not academic endeavors....This is still an inexact science." Damn it... a query language is an .... "inexact science " !???. As in... you get "inexact answers "to your "inexact query" ? .....And you want users to do business with those answers !??? What the heck of a world do we live in ????? (BTW, is there such thing as an "inexact science !?")
Charlie Babcock
50%
50%
Charlie Babcock,
User Rank: Author
6/3/2015 | 6:40:18 PM
Charlie bets on extending SQL to JSON data
Not to put too fine a point on it, Ilya Geller, but Structured Query Language is based on mathematical set theory and relational algebra. It's reliability and precision have been proven many times. To successfully extend SQL into JSON-based data is pretty smart, and likely to prove extremely worthwhile inside the enterprise. I'll leave it to others to rule on the rest of your claims below.
billappleton
50%
50%
billappleton,
User Rank: Apprentice
6/3/2015 | 2:07:18 PM
Single query language for SQL and NoSQL
The open source DreamFactory project introduced a common query language for all modern SQL and NoSQL databases a few years ago -- plus user management and role-based access controls so that the queries can be safely used from a client device.


How Enterprises Are Attacking the IT Security Enterprise
How Enterprises Are Attacking the IT Security Enterprise
To learn more about what organizations are doing to tackle attacks and threats we surveyed a group of 300 IT and infosec professionals to find out what their biggest IT security challenges are and what they're doing to defend against today's threats. Download the report to see what they're saying.
Register for InformationWeek Newsletters
White Papers
Current Issue
IT Strategies to Conquer the Cloud
Chances are your organization is adopting cloud computing in one way or another -- or in multiple ways. Understanding the skills you need and how cloud affects IT operations and networking will help you adapt.
Video
Slideshows
Twitter Feed
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.
Flash Poll