Structured Query Language (SQL) was originally designed as an intuitive query language for relational data stores. NoSQL, relatively nascent in comparison, still requires compatibility with SQL as many BI tools and applications understand it. Couchbase supports its own query language, N1QL, which extends SQL for querying JSON documents stored in Couchbase Server. The Simba Couchbase ODBC and JDBC drivers enable users to “have their cake and eat it too” by enabling users to leverage both SQL and N1QL. One of the ways it achieves this is with the Collaborative Query Execution (CQE) feature offered by SimbaEngine X. This article explains how Simba Couchbase drivers use CQE, by leveraging the similarities between SQL and N1QL, to ensure optimal performance.
by Nowrin Anwar Joyita