Author: Planet NoSQL

Feed: Planet NoSQL. Author: Keshav Murthy. “Apps without search is like Google homepage without the search bar.” It’s hard to design an app without a good search.  These days, it’s also hard to find a database without a built-in search. MySQL to NoSQL, Sybase to Couchbase, every database has text search support — built-in like Couchbase or via integration to Elastic — as is the case in Cassandra. Unlike SQL, text search functionality isn’t standardized. Every application needs best of the breed search, but not every database provides the same text search functionality. It’s important to understand the available feature, ... Read More

Feed: Planet NoSQL. Author: Keshav Murthy. After listening to a book, I usually write what I remember. In this book however, Seth's summary second chapter is worth remembering and repeating. I'm obliged to simply state the original. Rest of the book is explaining these with use cases, reasonings. I highly recommend the book if you're into marketing or changing the world, for that matter.Changing the world, caring about stories in people's head -- has a religious tone to marketing. I've always believed religions have done the best marketing. Even scientific evidence is unable to change all the minds and stories.When ... Read More

Feed: Planet NoSQL. Author: Keshav Murthy. Use golf analogy when explaining to executives.Use a car analogy for all others.  — Confucius. The purpose of window functions is to translate the business reporting requirements declaratively and effectively to SQL so query performance and developer/business-analyst efficiency improve dramatically. I’ve seen real-world reports and dashboards go from hours to minutes, minutes to seconds after using window functions.  Query size decreases from 40-pages to a few pages. Back in the ‘90s, Redbrick database really understood the business use case and created a new layer of functionality to do business reporting that included ranking, running ... Read More

Feed: Planet NoSQL. Author: Keshav Murthy. As an application architect, eventually, you’d to choose the database or database service to power your newest application or a micro-service. Selecting one of the databases among relational databases was easier.  The use cases were roughly divided into OLTP and OLAP (decision support). The workload differences between OLTP and OLAP were well known. OLTP workloads consist of short transactions on few random rows, expecting millisecond responses on pre-compiled queries; OLAP workloads consist of data loads, long-running queries scanning millions of rows of a fact table of a star/snowflake schema. Each had the performance benchmark ... Read More

Feed: Planet NoSQL. Author: Keshav Murthy. Now, this is not the end. It is not even the beginning of the end. But it is, perhaps, the end of the beginning. — Winston Churchill Updating data is usually not the end, but usually a progress of a workflow. Shipping follows ordering; inventory update follows shipping; adjusting credit follows returning;  The next step in the process is required to act to keep the workflow going. The workflows can be simple with few steps or complex with hundreds of steps.  Business Process Management (BPM) is an industry by itself. Couchbase 5.5 introduced Evening service. Developers ... Read More

Feed: Planet NoSQL. Author: Keshav Murthy. Here's what I remember from John Chambers' impressive 2014 keynote at Cisco Live. Not all of his predictions have come true. IoT/IoE has a long way to go to become a multi-trillion dollar industry. Cisco didn't turn out to be like IBM, HP or Dell, but much better than all of them. What I remember the most is what happened after the speech. As the crowd was leaving, I saw a group congregating near the stage. They were are all surrounding John Chambers. He was in no hurry to go anywhere. People were talking ... Read More

Feed: Planet NoSQL. Author: Keshav Murthy. Today, I finished listening to the book: Principles: Life and Work.  Ray Dalio writes and talks in a familiar voice, but with the authority of a self-made billionaire who made also billions to others. You can see Ray's the genuine enthusiasm and interest to teach what he has learned -- mistakes, lessons, and principles. Core ideas for managers (my summary): 1. Every manager is an organizational engineer. Understand, architect and debug the organization to engineer outcomes for the company & community. 2. Focus on getting to the true picture of reality and face it ... Read More

Feed: Planet NoSQL. Author: Keshav Murthy. [Reposting of the article published with Sitaram Vemulapalli on DZone.  https://dzone.com/articles/a-deep-dive-into-couchbase-n1ql-query-optimization] SQL is the declarative language for manipulating data in a relational database system. N1QL is the declarative language for JSON data and metadata. Similar to SQL, N1QL has DML statements to manipulate JSON data: SELECT, INSERT, UPDATE, DELETE, MERGE, EXPLAIN. It also introduces a new statement, INFER, which samples the data to describe the schema and show data samples. Execution of a N1QL query by the engine involves multiple steps. Understanding these will help you to write queries, design for performance, tune query engine efficiently. The ... Read More

Feed: Planet NoSQL. Author: Keshav Murthy. Location-based services like Yelp, Uber, and Foursquare are ubiquitous. This article shows an easy way to use Couchbase N1QL to issue spatial queries and use GSI index to speed up those queries to meet your SLAs. Whether you just finished a long SF Giants extra innings win or spent the afternoon running up and down the Lombard Street in San Francisco, sometimes, you just want a cold one, really fast. When you search on your app, you expect the answer quickly, with ratings, distance, and all. Thanks to GPS, triangulation, and IP-based location detection, apps can determine your current location. Google does ... Read More

Feed: Planet NoSQL. Author: Keshav Murthy. [Reposting of my article at DZone: https://dzone.com/articles/more-than-like-efficient-json-search-with-couchbas] Enterprise applications require both exact search (equality, range predicate) and pattern search (LIKE or text search). The B-Tree based indexes in databases help perform an exact search in milliseconds. Pattern search is a whole different problem. Predicates of patterns (name LIKE "%turin%") will scan the whole index — unsuitable for application use. Recognizing the need for speed, we've introduced a TOKENS() functions in Couchbase 4.6 which retuns an array of tokens from each field or document. We then index the array using the array indexing in Couchbase N1QL. This transforms the pattern search problem ... Read More