Category: N1QL / Query
Infosys Completes “OpenHack” Solution Development Program with Couchbase
Couchbase is expanding its partnerships with industry-leading global systems integrators and regional solution providers. Through these partnerships, Couchbase’s unique capabilities can be delivered to our global footprint of enterprise customers. We collaborate closely with our Strategic Alliance partner Infosys to...
Less is More: Why Cost Based Optimizer?
Less is more. — Ludwig Mies van der Rohe This is no truer statement on the goals of a query optimizer. Do less: Less memory, less CPU, less disk, less IO, less instructions, less partitions, less overflow. Less everything for...
Analytics Explain Plan – Part 1
Co-author: Till Westmann, Senior Director, Engineering Introduction Couchbase Analytics is the “newest kid on the block” amongst all the services available in Couchbase Server. The new service is providing rapid time to insight in many use cases like ship to...
It’s SQL. Again.
[crayon-5e2d3897b995a820595540/] [crayon-5e2d3897b9960104779741/] — In the spirit of Alexander Pope and Sir John Squire.
Index Advisor For Query Workload
Overview As the second feature of Index Advisor released in Couchbase server 6.5 (Developer Preview), Advisor function extends the scope from advising on single query to providing index recommendations for query workload and support on session handling. In this article,...
Window functions in Couchbase Analytics
Co-author: Till Westmann, Senior Director, Engineering The bits for Couchbase 6.5, the upcoming release of Couchbase Server, are now available. The Analytics service, which supports efficient parallel query processing, has added support for support for window functions defined in the...
Advanced Filtering with XDCR 6.5
Customers use XDCR for various use cases from high availability to data locality to disaster recovery to cloud migration and hybrid cloud deployments. To meet these use cases, there are a number of circumstances where they would want to replicate...
Index Advisor for N1QL Query Statement
Overview Index advisor is introduced in Couchbase server 6.5 as a developer preview feature. It targets at providing secondary index recommendation to help DBAs and developers optimize N1QL query performance. This version is rule-based, in which the index candidates will...
Couchbase 6.5 – Scan Consistency in Analytics
Since the GA back in Nov 2018, Couchbase Analytics is being used in multiple verticals for rapid time to insight – ad-hoc analysis by a payment provider, shopping cart analysis by an e-tailer, next gen ticket booking engine by a...
Cost Based Optimizer for Couchbase N1QL (SQL for JSON)
Authors & Engineering Team: Bingjie Miao, Keshav Murthy, Marco Greco, Prathibha Bisarahalli. Couchbase, Inc. A rule-based optimizer knows rules for everything and cost for nothing – Oscar Wilde Abstract Couchbase is a distributed JSON database. It provides distributed data processing,...