Keshav Murthy | Couchbase Blog

Author

All posts by Keshav Murthy

Keshav Murthy is a Vice President at Couchbase R&D. Previously, he was at MapR, IBM, Informix, Sybase, with more than 20 years of experience in database design & development. He lead the SQL and NoSQL R&D team at IBM Informix. He has received two President's Club awards at Couchbase, two Outstanding Technical Achievement Awards at IBM. Keshav has a bachelor's degree in Computer Science and Engineering from the University of Mysore, India, holds ten US patents and has three US patents pending.

JSON is Case Sensitive. You Don’t Have to Be.

JSON is Case Sensitive. You Don’t Have to Be.

A RoSe by any other case would smell as sweet. William Shakespeare You must have learned capitalization rules in your grammar school, but the real-world search is not so sensitive to capitalization. Charles de Gaulle uses lower case for the...

Keshav Murthy March 23, 2020
Simple dataviz with N1QL and Google Sheets.

Simple dataviz with N1QL and Google Sheets.

Do whatever it takes to present the data to aid analysis and thinking.  — Edward Tufte How do you create graphs like these if you don’t already have some ready-made cool dataviz tool? You can run queries to wrangle the...

Keshav Murthy January 7, 2020
Less Is More: Why Use a Cost-Based Optimizer?

Less Is More: Why Use a Cost-Based Optimizer?

Less is more.  — Ludwig Mies van der Rohe There 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...

Keshav Murthy September 7, 2019
It’s SQL. Again.

It’s SQL. Again.

[crayon-6679d02914200230304748/] [crayon-6679d02914204980629300/] — In the spirit of Alexander Pope and Sir John Squire.

Keshav Murthy August 31, 2019
Primary Uses for Couchbase Primary Index

Primary Uses for Couchbase Primary Index

A couple of frequently asked questions on N1QL for query service: When do we actually use a primary index? Why the index advisor does not recommend the primary index when that may the only choice? Read on… Couchbase is a...

Keshav Murthy August 22, 2019
Cost Based Optimizer for Couchbase N1QL (SQL for JSON)

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

Keshav Murthy August 7, 2019
N1QL (Query) Basic Order of Execution.

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

Keshav Murthy June 8, 2019
The Unreasonable Effectiveness of SQL in NoSQL Databases

The Unreasonable Effectiveness of SQL in NoSQL Databases

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

Keshav Murthy May 26, 2019
Approaches to Query Optimization in NoSQL

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

Keshav Murthy May 5, 2019
Search & Rescue: 7 Reasons N1QL Developers Use Search

Search & Rescue: 7 Reasons N1QL Developers Use Search

People don’t want a four key index.  They need a four-ms response. Ted Levitt Application development is demanding. Each application is trying to progress on behalf of the customer — searching for the right product or the right form, ordering,...

Keshav Murthy April 22, 2019
The Unreasonable Effectiveness of SQL

The Unreasonable Effectiveness of SQL

Two score and five years ago two young IBM researchers brought forth on databases, a new language, conceived in relational, dedicated to the proposition that data can be manipulated declaratively and easily.   In the years since Don Chamberlin and Ramond...

Keshav Murthy April 2, 2019
N1QL: To Query or To Analyze?

N1QL: To Query or To Analyze?

Note: This recommendation note was written in collaboration with Till Westmann and Mike Carey, who lead the Couchbase analytics R&D. [Part 2 of this article by Even Pease is at: https://www.couchbase.com/blog/part-2-n1ql-to-query-or-to-analyze/] Couchbase’s Query and Analytics Services both support N1QL (SQL...

Keshav Murthy January 24, 2019