Tag: N1QL
FIRST CLASS SQL for FULL-TEXT SEARCH
Over time, the database industry has realized full-text search and SQL are two sides of the same coin. Text search needs further query processing, query processing needs text search to efficiently filter for text patterns. The SQL databases have added...
Analyze This: MongoDB & Couchbase Analytics.
The purpose of computing is insight, not numbers. — Richard Hamming The spiral of running the business, analyzing what to change & what to change to, and then changing the business is an eternal one. Do the right analysis, your...
Index Advisor Service for N1QL (June refresh)
This is our June drop for Index Advisor service for N1QL after fixing some of the bugs that were found after our last refresh in May. We plan to keep improvising the Index Advisor service(What is it?). The fixes in...
Implement FHIR REST server with Couchbase
This is a follow up to my previous post that covered the topic of FHIR Data Model with Couchbase N1QL. In this blog, I will discuss the topic of how to implement the FHIR Search REST API Server over the...
Couchbase Data Platform Partner Training
Thanks to Binh Le, Jon Strabala & Keshav Murthy for contributing to this post. Introduction Couchbase provides a wide variety of self paced online courses as well as in-person (or virtual) training through both Couchbase’s training portal. Advent of open...
FHIR Data Model with Couchbase N1QL
Couchbase is a JSON database that has now become an alternative to the traditional RDBMS. It has achieved this, not only by providing the industry-leading Key-Value store and the same query and ACID translation capabilities that organizations have come to...
Couchbase Intro for MongoDB Developers and NoSQL Experts
Six thousand years ago, the Sumerians invented writing for transaction processing — Gray & Reuter By any measure, MongoDB is a popular document-oriented JSON database. In the last dozen years, it has grown from its humble beginnings of a single...
Manage Time-To-Live (TTL) Documents with Couchbase N1QL
There is one feature that I wish had existed with RDBMS, and that is the built-in support for setting a Time-To-Live value for the data records. In NoSQL databases, the support of TTL is very common. NoSQL databases were designed...
Flexible Query & Indexing for Flexible JSON Model.
Use N1QL when you’re in a JSON pickle. — Confucius For the JSON data model, the advice is to think of collections as tables, JSON document as denormalized rows and field names as columns – roughly. All this holds in...
Index Advisor Service for N1QL (March refresh)
This is our March drop for Index Advisor service for N1QL after fixing some of the bugs that were found after our last refresh in Feb. We plan to keep improvising the Index Advisor service(What is it?). The fixes in...
FTS and N1QL: Better MongoDB in Operator Performance 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://www.couchbase.com/blog/couchbase-oracle-developers-part-2-architecture/ 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...