Category: MongoDB

Feed: Planet NoSQL. Author: Keshav Murthy. A drawing should have no unnecessary lines and a machine no unnecessary parts.                 William Strunk Jr., Elements of StyleIn the book Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems, Martin Kleppmann has written about traits and trade-offs for data infrastructure while designing modern applications. He has given an example architecture for a data system that combines several components. I used this example for the article Example Architectures for Data-Intensive Applications. That article explored just the Couchbase features and functions.A recent twitter thread talked about how AWS ... Read More

Feed: Planet NoSQL. Author: Keshav Murthy.  Use N1QL when you're in a JSON pickle. - ConfuciusFor the JSON data model, the general advice is to think of collections as tables, JSON documents as denormalized rows, and field names as columns — roughly. All this holds true in databases like Couchbase and MongoDB when recommendations are strictly followed. There are many reasons why users don't simply follow this key-value pair model all the time. Here are the main reasons:You want to convert a map/hashmap data structure where the keys are dynamic.Timeseries data when the field names are usually encoded timestamps.Dictionary based encoding.Existing document ... Read More

Feed: Planet NoSQL. Author: Keshav Murthy. Icons made by Freepik from www.flaticon.com(With SQL) Your app is sitting on a Ferrari-style compute engine.  — Lukas EderOver time, the database industry has realized 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 text search within them, albeit for a single node SMP systems.Couchbase Full-Text Search (FTS) is created with three main motivations:Transparently search across multiple fields within a documentGo beyond the exact matching of values by providing language based stemming, ... Read More

Feed: Planet NoSQL. Author: Keshav Murthy.  AbstractCouchbase is a distributed JSON database. It provides distributed data processing, high-performance indexing, and declarative query language N1QL along with search index, eventing, and analytics.N1QL (Non First Normal Query Language) is SQL for JSON. N1QL is to JSON what SQL is to relations. Developers say what needs to be done and the N1QL engine will figure out the "how." Current N1QL optimizer is a rule-based optimizer. Cost-Based Optimizer (CBO) for SQL was invented at IBM some 40 years ago and has been critical to the success of RDBMS and the developer/DBA productivity. NoSQL databases were invented some ... Read More

Feed: Planet NoSQL. Author: Keshav Murthy. DZone published [Apr-16-2019]Two score and five years ago, two young IBM researchers brought forth databases; a new language conceived in relational and dedicated to the proposition that data can be manipulated declaratively and easily. In the years since Don Chamberlin and Ramond Boyce published SQL: A Structured English Query Language, relational models and SQL have been extended and adapted to a significant number of technologies: OLTP, OLAP, object databases, object-relational databases, and even NoSQL. SQL has inspired query language design for non-relational databases: SQL for object databases, SQL for object-relational, SQL for XML, SQL for spatial, ... Read More

Feed: Planet NoSQL. Author: Keshav Murthy. DZone published [April, 20, 2020]The 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 NoSQL databases, challenges are addressed by a multitude of technologies and workarounds. Here are some of them:Copying the data with a different key to make the scans easier.Fetch all of the data needed to the application and then generate reportsLoad the data into relational databases to generate the report.Products provide workarounds ... Read More

Feed: Planet NoSQL. Author: Keshav Murthy.  Couchbase N1QL Transaction: An Elastic and Scalable Distributed TransactionMongoDB to Couchbase: An Introduction to Developers and ExpertsNew N1QL Features in Couchbase 7.0 [Video]NoSQL Is Dead, Long Live NoSQLHalloween Problem: Solution In N1QLArrays in JSON: Modeling, Querying and Indexing PerformanceExample Architectures for Data-Intensive ApplicationsFirst Class SQL for Full Text SearchFirst Class SQL for Full-Text SearchCreate the Right Index, Get the Right Performance, Part 2Create the Right Index, Get the Right Performance, Part 1Analyze This: MongoDB and Couchbase AnalyticsExample Architectures for Data-Intensive ApplicationsOn Par With Window FunctionsThe Unreasonable Effectiveness of SQL in NoSQL Databases: A Comparative...Flexible ... Read More

Feed: Planet NoSQL. Author: Keshav Murthy.  Six thousand years ago, the Sumerians invented writing for transaction processing - Gray and ReuterBy 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 lock per database to a modern multi-document transaction with snapshot isolation. MongoDB University has trained a large number of developers to develop the MongoDB database.There are many JSON databases now. While it's easy to start with MongoDB to learn NoSQL and flexible JSON schema, many customers choose Couchbase for performance, scale, and SQL. As you progress ... Read More

Feed: Planet NoSQL. Author: Keshav Murthy.   Dynamo accelerated the NoSQL revolution that’s driving the database industry.Recently, Amazon announced PartiQL - A SQL-Compatible Query Language for their flagship NoSQL database Amazon DynamoDB. This has brought the NoSQL “re:evolution” full circle. It’s wonderful to see the collaborative research from UCSD and Couchbase enabling the industry to move forward.NoSQL had a good run. MapReduce triggered it in 2004.  Dynamo and BigTable accelerated it in 2007. NoSQL meant no support for SQL, no support for multi-document transactions, no schema management, no procedural language, and many more No’s. However, NoSQL wasn’t a rebel without a cause. It promised reliability, scalability, and flexibility. Someone quipped: “If you are ... Read More

Feed: Planet NoSQL. Author: Keshav Murthy.   Array is THE difference between the relational model and the JSON model.   — Gerald SangudiAbstractJSON array gives you flexibility in the type of elements,  number of elements, size of the elements, and the depth of the elements.  This adds to the flexibility of operational JSON databases like Couchbase and MongoDB. The performance of queries with an array predicate in operational databases depends on the array indexes. However, the array indexes in these databases come with significant limitations. E.g. only one array key is allowed per index. The array indexes, even when created, can only process AND predicates efficiently ... Read More