The goal of all modern databases is to enable applications to efficiently query their data. Traditional relational databases use SQL for query, while most leading NoSQL databases like MongoDB and Couchbase use a proprietary language or API that emulates SQL.
In this report, Altoros provides a comparative analysis of the MongoDB query language, Couchbase’s SQL for JSON, and SQL (using MySQL as the reference). Altoros tested each query language against nine different business scenarios ranging from simple queries to complex aggregations. For each scenario, Altoros compares the relative power and simplicity of the three languages by rating them against the same set of criteria.