Tag: RDBMS
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...
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...
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...
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...
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
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...
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...
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,...
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...
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...
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
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...