Tag: SQL
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...
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...
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...
Creating Python and JavaScript User Defined Functions For Geospatial Queries
SQL++ 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 User Defined Functions...
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
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...
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
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...
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...
A Story of How Multimodel Databases Can Reduce Data Sprawl (Told in the Pixar Style)
Pixar uses a consistent structure to develop all of its stories. It basically follows the pattern of: Once upon a time, there was… Every day,… One day,… Because of that,… Because of that,… Until finally,…” I thought I would borrow...
Get Started with Couchbase Capella in a 3 Easy Steps
Couchbase Capella makes it faster, easier and more affordable for developers and teams to get started with Couchbase. With the recent launch of Couchbase Capella, the award-winning database more accessible than ever. This article is a quick guide on how...