Author
JSON is Case Sensitive. You Don’t Have to Be.
In this post, Couchbase demonstrates why JSON is case sensitive in certain fields and how to work with this sensitivity. Find helpful examples and more here.
Simple dataviz with N1QL and Google Sheets.
Do whatever it takes to present the data to aid analysis and thinking. — Edward Tufte How do you create graphs like these if you don’t already have some ready-made cool dataviz tool? You can run queries to wrangle the...
Less Is More: Why Use a Cost-Based Optimizer?
Couchbase includes a cost-based optimizer (CBO). Learn how having a CBO improves query performance and how to implement it.
It’s SQL. Again.
[crayon-68bea8b271c63929347441/] [crayon-68bea8b271c67065200856/] — In the spirit of Alexander Pope and Sir John Squire.
Primary Uses for Couchbase Primary Index
What is the Couchbase Primary Index? The primary index scan provides you with the “full table scan” equivalent for all the documents from start to finish.
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,...
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...
The Unreasonable Effectiveness of SQL in NoSQL Databases
Compare and contrast SQL language support in Cassandra, CosmosDB, Couchbase, and MongoDB via their respective implementations.Â
Approaches to Query Optimization in NoSQL
The NoSQL and query optimization tool evaluates the possibilities and selects the efficient plan. Find out what to do when you don’t have a good optimizer.
Search & Rescue: 7 Reasons N1QL Developers Use Search
Couchbase N1QL/SQL can call full-text search queries, providing powerful benefits described here including fuzzy and natural language matching.
The Unreasonable Effectiveness of SQL
Visit the post to learn why SQL is called a successful 4th generation language. Check out Data Models and it's implementation.
N1QL: To Query or To Analyze?
Note: This recommendation note was written in collaboration with Till Westmann and Mike Carey, who lead the Couchbase analytics R&D. [Part 2 of this article by Even Pease is at: https://www.couchbase.com/blog/part-2-n1ql-to-query-or-to-analyze/] Couchbase’s Query and Analytics Services both support N1QL (SQL...
Top Posts
- New Enterprise Analytics Brings Next Generation JSON Analytics to...
- What is Prompt Engineering? Techniques, Examples, and Tools
- Data Modeling Explained: Conceptual, Physical, Logical
- What are Embedding Models? An Overview
- What Is Data Analysis? Types, Methods, and Tools for Research
- Data Analysis Methods: Qualitative vs. Quantitative Techniques
- How I Built a Plant RAG Application with Couchbase Vector Search...
- Supercharge Your RAG application With Couchbase Vector Search and...
- Relational vs. Non-Relational Databases: Features and Benefits
