This 51-page report explores the query performance of three database languages: MySQL, N1QL, and a MongoDB query.
All databases have the goal of providing the most powerful data manipulation mechanisms, so that applications can efficiently query the data managed. In this regard, traditional relationship database management systems utilize SQL as a standard to access data. On the other hand, most of the NoSQL databases rely on a proprietary language or APIs.
This report provides a comparative analysis of MySQL, N1QL, and MongoDB query. The three database languages were used to query nine different business scenarios across seven metrics.
The metrics against which the scenarios were compared include:
The comparative results are supported by 17 figures, 11 tables, and 23 code samples.