Tag: SQL
Couchbase Intro for MongoDB Developers and NoSQL Experts
Six thousand years ago, the Sumerians invented writing for transaction processing — Gray & Reuter By 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...
Keshav Murthy
April 25, 2020
Manage Time-To-Live (TTL) Documents with Couchbase N1QL
There is one feature that I wish had existed with RDBMS, and that is the built-in support for setting a Time-To-Live value for the data records. In NoSQL databases, the support of TTL is very common. NoSQL databases were designed...
Binh Le
April 14, 2020
Couchbase for Oracle Developers – Part 4 : Data types
Link to the series home page: https://www.couchbase.com/blog/couchbase-oracle-developers-part-2-architecture/ As part of data remodeling, while moving from the relational model to the JSON model, you’ll have to consider the data type mapping. In Oracle, you’ll have to create and declare the types...
Keshav Murthy
March 25, 2020
SQL to NoSQL – 7 Metrics to Compare Query Language
Organizations who want to take advantage of the many benefits of NoSQL document databases, often find that they have two challenges: How to convert their RDBMS schemas to leverage the schema-less document model. Learn a new API/Query to access the...
Binh Le
March 6, 2020
Infosys “OpenHack” Development Program Features Couchbase
Couchbase is expanding its partnerships with industry-leading global systems integrators and regional solution providers. Through these partnerships, Couchbase’s unique capabilities can be delivered to our global footprint of enterprise customers. We collaborate closely with our Strategic Alliance partner Infosys to...
Vikranth Dharamshi, Principal Partner Solution Architect, Couchbase
September 9, 2019
Analytics Explain Plan – Part 1
Co-author: Till Westmann, Senior Director, Engineering Introduction Couchbase Analytics is the “newest kid on the block” amongst all the services available in Couchbase Server. The new service is providing rapid time to insight in many use cases like ship to...
Sachin Smotra, Director Product Management, Couchbase
September 4, 2019
It’s SQL. Again.
[crayon-6620de2f05876128036092/] [crayon-6620de2f05879482540145/] — In the spirit of Alexander Pope and Sir John Squire.
Keshav Murthy
August 31, 2019
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,...
Keshav Murthy
August 7, 2019
N1QL (Query) Basic Order of Execution.
Query syntax is limited. Queries are unlimited. Predicate pushdown, group by pushdown, offset pagination, keyset pagination, join optimization, search optimization, we’ve discussed it all. Still, it’s important to understand the default, simple — albeit slow — execution flow of the...
Keshav Murthy
June 8, 2019
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...
Keshav Murthy
May 26, 2019
N1QL Index Advisor: Improve Query Performance, Productivity
As application developers, your main focus is to design the most efficient queries for your application. You want to ensure the integrity of the data that your application pushes to the database, and construct the most efficient queries to retrieve...
Binh Le
May 9, 2019
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...
Keshav Murthy
May 5, 2019