Tag: SQL

Lower TCO With SQL++ FLATTEN_KEYS For JSON Arrays

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

June 15, 2022
Couchbase vs. MongoDB: NoSQL Misconceptions Part 2

Couchbase vs. MongoDB: NoSQL Misconceptions Part 2

Misconceptions about NoSQL have been around as long as NoSQL itself. It’s always good to get different perspectives, and so I’m continuing this blog series about NoSQL misconceptions, specifically when it comes to two of the top document database companies...

June 10, 2022
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
Derive Insights From Azure Blob Storage Using External Analytics Collections

Derive Insights From Azure Blob Storage Using External Analytics Collections

Following the support for Analytics external collections for Amazon Web Services (AWS) Simple Storage Service (S3) in the Couchbase Server 6.6 release, Couchbase is excited to announce the forthcoming support and general availability for Azure Blob Storage for external Analytics...

Couchbase vs. MongoDB: NoSQL Misconceptions Part 1

Misconceptions about NoSQL have been around for as long as NoSQL itself. It’s always good to get different perspectives, so I’m kicking off a new blog series about NoSQL misconceptions, specifically when it comes to two of the top document...

June 3, 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
Creating Python and JavaScript User Defined Functions For Geospatial Queries

Creating Python and JavaScript User Defined Functions For Geospatial Queries

SQL++ (or Couchbase N1QL) queries can access data stored in your Couchbase cluster in a variety of ways. There are situations where having the business logic as part of your data queries can also be beneficial. SQL++ supports this with...

April 20, 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...

Reuse SQL Queries between Server & Mobile App Databases

Reuse SQL Queries between Server & Mobile App Databases

As we all know, code is expensive to maintain—the more complex the code, the higher the cost of maintaining it. Therefore, since the beginning of time, software developers have worked very hard to achieve the goal of code reusability. Couchbase...

March 14, 2022
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...

Top Blogs of 2021 – Part 1

Top Blogs of 2021 – Part 1

What a whirlwind 2021 has been! We’ve had a lot of major events take place this year including debuting on Nasdaq, debuting in the Gartner Magic Quadrant, launching Couchbase Server 7.0, and of course, introducing Couchbase Capella. It’s been a...

December 27, 2021
Data Validation with the Eventing Service

Data Validation with the Eventing Service

Data Validation is an interesting topic to cover for a NoSQL technology, purely down to the fact that the core principles of the system revolve around a “schema-less” architecture. For many years, SQL and schemas have controlled application data, ensuring...