Tag: JSON

Data Structures & Queries with Couchbase N1QL (SQL for JSON)

In the Data Structures for NoSQL Applications post, we used simplified JSON data access through native collections, maps, and more. This post demonstrates querying that data using higher-level N1QL queries, the SQL-based language for JSON. Developers can focus on managing...

/ January 27, 2021
JSON Data Modeling

A JSON Data Modeling Guide

When starting to learn about document databases, it’s nice to have a grip on JSON data modeling best practices. This will help you navigate the space and topics easier having an expanded vocabulary on the subject. Experience with a traditional...

/ January 20, 2021

NoSQL Is Dead, Long Live NoSQL

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

/ December 16, 2020

Cost Based Optimization with Couchbase JSON database

Couchbase Query Cost Based Optimization (CBO) was released as a Developer Preview in Couchbase 6.5, and it is now ready for GA with Couchbase v7.0. While CBO is a ubiquitous feature with traditional RDBMS, and that users have come to...

/ November 30, 2020

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

Text Analysis within a Full-Text Search Engine

Full-Text Search refers to techniques for searching text content within a document or a collection of documents that hold textual content. A Full-Text search engine examines all the textual content within documents as it tries to match a single search...

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 MongoDB MQL 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