northscalefeed

Primary Uses for Couchbase Primary Index.

A couple of frequently asked questions on N1QL for query service: When do we actually use a primary index? Why the index advisor does not recommend the primary index when that may the only choice? Read on… Couchbase is a distributed database. It supports flexible data model using JSON. Each document in a bucket will have a user-generated unique document key. This uniqueness is enforced during the inserting or updating of the data. Here’s an example document.select meta().id, travel from `travel-sample` travel where type = 'airline' limit...

northscalefeed

Search and Rescue: 7 Reasons for N1QL (SQL) developers to use Search

People don’t want a four key index.  They need a four-ms response.Ted LevittApplication development is demanding. Each application is trying to progress on behalf of the customer — searching for the right product or the right form, ordering, canceling, shipping, checking the status, etc. The typical query and B-Tree based databases and infrastructure are suitable for developing many of the modules. Still, there are cases where SQL & B-Tree based searching is ineffective in meeting your SLA. Here are the seven problems you’d...

northscalefeed

The Unreasonable Effectiveness of SQL

Two score and five years ago two young IBM researchers brought forth on databases, a new language, conceived in relational, dedicated to the proposition that data can be manipulated declaratively and easily.   In the years since Don Chamberlin and Ramond Boyce published SEQUEL: A Structured English Query Language relational model 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...