{"id":9601,"date":"2020-11-03T17:55:44","date_gmt":"2020-11-04T01:55:44","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=9601"},"modified":"2025-06-13T18:43:59","modified_gmt":"2025-06-14T01:43:59","slug":"datatabase-query-halloween-problem-n1ql","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/datatabase-query-halloween-problem-n1ql\/","title":{"rendered":"Halloween Problem: Solution in N1QL."},"content":{"rendered":"

Learning SQL is easy; Implementing SQL, not so much.<\/p><\/blockquote>\n

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.\u00a0 SQL made the relational database easy, accessible, and successful. SQL may be easy to write, but its implementation hides a lot of complexity.\u00a0 From the days of System R<\/a> to NoSQL systems, all of us implementing SQL and SQL inspired languages like N1QL<\/a>, have to learn the rules, requirements to ensure the declarative query language continues its extraordinary effectiveness and correctness.<\/a>\u00a0 One such problem is the Halloween Problem<\/a>.\u00a0 I’ll describe the problem briefly here.\u00a0 I highly recommend reading its history<\/a> in the IEEE Annals of the history of computing – second link in the references section below.<\/p>\n

The Problem:<\/strong><\/h5>\n

Consider a simple table and index:<\/p>\n

CREATE TABLE t (empid int primary key, salary int);\r\nCREATE INDEX i1 ON t(salary);<\/pre>\n
Imagine you’ve loaded some data and the index i1 looks like this. The index entry has the numeric value for the salary, followed by the rowid.<\/p>\n
\"\"<\/a><\/p>\n
Now, in the spirit of giving more to people who have it, we want to increase the salary of all the employees who have (salary > 50).<\/p>\n
UPDATE t SET salary = salary + 100 WHERE salary > 50; <\/strong><\/p>\n
Query Plan: <\/strong>Here’s the general plan for executing the query.\u00a0 In this case, we’ll assume the query planner will use the index i1 to qualify the rows) to update.<\/p>\n
\"\"<\/a><\/p>\n
Query Execution:\u00a0<\/strong>Once this starts to start executing, data rows will be updated and the index will get updated synchronously. the index will look something like this. Each qualified key get updated one by one [we’re scanning from left to right]. Here’s the state of the index after updating the initial four entries: (55->155, 84=>184, 99=>199, 100=>200)<\/span><\/p>\n
\"\"<\/a><\/p>\n
Let’s see what happens after a couple of more changes.\"\"<\/a><\/p>\n
As we move to the next item[155,r2] gets updated\u00a0 again\u00a0 to[255,r2].\u00a0 This will repeat updating multiple keys multiple times. That violates the set manipulation rules where the intention is to take the set in the table t and update the qualified salaries by 100.<\/p>\n
\"\"<\/a><\/p>\n
An additional manifestation of the Halloween problems.<\/p>\n
INSERT INTO t SELECT * FROM t WHERE balance > 0;<\/strong><\/p>\n
Solution:<\/strong><\/h5>\n
In traditional RDBMS (e.g. Informix), the solution is fairly straight forward.\u00a0 For each of the DML statements resulting in mutation, it keeps a sorted list of rowids updated within this statement.\u00a0 Before we update a row, we check to see if this row is already updated and skip it.\u00a0 For simple updates with limited range scans, this read overhead is hardly noticeable. For larger updates, the maintenance of a large list in memory can be an issue.\u00a0 Typically, the list is spilled out to disk once it gets sufficiently large.<\/p>\n
Couchbase N1QL & GSI solution:\u00a0<\/strong><\/h5>\n
Couchbase is a distributed database with multiple services.\u00a0 The query service<\/span>\u00a0creates the e<\/span>xecution plan and executes it.\u00a0 Here’s the overview of the solution.<\/span><\/p>\n
Let’s look at the query when we have an index: <\/span>CREATE INDEX i1 ON t<\/span>(<\/span>salary<\/span>)<\/span>\"\"<\/a>N1QL will create a plan like this: UPDATE statement, the plan will use the index scan to identify the documents to update, fetch the document, update it and write it back.\u00a0 It’s important to note that this update is done to documents synchronously.\u00a0 These changes will flow through DCP and index updates happen asynchronously.\u00a0 Even then, for larger updates, the scan of the index and updates can be going on while the updates are done to the index being scanned.<\/p>\n
\"\"<\/a><\/p>\n
 <\/p>\n
Now, let’s look at the index scan itself.\u00a0 Indexes can be built on Memory-Optimized Index (MOI) or Standard Secondary (using Plasma Storage Engine). Both of these have the concept of snapshot. Instead of updating the values in-place, we use MVCC to provide the required functionality and performance.<\/p>\n
Here are a couple of things from the Nitro<\/a> paper.<\/p>\n
Immutable snapshots:<\/strong> Concurrent writers add or remove items into the skiplist. A snapshot of the current items can be created to provide a point-in-time view of the skiplist. This is useful for providing repeatable stable scans. Users can create and manage multiple snapshots. If an application requires atomicity for a batch of skiplist operations, it can apply a batch of operations and create a new snapshot. Changes would be invisible until a new snapshot is created. <\/em><\/p>\n
Fast and low overhead snapshots:<\/strong> Readers of the skiplist use a snapshot handle to perform all lookup and range queries. An indexer application typically requires many snapshots to be created every second for servicing index queries. So the overhead of creating and maintaining a snapshot should be minimal for servicing the high rate of snapshot generation. Nitro snapshots are very cheap and is an O(1) operation.\u00a0<\/em><\/p>\n
To implement these, the index uses two things: BornSnapshot version and DeadSnapshot version. Let’s look at the state of the initial index.<\/p>\n

\n\"\"<\/a>As the changes, change in the values simply add new nodes in the skiplist with updated values, bornSnapshot and deadSnapshot values.\"\"<\/a><\/p>\n
Using the bornSnapshot and deadSnapshot versions on the entries, index scanner (aka iterator) simply chooses the right entries to qualify index entries to read.\u00a0 That’s how it creates a snapshot and will not read the previously updated value in the same scan.\u00a0 This not only provides stable scans, but it also avoids the Halloween problem altogether! This also eliminates the need for updated-documentid list maintenance within the query service. Good engineering addressed the problem; great engineering avoids the problem altogether. :-)<\/p>\n
\"\"<\/a><\/p>\n
Finally, a Halloween art by David Haikney<\/a>, VP of Couchbase Customer Support!\u00a0Watch the full video!<\/strong><\/p>\n
\n
Happy Halloween \u2066to all \u2066@couchbase<\/a>\u2069 ! \ud83c\udf83 pic.twitter.com\/vqwW7sk3v6<\/a><\/p>\n
\u2014 David Haikney (@dhaikney) October 31, 2020<\/a><\/p><\/blockquote>\n
<\/h5>\n
References<\/strong><\/h5>\n
    \n
  1. Halloween Problem<\/a><\/li>\n
  2. A well-intentioned query and the Halloween Problem<\/a>, Los Alamos National Laboratory, Anecdotes, IEEE Annals of the History of Computing<\/li>\n
  3. Couchbase Global Secondary Index<\/a><\/li>\n
  4. Nitro<\/a>: A Fast, Scalable In-Memory Storage Engine for NoSQL Global Secondary Index<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"
    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.\u00a0 SQL made the relational database easy, […]<\/p>\n","protected":false},"author":55,"featured_media":9603,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1821,1816,1812],"tags":[1261,1725,1385],"ppma_author":[8929],"class_list":["post-9601","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-couchbase-architecture","category-couchbase-server","category-n1ql-query","tag-json","tag-nosql-database","tag-rdbms"],"acf":[],"yoast_head":"\nHalloween Problem: Solution in N1QL. - The Couchbase Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.couchbase.com\/blog\/datatabase-query-halloween-problem-n1ql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Halloween Problem: Solution in N1QL.\" \/>\n<meta property=\"og:description\" content=\"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.\u00a0 SQL made the relational database easy, […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/datatabase-query-halloween-problem-n1ql\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-11-04T01:55:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-14T01:43:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/11\/Halloween-Problem-Solution-in-N1QL..png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"627\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Keshav Murthy\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@rkeshavmurthy\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Keshav Murthy\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/datatabase-query-halloween-problem-n1ql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/datatabase-query-halloween-problem-n1ql\/\"},\"author\":{\"name\":\"Keshav Murthy\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/c261644262bf98e146372fe647682636\"},\"headline\":\"Halloween Problem: Solution in N1QL.\",\"datePublished\":\"2020-11-04T01:55:44+00:00\",\"dateModified\":\"2025-06-14T01:43:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/datatabase-query-halloween-problem-n1ql\/\"},\"wordCount\":990,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/datatabase-query-halloween-problem-n1ql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/11\/h2-scaled.jpg\",\"keywords\":[\"JSON\",\"NoSQL Database\",\"RDBMS\"],\"articleSection\":[\"Couchbase Architecture\",\"Couchbase Server\",\"SQL++ \/ N1QL Query\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/datatabase-query-halloween-problem-n1ql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/datatabase-query-halloween-problem-n1ql\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/datatabase-query-halloween-problem-n1ql\/\",\"name\":\"Halloween Problem: Solution in N1QL. - The Couchbase Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/datatabase-query-halloween-problem-n1ql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/datatabase-query-halloween-problem-n1ql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/11\/h2-scaled.jpg\",\"datePublished\":\"2020-11-04T01:55:44+00:00\",\"dateModified\":\"2025-06-14T01:43:59+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/datatabase-query-halloween-problem-n1ql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/datatabase-query-halloween-problem-n1ql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/datatabase-query-halloween-problem-n1ql\/#primaryimage\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/11\/h2-scaled.jpg\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/11\/h2-scaled.jpg\",\"width\":2560,\"height\":912},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/datatabase-query-halloween-problem-n1ql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Halloween Problem: Solution in N1QL.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"name\":\"The Couchbase Blog\",\"description\":\"Couchbase, the NoSQL Database\",\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\",\"name\":\"The Couchbase Blog\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"width\":218,\"height\":34,\"caption\":\"The Couchbase Blog\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/c261644262bf98e146372fe647682636\",\"name\":\"Keshav Murthy\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/4e51d72fc07c662aa791316deafffac4\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/af74df754db27152971d0aed2f323ead5a1f9fe5afd0209af91e12e784451224?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/af74df754db27152971d0aed2f323ead5a1f9fe5afd0209af91e12e784451224?s=96&d=mm&r=g\",\"caption\":\"Keshav Murthy\"},\"description\":\"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 eleven US patents and has four US patents pending.\",\"sameAs\":[\"https:\/\/blog.planetnosql.com\/\",\"https:\/\/x.com\/rkeshavmurthy\"],\"url\":\"https:\/\/www.couchbase.com\/blog\/author\/keshav-murthy\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Halloween Problem: Solution in N1QL. - The Couchbase Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.couchbase.com\/blog\/datatabase-query-halloween-problem-n1ql\/","og_locale":"en_US","og_type":"article","og_title":"Halloween Problem: Solution in N1QL.","og_description":"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.\u00a0 SQL made the relational database easy, […]","og_url":"https:\/\/www.couchbase.com\/blog\/datatabase-query-halloween-problem-n1ql\/","og_site_name":"The Couchbase Blog","article_published_time":"2020-11-04T01:55:44+00:00","article_modified_time":"2025-06-14T01:43:59+00:00","og_image":[{"width":1200,"height":627,"url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/11\/Halloween-Problem-Solution-in-N1QL..png","type":"image\/png"}],"author":"Keshav Murthy","twitter_card":"summary_large_image","twitter_creator":"@rkeshavmurthy","twitter_misc":{"Written by":"Keshav Murthy","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/datatabase-query-halloween-problem-n1ql\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/datatabase-query-halloween-problem-n1ql\/"},"author":{"name":"Keshav Murthy","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/c261644262bf98e146372fe647682636"},"headline":"Halloween Problem: Solution in N1QL.","datePublished":"2020-11-04T01:55:44+00:00","dateModified":"2025-06-14T01:43:59+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/datatabase-query-halloween-problem-n1ql\/"},"wordCount":990,"commentCount":0,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/datatabase-query-halloween-problem-n1ql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/11\/h2-scaled.jpg","keywords":["JSON","NoSQL Database","RDBMS"],"articleSection":["Couchbase Architecture","Couchbase Server","SQL++ \/ N1QL Query"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/datatabase-query-halloween-problem-n1ql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/datatabase-query-halloween-problem-n1ql\/","url":"https:\/\/www.couchbase.com\/blog\/datatabase-query-halloween-problem-n1ql\/","name":"Halloween Problem: Solution in N1QL. - The Couchbase Blog","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/datatabase-query-halloween-problem-n1ql\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/datatabase-query-halloween-problem-n1ql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/11\/h2-scaled.jpg","datePublished":"2020-11-04T01:55:44+00:00","dateModified":"2025-06-14T01:43:59+00:00","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/datatabase-query-halloween-problem-n1ql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/datatabase-query-halloween-problem-n1ql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.couchbase.com\/blog\/datatabase-query-halloween-problem-n1ql\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/11\/h2-scaled.jpg","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/11\/h2-scaled.jpg","width":2560,"height":912},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/datatabase-query-halloween-problem-n1ql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Halloween Problem: Solution in N1QL."}]},{"@type":"WebSite","@id":"https:\/\/www.couchbase.com\/blog\/#website","url":"https:\/\/www.couchbase.com\/blog\/","name":"The Couchbase Blog","description":"Couchbase, the NoSQL Database","publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.couchbase.com\/blog\/#organization","name":"The Couchbase Blog","url":"https:\/\/www.couchbase.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","width":218,"height":34,"caption":"The Couchbase Blog"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/c261644262bf98e146372fe647682636","name":"Keshav Murthy","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/4e51d72fc07c662aa791316deafffac4","url":"https:\/\/secure.gravatar.com\/avatar\/af74df754db27152971d0aed2f323ead5a1f9fe5afd0209af91e12e784451224?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/af74df754db27152971d0aed2f323ead5a1f9fe5afd0209af91e12e784451224?s=96&d=mm&r=g","caption":"Keshav Murthy"},"description":"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 eleven US patents and has four US patents pending.","sameAs":["https:\/\/blog.planetnosql.com\/","https:\/\/x.com\/rkeshavmurthy"],"url":"https:\/\/www.couchbase.com\/blog\/author\/keshav-murthy\/"}]}},"authors":[{"term_id":8929,"user_id":55,"is_guest":0,"slug":"keshav-murthy","display_name":"Keshav Murthy","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/af74df754db27152971d0aed2f323ead5a1f9fe5afd0209af91e12e784451224?s=96&d=mm&r=g","author_category":"","last_name":"Murthy","first_name":"Keshav","job_title":"","user_url":"https:\/\/blog.planetnosql.com\/","description":"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."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/posts\/9601","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/users\/55"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/comments?post=9601"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/posts\/9601\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/media\/9603"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/media?parent=9601"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/categories?post=9601"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/tags?post=9601"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/ppma_author?post=9601"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}