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 bachelor's degree in Computer Science and Engineering from the University of Mysore, India, holds ten US patents and has three US patents pending.

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

/ November 3, 2020

N1QL Transactions : An Elastic and Scalable Distributed Transactions

SQL is the only 22nd-century language available for developers today. ABSTRACT In relational database systems, SQL is more than a declarative query language. It includes procedural language (T-SQL, PL/SQL, etc) and defines transactions and its semantics.  SQL as a query...

/ October 14, 2020
Bay farm island, Alameda, California

Arrays in JSON: Modeling, Querying and Indexing Performance

Array is THE difference between the relational model and the JSON model.   — Gerald Sangudi Abstract JSON array gives you flexibility in the type of elements,  number of elements, size of the elements, and the depth of the elements.  This...

/ August 4, 2020

Comparing MQL features in MongoDB 4.4 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...

/ July 31, 2020

FIRST CLASS SQL for FULL-TEXT SEARCH

Over time, the database industry has realized full-text search and SQL are two sides of the same coin.  Text search needs further query processing, query processing needs text search to efficiently filter for text patterns.   The SQL databases have added...

/ July 7, 2020

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

/ June 23, 2020

Example Architectures for Data Intensive Applications.

…a drawing should have no unnecessary lines and a machine no unnecessary parts.  —William Strunk Jr., Elements of Style In the book Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems, Martin Kleppmann has written about traits...

/ June 14, 2020

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