Tag: SQL

Couchbase for Oracle Developers — Part 4 : Data types

Link to the series home page: https://blog.couchbase.com/couchbase-oracle-developers-part-1-overview/ As part of data remodeling, while moving from the relational model to the JSON model, you’ll have to consider the data type mapping. In Oracle, you’ll have to create and declare the types...

/ March 25, 2020

SQL to NoSQL – 7 Metrics to Compare Query Language

Organizations who want to take advantage of the many benefits of NoSQL document databases, often find that they have two challenges: How to convert their RDBMS schemas to leverage the schema-less document model. Learn a new API/Query  to access the...

/ March 6, 2020

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

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-5e7eed30f1cbd617075148/] [crayon-5e7eed30f1cc3354234550/] — In the spirit of Alexander Pope and Sir John Squire.

/ August 31, 2019

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

/ August 7, 2019

N1QL (Query) Basic Order of Execution.

Query syntax is limited. Queries are unlimited. Predicate pushdown, group by pushdown, offset pagination, keyset pagination, join optimization, search optimization, we’ve discussed it all. Still, it’s important to understand the default, simple — albeit slow — execution flow of the...

/ June 8, 2019

The Unreasonable Effectiveness of SQL in NoSQL Databases: A Comparative Study.

The business applications have requirements: take customer orders, deliver customer orders, track shipping, generate inventory report, end of the day/month/quarter business report, generate business dashboards and more.  These requirements evolve slowly. They remain even when you choose a NoSQL database....

/ May 26, 2019

N1QL Index Advisor: Improve Query Performance and Productivity

As application developers, your main focus is to design the most efficient queries  for your application. You want to ensure the integrity of the data that your application pushes to the database, and construct the most efficient queries to retrieve...

/ May 9, 2019

Approaches to Query Optimization in NoSQL.

A man returned home after walking around the globe for eleven years.  Next day, when he told his wife he’s going to the corner store, she asked him: “are you taking the short route or the long one?”. Queries can...

/ May 5, 2019