Author
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...
Binh Le
April 14, 2020
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...
Binh Le
March 6, 2020
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,...
Binh Le
January 20, 2020
How to use N1QL to migrate Oracle data into Couchbase
Getting the Couchbase server to run on your PC or Mac involves a few simple steps to download the software and spin up a cluster with all the Couchbase services that you need (https://docs.couchbase.com/server/6.0/getting-started/start-here.html). Sample buckets are available with the...
Binh Le
July 9, 2019
A Preview of Couchbase 6.5 N1QL Features
Couchbase 6.5 release is one of the largest release content wise for Couchbase. For N1QL Query service, the focus for us is to bring Enterprise Database functionalities to the Couchbase Database. Expanding N1QL with additional functions to support Enterprise Application...
Binh Le
June 22, 2019
N1QL Index Advisor: Improve Query Performance, Productivity
As application developers, your main focus is to design the most efficient queries for your application. You want to ensure the integrity of the data that your application pushes to the database, and construct the most efficient queries to retrieve...
Binh Le
May 9, 2019
Couchbase’s N1QL Query Shatters the Limits of MongoDB™
As NoSQL adoption grows, developers and enterprises alike require a general purpose database to replatform their mission-critical applications and services. These databases are no longer used only by backend services that need sub-second access to the data, but also by...
Binh Le
March 25, 2019
Get a Bigger Picture with N1QL Window Functions and CTE
Whether it is a personal need to understand your spending pattern from looking at the bank transactions, or seeking to improve the sales performance in your organization by looking at the sales activities, the real insights are only visible with...
Binh Le
March 12, 2019
N1QL query with Self Referencing Hierarchy
A data construct that often appears in business application is the hierarchical data structure. Hierarchy captures the parent-child relationship often between the same object. For instance a company structure captures the reporting line between employees. Business organization captures the relationship...
Binh Le
February 17, 2019
Relational to NoSQL – CRM Application Data Visibility
As a follow up to my previous webcast on the subject of Relational to NoSQL database where I discussed that we are in the third phase of the NoSQL database adoption, the “Broad Replatforming” of Enterprise Application. I want to provide...
Binh Le
January 21, 2019
N1QL & SEARCH: Leverage Full-Text Search (FTS) Index in N1QL
With Couchbase v6.5, Full-Text Search is now integrated into the Couchbase N1QL query construct. Customers can now leverage FTS indexes directly with N1QL. This provides developers a single API to combine N1QL exact predicate matching and FTS powerful searching. The...
Binh Le
December 11, 2018
A SQL++ Implementation
Summary With the proliferation of JSON databases in recent years, a new query language SQL++ has begun to emerge that could standardize on how to access these data sources. In fact the language has been around for a number of...
Binh Le
November 25, 2018