NoSQL sample models: MongoDB, Neo4j,
Cassandra, Avro, JSON, Hive,
Elasticsearch, Couchbase, DynamoDB, etc...

After download, open the models using Hackolade, and learn through the examples how to leverage the modeling power of the software.

NoSQL sample schemas for MongoDB

Here are some useful resources to be reviewed along with using Hackolade for MongoDB schema design:
- Book: Rick Copeland: MongoDB Applied Design Patterns: Practical Use Cases with the Leading NoSQL Database
- Book: Christian Amor Kvalheim: The Little Mongo DB Schema Design Book
- Book: Steve Hoberman: Data Modeling for MongoDB
- Article: MongoDB Data Modeling Introduction
- Article: Building MongoDB schemas with patterns

Hackolade data models available for download:
- Yelp Challenge Dataset : schema inferred from the reverse-engineering of a Yelp Challenge dataset - Buzzfeed : model derived from the very good article , a blog series on how to use MongoDB, Mongoose Object Data Mapping (ODM) with Express.js and Node.js. The article describes the steps required to build an RSS Aggregator application, similar to Google Reader.
- GeoSpatial : introduction to MongoDB Geospatial feature derived from this blog post
- GeoJSON : a Hackolade model with the different geometry structures of GeoJSON to be used as an external reference definition.
- Kansas City Fountains : this model is drawn from an exercise in Steve Hoberman's class on 'Advanced modeling for NoSQL'. It is asked to model donations where the donor can either be an individual or a corporation, each requiring different fields. An good introduction to the concept of polymorphism.
- NOAA : ocean weather buoys info
- Northwind Oracle normalized : the famous Microsoft Access example, reverse-engineered from an Oracle DDL found here
- Northwind Oracle denormalized : the same database as above, except it has been denormalized to illustrate the power of JSON and NoSQL
- ourAirports : model derived from this free site where visitors can explore the world's airports, read other people's comments, and leave their own
- purchaseOrder : derived from this Oracle JSON article
- sales : basic demo of a sales application data model, with denormalization of some master data
- socialNetwork : to showcase Hackolade capabilities
- USDA nutrition : single collection model of the USDA nutrition DB

NoSQL sample data models for Cassandra

Here are some useful resources to be reviewed along with using Hackolade for Cassandra data modeling:
- Book: Jeff Carpenter: Cassandra: The Definitive Guide: Distributed Data at Web Scale
- Article: Basic Rules of Cassandra Data Modeling
- Article: Cassandra Data Model Meets World

- Hotel reservations : an application derived from: Cassandra: the Definitive Guide from O'Reilley with code from GitHub: hotel and GitHub: reservation
- Video DB : an application derived from: GitHub: videodb tutorial

NoSQL example data models for Neo4j

Here are some useful resources to be reviewed along with using Hackolade for Neo4j data modeling:
- Book: Ian Robinson: Graph Databases: New Opportunities for Connected Data
- Book: Rik Van Bruggen: Learning Neo4j 3.x - Second Edition: Effective data modeling, performance tuning and data visualization techniques in Neo4j
- Book: Mahesh Lal: Neo4j Graph Data Modeling
- Book: Thomas Frisendal: Graph Data Modeling for NoSQL and SQL
- Article: Neo4j Graph Modeling Guidelines

Here is a list of models derived either from the Neo4j sandboxes or the local installation of Neo4j:
Lexis Graph, Movies, Network and IT, NICAR, Northwind, Panama Papers, Paradise Papers, Recommendations, Russian Twitter Trolls, Trump World.

Sample for Avro schema

Here are some useful resources to be reviewed along with using Hackolade for Avro schema design:
- Documentation: Avro schema specification

- Ordering system : an application derived from: (c) Tresselle's Advanced Avro: Schema Design & Reuse

NoSQL sample data model for Apache Hive

Here are some useful resources to be reviewed along with using Hackolade for Hive schema design:
- Technical paper: Data Modeling Considerations in Hadoop and Hive
- Documentation: Hive Data Types HQL

- Ordering system : an application derived from: (c) Cloudera's Getting Started with Hadoop Tutorial

NoSQL sample schema for Apache HBase

Here are some useful resources to be reviewed along with using Hackolade for HBase schema design:
- Documentation: Apache HBase specification
- Technical paper: Introduction to HBase Schema Design

- HBase Users : HBase row key multidimentional map derived from: Introduction to HBase Schema Design

NoSQL sample data models for Elasticsearch

Here are some useful resources to be reviewed along with using Hackolade for Elasticsearch data modeling:
- Book: Learning Elastic Stack 6.0: A beginner's guide to distributed search
- Article: Elasticsearch: modeling your data

- movieLens : a recommendations application derived from this example
- logstash : a model reverse-engineered from this example

NoSQL sample data models for Couchbase

Here are some useful resources to be reviewed along with using Hackolade for Couchbase data modeling:
- Book: Henry Potsangbam: Learning Couchbase
- Article: Couchbase Phases of Data Modeling
- Article: SQL to JSON Data Modeling with Hackolade

- travel : travel-sample application described here
- beer : beer-sample application described here
- games : games-sample application described here

NoSQL sample schema for MarkLogic

Here are some useful resources to be reviewed along with using Hackolade for MarkLogic schema design:
- Article: Rethink MarkLogic data modeling
- Article: MarkLogic Data Model

- Ordering system : an application derived from: (c) Mike Bowers's EDW NoSQL data modeling course

NoSQL example schema for Cosmos DB

Here are some useful resources to be reviewed along with using Hackolade for Cosmos DB data modeling:
- Article: Modeling document data for Cosmos DB NoSQL databases

- travel : travel-sample application described here

NoSQL sample schemas for DynamoDB

Here are some useful resources to be reviewed along with using Hackolade for DynamoDB data modeling:
- Article: Best Practices for DynamoDB schema design

- DynamoDB examples : derived from the examples on AWS described here
- Music and Movies : created based on AWS examples described here and here
- Messaging : derived from the example discussed in this video
- Social Network : derived from the example discussed in this video
- Real-time voting : derived from the example discussed in this video

Examples for JSON

- bpost address formatting : schema definition of REST formatting webservice by the Belgian postal operator, described here
- bpost address validation : schema definition of REST validation webservice by the Belgian postal operator, described here