Results for: mongodb
Window functions in Couchbase Analytics
Co-author: Till Westmann, Senior Director, Engineering The bits for Couchbase 6.5, the upcoming release of Couchbase Server, are now available. The Analytics service, which supports efficient parallel query processing, has added support for support for window functions defined in the...
Cost Based Optimizer for Couchbase N1QL (SQL for JSON)
Authors & Engineering Team: Bingjie Miao, Keshav Murthy, Marco Greco, Prathibha Bisarahalli. Couchbase, Inc. A rule-based optimizer knows rules for everything and cost for nothing – Oscar Wilde Abstract Couchbase is a distributed JSON database. It provides distributed data processing,...
Comparing Postgres JSONB With NoSQL
The reality is that databases are converging, and in the last few years, it is becoming even more difficult to point what are the best scenarios for each datastore without a deep understanding of how things work under the hood. ...
The Unreasonable Effectiveness of SQL in NoSQL Databases
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...
Approaches to Query Optimization in NoSQL
A man returned home after walking around the globe for eleven years. Next day, when he told his wife he’s going to the corner store, she asked him: “are you taking the short route or the long one?”. Queries can...
Search & Rescue: 7 Reasons N1QL Developers Use Search
People don’t want a four key index. They need a four-ms response. Ted Levitt Application development is demanding. Each application is trying to progress on behalf of the customer — searching for the right product or the right form, ordering,...
Why “Born in the Cloud” NoSQL Services Won’t Always Win
NoSQL isn’t all equal Couchbase has been recognized as a Leader in NoSQL by Forrester Research in their recent report ‘The Forrester Wave™: Big Data NoSQL, Q1 2019.’ Forrester identified the 15 most significant companies in the category, then evaluated...
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...
Couchbase in Telecom: MegaFon, Russia
Egor Kovalchuk is a deployment manager in MegaFon, one of the largest telecommunication companies in Russia. His career in telecom spans more than a decade. Egor’s team is in charge of developing, integrating, and monitoring multiple business systems and applications...
N1QL & SEARCH: Leverage Full-Text Search (FTS) Index in N1QL
With Couchbase v6.5, Full-Text Search is now integrated into the Couchbase N1QL query construct. Customers can now leverage FTS indexes directly with N1QL. This provides developers a single API to combine N1QL exact predicate matching and FTS powerful searching. The...
It’s the Workload, Stupid!
As an application architect, eventually, you’d have to choose the database or database as a service (DBaaS) to power your newest application or a micro-service. Selecting one of the databases among relational databases was easier. The use cases were roughly...
Using YCSB to Benchmark JSON Databases
Bruce Lindsay once said, “There are three things important in the database world: Performance, Performance, and Performance”. Most enterprise architects know, as we progress in database features and architectures, it’s important to measure performance in an open way so they can compare...