Tag: RDBMS

Your Guide to User-Defined Functions in Couchbase Analytics

Your Guide to User-Defined Functions in Couchbase Analytics

User-defined functions put you in the driver’s seat when it comes to querying and analyzing your data. In the Couchbase ecosystem, user-defined functions (UDFs) are reusable and parameterizable SQL++ queries that enable you to modularize queries and increase code reuse...

August 26, 2021
Simplify Your Data Analysis with Scopes & Collections in Couchbase Analytics

Simplify Your Data Analysis with Scopes & Collections in Couchbase Analytics

Scopes and Collections aren’t just for organizing your data – now they can be used for your data analytics as well. As part of the Couchbase 7.0 release, support for Scopes and Collections has been extended to the Analytics Service...

August 13, 2021
Here’s How the Index Service Got Upgraded for Couchbase 7.0

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

August 12, 2021
Boost Query Efficiency with Cost-Based Optimization in Couchbase

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

August 10, 2021
Introducing Role-Based Access Control (RBAC) Security for Collections in Couchbase 7.0

Introducing Role-Based Access Control (RBAC) Security for Collections in Couchbase 7.0

Your data in Couchbase just got more secure. Couchbase Server 7.0 introduced Scopes and Collections to better map between relational and NoSQL data models. But the 7.0 release also includes some additional enhancements to strengthen the security of the data...

What is SQL? Navigating Databases for DBAs and Developers

What is SQL? Navigating Databases for DBAs and Developers

This article briefly introduces the essentials of SQL – its meaning, definition, and application to different database technologies. We introduce many different types of systems that use SQL – from databases to event stream processing. What is SQL?  Define: SQL...

April 7, 2021
NoSQL Is Dead, Long Live NoSQL

NoSQL Is Dead, Long Live NoSQL

Dynamo accelerated the NoSQL revolution that’s driving the database industry. Recently, Amazon announced PartiQL – A SQL-Compatible Query Language for their flagship NoSQL database Amazon DynamoDB. This has brought the NoSQL “re:evolution” full circle. It’s wonderful to see the collaborative research from UCSD and...

December 16, 2020
Halloween Problem: Solution in N1QL.

Halloween Problem: Solution in N1QL.

Learning SQL is easy; Implementing SQL, not so much. Halloween has come and gone. But, the tricks of the Halloween problem is here to stay! This has to be solved by databases every day.  SQL made the relational database easy,...

November 3, 2020
The Unreasonable Effectiveness of SQL

The Unreasonable Effectiveness of SQL

Two score and five years ago two young IBM researchers brought forth on databases, a new language, conceived in relational, dedicated to the proposition that data can be manipulated declaratively and easily.   In the years since Don Chamberlin and Ramond...

April 2, 2019
It’s the Workload, Stupid!

It’s the Workload, Stupid!

As an application architect, eventually, you’d have to choose the database or database as a service (DBaaS) to power your newest application or a micro-service. Selecting one of the databases among relational databases was easier.  The use cases were roughly...

November 14, 2018
Data Relationships – GraphQL & NoSQL in a Golang Application

Data Relationships – GraphQL & NoSQL in a Golang Application

By now I’m hoping that you’ve had a chance to look at my previous tutorial titled, Using GraphQL with Golang and a NoSQL Database, which is more or less a quick start for using GraphQL with Couchbase. There, we saw how...

A Guide to N1QL features in Couchbase 5.5: Special Edition

A Guide to N1QL features in Couchbase 5.5: Special Edition

N1QL was first released with Couchbase 4.0 in the fall of 2015.  After two and a half years, it’s great to release Couchbase 5.5 and this N1QL 5.5 feature booklet with it at the New York Couchbase Connect. This special...

May 10, 2018