Tag: SQL

Index Advisor Supports Self-Verification and Index Pushdowns

Index Advisor Supports Self-Verification and Index Pushdowns

Index advisor for N1QL Statement (ADVISE statement ) is officially released in Couchbase Server 6.6. It is designed to make best efforts to provide global secondary index recommendation for each keyspace in the query which is better than all the...

Chang Liu January 19, 2021
NoSQL Is Dead, Long Live NoSQL

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

Keshav Murthy December 16, 2020
Building Customer-Obsessed Database Applications

Building Customer-Obsessed Database Applications

Customer obsession is a powerful concept for any company. Whether your customers are internal or external users of your platform – every experience should be timely and meaningful. Customer 360 NoSQL database development is a powerful approach to delivering these...

Tyler Mitchell December 1, 2020
Halloween Problem: Solution in N1QL.

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

Keshav Murthy November 3, 2020
N1QL Turns Five

N1QL Turns Five

As any parent of a five year old can attest, time flies when you’re having fun. Where did all the time go? That’s kind of how we feel with N1QL, the SQL for JSON query language. Today, thousands of developers,...

Binh Le October 6, 2020
Announcing Flex Index With Couchbase

Announcing Flex Index With Couchbase

Flex Index Explained What is a Flex Index? One of the key tasks of a database engine is how to efficiently manage the search and retrieval of the data therein. The efficiency and balance between resource consumption and performance are...

Binh Le August 12, 2020
Remote Links: Analyze Trends with Couchbase Analytics

Remote Links: Analyze Trends with Couchbase Analytics

Introduction to remote links Couchbase is excited to announce its new Remote Links Analytics Service feature in the latest Couchbase Server 6.6 release. Remote links enable real-time operational analytics to obtain and analyze data from multiple Couchbase data clusters and...

Till Westmann August 12, 2020
External Datasets: Accessing AWS S3 in Couchbase Analytics

External Datasets: Accessing AWS S3 in Couchbase Analytics

Introduction to external datasets Couchbase is very excited to announce its new “External Datasets” Analytics Services feature in the latest Couchbase Server 6.6 release. External datasets empower customers to access externally stored data in real-time from Amazon Web Services (AWS)...

Idris Motiwala August 12, 2020
Comparing MongoDB MQL with N1QL features in Couchbase 6.5

Comparing MongoDB MQL with N1QL features in Couchbase 6.5

This is a short note reviewing the MongoDB MQL language features highlighted in the release blog: MongoDB 4.4: User-Driven Engineering. Ready for You.  MongoDB 4.4 release has added a number of features for the MQL language. Couchbase released 6.5 earlier...

Keshav Murthy July 31, 2020
Analyze This: MongoDB & Couchbase Analytics.

Analyze This: MongoDB & Couchbase Analytics.

The purpose of computing is insight, not numbers.  — Richard Hamming The spiral of running the business, analyzing what to change & what to change to, and then changing the business is an eternal one. Do the right analysis, your...

Keshav Murthy June 23, 2020
Couchbase Analytics: Customers’ Moments of Truth Revealed!

Couchbase Analytics: Customers’ Moments of Truth Revealed!

Introduction I recently joined Couchbase’s product team to lead Couchbase Analytics. This Analytics Service enables our customers to measure near-real time business operations, derive insights from data, and drive agile decisions to expand business growth. Within my first few weeks...

Idris Motiwala June 16, 2020
FHIR Data Model with Couchbase N1QL

FHIR Data Model with Couchbase N1QL

Couchbase is a JSON database that has now become an alternative to the traditional RDBMS. It has achieved this, not only by providing the industry-leading Key-Value store and the same query and ACID translation capabilities that organizations have come to...

Binh Le April 25, 2020