Author
Lower TCO With SQL++ FLATTEN_KEYS For JSON Arrays
An RDBMS with a well-established schema serves well when application functions remain static. While this rigid structure can guarantee stability, it doesn’t lend itself to fast-changing business requirements. Organizations today must consider modernizing their application infrastructure and moving from RDBMS...
Binh Le
June 15, 2022
Traverse Hierarchy with SQL++ User-defined functions (UDFs)
User-defined functions (UDFs) are a feature that exist in most RDBMS. Whether it is Oracle PL/SQL (Procedural Language for SQL), SQL Server T-SQL (Transact-SQL), PL/pgSQL (Procedural Language/PostgreSQL), or other variants, all these languages have the general characteristics of providing a...
Binh Le
May 26, 2022
Introducing Charts for Query & Analytics
Couchbase Web Console is a browser-based, interactive graphical user interface that supports the management of all services in Couchbase Server. It also includes the Query & Analytics Workbench that allows developers to interactively manipulate Couchbase data, explore the schema, and...
Binh Le
December 9, 2021
5 Steps to Streamline Your N1QL Queries & Migrate to Collections
If you’re looking to migrate your data from a relational database to NoSQL, then now’s a better time than ever. The recent release of Couchbase 7.0 introduced Scopes and Collections – a new way to organize your JSON data. More...
Binh Le
August 16, 2021
Here’s How the Index Service Got Upgraded for Couchbase 7.0
Index builds and updates just got a big performance upgrade with the introduction of Scopes and Collections in Couchbase 7. The Couchbase Server 7.0 release introduces the separation of Bucket data into logical Scopes and Collections on top of the...
Binh Le
August 12, 2021
Boost Query Efficiency with Cost-Based Optimization in Couchbase
Database users of every kind have come to expect cost-based optimization for their queries. It’s a standard feature of all traditional relational databases (RDBMS), but there hasn’t yet been a cost-based optimizer (CBO) for NoSQL document databases. That is, until...
Binh Le
August 10, 2021
The N1QL Query Language Now Supports Distributed ACID Transactions
Multi-document, distributed ACID transactions are now available in Couchbase as part of the N1QL query language. Couchbase introduced ACID transactions in its v6.5 release with the Couchbase SDKs, and this has now been extended to the Couchbase N1QL Query Service...
Binh Le
August 2, 2021
Couchbase’s Cost-Based Optimizer for JSON is patent pending
With NoSQL databases proving their worth over the legacy SQL approach, the next question is inevitably “how do we optimize our processes as much as possible?” Many databases have used static Rule-Based Optimization (RBO) to optimize workloads – but this...
Binh Le
October 29, 2020
N1QL Turns Five
As any parent of a five year old can attest, time flies when you’re having fun. Where did all the time go? That’s kind of how we feel with N1QL, the SQL for JSON query language. Today, thousands of developers,...
Binh Le
October 6, 2020
Announcing Flex Index With Couchbase
Flex Index Explained What is a Flex Index? One of the key tasks of a database engine is how to efficiently manage the search and retrieval of the data therein. The efficiency and balance between resource consumption and performance are...
Binh Le
August 12, 2020
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...
Binh Le
June 8, 2020
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...
Binh Le
April 25, 2020