Keshav Murthy | Couchbase Blog

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 bachelors degree in Computer Science and Engineering from the University of Mysore, India, holds ten US patents.

Introduction to Couchbase for MongoDB Developers and Experts.

Six thousand years ago, the Sumerians invented writing for transaction processing — Gray & Reuter By any measure, MongoDB is a popular document-oriented JSON database. In the last dozen years, it has grown from its humble beginnings of a single...

/ April 25, 2020

Flexible Query & Indexing for Flexible JSON Model.

Use N1QL when you’re in a JSON pickle. — Confucius For the JSON data model, the advice is to think of collections as tables, JSON document as denormalized rows and field names as columns – roughly. All this holds in...

/ April 13, 2020

Couchbase for Oracle Developers – Part 4 : Data types

Link to the series home page: 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

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

/ March 23, 2020

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

/ January 7, 2020

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

/ September 7, 2019

It’s SQL. Again.

[crayon-5edc2f1a7eab6609497418/] [crayon-5edc2f1a7eabb873867153/] — In the spirit of Alexander Pope and Sir John Squire.

/ August 31, 2019

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

/ August 22, 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