Tag: N1QL

Second Patent Granted to Couchbase for Cost-Based Optimization

Second Patent Granted to Couchbase for Cost-Based Optimization

On April 5, 2022, the US Patent and Trademark Office granted a second patent to Couchbase for its novel approach to optimizing document-oriented database queries on arrays! This feature has been available since Couchbase Server 7.1 and Couchbase Capella 7.0...

June 6, 2022
Traverse Hierarchy with SQL++ User-defined functions (UDFs)

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...

May 26, 2022
Optimize Performance of External Analytics Collections in Couchbase

Optimize Performance of External Analytics Collections in Couchbase

It is crucial to plan for performance optimization and resource utilization now that there is support for external Couchbase Analytics collections (AWS S3 and Azure Blob Storage). External Couchbase Analytics collections read the data from external storage and do not...

Analyzing Statistics for Cost-Based Optimization in Couchbase 7.0

Analyzing Statistics for Cost-Based Optimization in Couchbase 7.0

Couchbase Server 7.0 (Enterprise Edition) introduced a Cost-Based Optimizer (CBO). Previous versions of Couchbase Server used a Rule-Based Optimizer (RBO). Couchbase Server has naturally evolved from RBO to CBO like most major relational database systems. The CBO uses cost estimates...

New RBAC Roles in Couchbase 7.0

New RBAC Roles in Couchbase 7.0

Couchbase Server version 7.0 introduces some important changes as part of the role-based access control (RBAC) authorization system.  Couchbase Server has allowed fine-grained access controls to the platform with RBAC for administrators since version 4.5 and all users since version...

Couchbase Catalogs for the SQL Server DBA

Couchbase Catalogs for the SQL Server DBA

In this post, we introduce System Catalogs in Couchbase and walk through a specific use case compared to SQL Server. If you’re like me, after 20 years of working with SQL Server, you tend to pick up on things that...

How Couchbase Simplifies Data Science (Part 1)

How Couchbase Simplifies Data Science (Part 1)

This post was co-authored by Karen Yuan, a High School Intern.  Data science extracts knowledge from data and applies that knowledge to solve problems. In the next two posts, we will learn how the Couchbase Data Platform can meet various...

Introducing Charts for Query & Analytics

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...

December 9, 2021
How to Denormalize Imported Documents from RDBMS Tables Using N1QL

How to Denormalize Imported Documents from RDBMS Tables Using N1QL

Data migration is full of challenges. While migrating from a relational database (RDBMS) like SQL Server or Oracle, your main challenge comes at the time of denormalizing migrated documents as per the target data models. With the introduction of scopes...

December 1, 2021
ML Meets NoSQL: Integrating Python User-Defined Functions with N1QL for Analytics

ML Meets NoSQL: Integrating Python User-Defined Functions with N1QL for Analytics

After conversations with our customers about the delay in obtaining analytical insights from their Python-based machine learning models, we set out to create a seamless pipeline from Python to Couchbase Analytics that returns faster insights in real time.  Introduction With...

, November 8, 2021
Announcing the 3.0 Beta Release for Mobile & Edge Computing

Announcing the 3.0 Beta Release for Mobile & Edge Computing

We’re pleased to announce the GA release of the Couchbase Lite 3.0 and Sync Gateway 3.0 platforms for mobile and edge computing solutions This major release makes great strides in the area of edge computing by expanding our edge device platform...

Get Started with Couchbase + Java [Developer Walkthrough]

Get Started with Couchbase + Java [Developer Walkthrough]

If you’re a developer who’s new to Couchbase, this article helps you get started. This weekly walkthrough series helps you understand the basics of connecting to Couchbase, shows you how to retrieve and modify data in Couchbase Server, how to...

October 7, 2021