Planet NoSQL

"There are three things important in the database world: Performance, Performance, and Performance." Bruce Lindsay   Let me start with a real world effect of right modeling on the application performance. Here's the except from a talk by Amadeus engineers on their customer experience management application (traveler loyalty app) which they migrated from an enterprise RDBMS to Couchbase.   Performance comparison between the enterprise RDBMS and Couchbase: "In terms of stability and performance, it was quite amazing as well. It has 100% availability for over one year and counting. In terms of performance, it was night and day compared to what we had before, basically these graphs give you response time percentile. First graph is our previous implementation using standard RDBMS. With RDBMS, in 99 percentile of the cases, we were responding in less than 4 seconds from the database. Now in Couchbase, for 99.9 percentile of the cases, we're responding in less than ...

    Array is   THE   difference between the relational model and the JSON model.   —   Gerald Sangudi Abstract JSON array gives you flexibility in the type of elements,  number of elements, size of the elements, and the depth of the elements.  This adds to the flexibility of operational JSON databases like Couchbase and MongoDB. The performance of queries with an array predicate in operational databases depends on the array indexes. However, the array indexes in these databases come with significant  limitations.  E.g. only one array key is allowed per index. The array indexes, even when created, can only process AND predicates efficiently.   The   Couchbase 6.6  release removes these limitations by using a built-in inverted index to be used to index and query arrays in N1QL.  This article explains the background and the workings of this novel implementation. Introduction An array is a basic type built into  JSON...