Tag: N1QL
FTS and N1QL: Improving Performance when Querying Multiple Arrays
Introduction Couchbase Full Text Search (FTS) is a great fit for indexing multiple arrays and executing queries with multiple filter predicates in arrays. In this article, I’ll demonstrate the advantages of using FTS over GSI (Global Secondary Index) for array...
Couchbase for Oracle Developers – Part 4 : Data types
Link to the series home page: https://blog.couchbase.com/couchbase-oracle-developers-part-1-overview/ As part of data remodeling, while moving from the relational model to the JSON model, you’ll have to consider the data type mapping. In Oracle, you’ll have to create and declare the types...
SQL to NoSQL – 7 Metrics to Compare Query Language
Organizations who want to take advantage of the many benefits of NoSQL document databases, often find that they have two challenges: How to convert their RDBMS schemas to leverage the schema-less document model. Learn a new API/Query to access the...
IN List Handling Improvements in Couchbase Server 6.5
Introduction IN list is commonly used in N1QL queries. Couchbase Server 6.5 introduces a couple of enhancements in handling of IN list in N1QL queries. Handling of Large IN List Before Couchbase Server 6.5 N1QL handles IN list evaluation at...
Index Advisor Service for Couchbase N1QL(Feb refresh)
This is our Feb drop for Index Advisor service after fixing some of the bugs that were found. We plan to keep improvising the Index Advisor service(What is it?). The fixes in Index Advisor that you would normally see in...
Couchbase 6.5 – RMS for Indexing Service
Couchbase 6.5 release includes an extensive list of Enterprise Grade Database Query capability that allows customers to expand the adoption of NoSQL database into traditional database applications. The release has added transactional capability, Analytical Window functions, user defined JS functions,...
Simple dataviz with N1QL and Google Sheets.
Do whatever it takes to present the data to aid analysis and thinking. — Edward Tufte How do you create graphs like these if you don’t already have some ready-made cool dataviz tool? You can run queries to wrangle the...
Index Advisor Service for Couchbase N1QL(SQL for JSON)
We are excited to announce the release of : Couchbase Index Advisor Service http://index-advisor.couchbase.com Yet Another service? Why? We released N1QL(SQL for JSON) a few years ago- so that you could use SQL to retrieve and manipulate JSON data. But...
Migrating Data from MongoDB to Couchbase, Part 2
Prolog The previous article provided details on how to migrate a data set from MongoDB to Couchbase. This article will show you how to use the Couchbase SDK to access the data via a Java console application. Code snippets show...
Testing N1QL workloads with Apache JMeter
One of the key features that Couchbase provides for querying JSON data is a N1QL language. N1QL allows users to access and modify the contents of their JSON documents with familiar SQL statements. Quite often, during development phase of a...