Company
Date Published
Author
Vinai Amble
Word count
869
Language
English
Hacker News points
None

Summary

On April 5, 2022, Couchbase was granted a second patent by the US Patent and Trademark Office for its innovative approach to optimizing document-oriented database queries on arrays, specifically through a process known as Cost-based Optimization (CBO). This feature, which has been available since Couchbase Server 7.1 and Couchbase Capella 7.0, signifies a significant advancement in bringing CBO to NoSQL databases, allowing Couchbase to offer improved performance and resource efficiency in executing queries. Unlike Rule-based Optimization (RBO), which relies on predefined rules and can be inefficient, CBO evaluates millions of query plans to select the most cost-effective execution path, thereby reducing memory, disk usage, and latency. This advancement sets Couchbase apart as the only document database provider currently offering CBO for NoSQL queries, emphasizing its commitment to technical excellence and innovation in document database management, which is crucial for enterprises relying on high-performance data handling.