Category: Data Modeling
Get a Bigger Picture with N1QL Window Functions and CTE
Whether it is a personal need to understand your spending pattern from looking at the bank transactions, or seeking to improve the sales performance in your organization by looking at the sales activities, the real insights are only visible with...
N1QL query with Self Referencing Hierarchy
A data construct that often appears in business application is the hierarchical data structure. Hierarchy captures the parent-child relationship often between the same object. For instance a company structure captures the reporting line between employees. Business organization captures the relationship...
Relational to NoSQL – CRM Application Data Visibility
As a follow up to my previous webcast on the subject of Relational to NoSQL database where I discussed that we are in the third phase of the NoSQL database adoption, the “Broad Replatforming” of Enterprise Application. I want to provide...
JSON to Insights: Fast and Easy
Co-author: Sitaram Vemulapalli, Principal Engineer, Couchbase R&D. “The answer my friend is hiding in JSON” – Bob Dylan There are a lot of public JSON datasets and then is awesome JSON datasets. Every company, including yours, has stored a lot of...
NDP Episode #25: Nathan Voxland on Liquibase
Liquibase is the focus of the latest episode of The NoSQL Database Podcast. Nathan Voxland joins as the special guest to talk about source control for your database. I’m also joined by special co-host Denis Rosa, a developer advocate who...
YCSB-JSON: Implementation for Couchbase and MongoDB
YCSB is a great benchmarking tool built to be easily extended by any driver which supports and implements basic operations like: insert, read, update, delete and scan. Plain synthetic data introduced by YCSB fits this paradigm perfectly. But when it comes...
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...
How to Join JSON: Couchbase N1QL vs. MongoDB Query
As NoSQL databases evolved, each added higher level APIs or languages to help programmers to complex things easily. SQL, having done that for relational data, showed the way. In SQL, developers say WHAT needs to be done and the database...
Data Modeling for Couchbase with erwin DM NoSQL
Given the architecture and design of NoSQL systems, especially the document family databases like Couchbase that do not enforce schema on write, data modeling for NoSQL can often be challenging when migrating from relational systems to NoSQL or when building...
A Guide to N1QL features in Couchbase 5.5: Special Edition
N1QL was first released with Couchbase 4.0 in the fall of 2015. After two and a half years, it’s great to release Couchbase 5.5 and this N1QL 5.5 feature booklet with it at the New York Couchbase Connect. This special...
New Features in Index Service in Couchbase Server 5.5
In the last major release, Couchbase Server 5.0, we introduced Plasma – New Storage Engine and also the support for Index Replicas in the Index Service. We have continued to build on these new features in our upcoming release. The themes...