Category: Data Modeling
How to use N1QL to migrate Oracle data into Couchbase
Getting the Couchbase server to run on your PC or Mac involves a few simple steps to download the software and spin up a cluster with all the Couchbase services that you need (https://docs.couchbase.com/server/6.0/getting-started/start-here.html). Sample buckets are available with the...
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...
Xamarin App Using the Query API & Couchbase Lite Database
Couchbase Lite 2.x is a powerful NoSQL embedded data store for iOS, Android and .Net Mobile Platforms. In an earlier tutorial, we explored the basics of Database and Document CRUD operations using Couchbase Lite within your Xamarin apps. In addition...
Tutorial: Get Started with Couchbase Lite 2.0 and Xamarin
Couchbase Mobile 2.0 brings the power of NoSQL JSON Document Store to iOS, Android and .Net Mobile Platforms. With Couchbase Mobile, you can build mobile applications with offline-only and offline-first capabilities. Couchbase Mobile supports flexible deployment options. You can deploy...
Introducing Couchbase.Lite.Mapping: A New Nuget Package
Couchbase Lite 2.0 is a powerful NoSQL embedded data store for iOS, Android and .Net Mobile Platforms. Couchbase Lite provides functionality such as database and document CRUD operations, brings powerful Query API with SQL-like semantics and Full-Text-Search (FTS) capabilities. Couchbase Lite Extensibility The Couchbase.Lite and Couchbase.Lite.Enterprise Nuget packages provide a broad...
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...