Sample models

Model-Driven
API Generation
Swagger
OpenAPI
JSON
Avro
Parquet
Protobuf
BigQuery
Cassandra
DataStax
Cosmos DB
Couchbase
Delta Lake
Databricks
DynamoDB
Elasticsearch
EventBridge
Schema Registry
Glue
Data Catalog
HBase
Hive
JanusGraph
MariaDB
MarkLogic
MongoDB
Neo4j
Neptune-Gremlin
Oracle and
Autonomous
PostgreSQL
ScyllaDB
Snowflake
SQL Server
Azure SQL
Synapse
TinkerPop

Sample models

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

You may also clone the repository of all the sample models below.

Model-driven API generation template

Samples for Avro schema

Avro schema samples

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

Sample BigQuery data model

BigQuery data model samples

Sample for Cassandra DataStax data model

Cassandra DataStax data model samples

Sample for Cosmos DB data model schema

Cosmos DB data model samples

Here are some useful resources to be reviewed along with using Hackolade for Cosmos DB data modeling:

Model:

Sample for Couchbase data model schema

Couchbase data model samples

Here are some useful resources to be reviewed along with using Hackolade for Couchbase data modeling:

Models:

  • travel: travel-sample application described here
  • beer: beer-sample application described here
  • games: games-sample application described here
Sample Databricks data model

Databricks data model sample

Samples for DynamoDB data model schema

DynamoDB data model sample

Here are some useful resources to be reviewed along with using Hackolade for DynamoDB data modeling:

Models:

Samples for Elasticsearch data model mappings

Elasticsearch data model samples

Here are some useful resources to be reviewed along with using Hackolade for Elasticsearch data modeling:

Models:

Samples for Amazon EventBridge Schema Registry

EventBridge Schema Registry sample

AWS Glue Data Catalog schema samples

Here are some useful resources to be reviewed along with using Hackolade for Glue Data Catalog modeling:

Models:

Samples for Apache HBase data model

HBase data model samples

Here are some useful resources to be reviewed along with using Hackolade for HBase schema design:

Models:

Samples for Apache Hive data model

Hive data model samples

Here are some useful resources to be reviewed along with using Hackolade for Hive schema design:

Models:

Sample of JanusGraph data model

JanusGraph data model sample

JSON data sample

  • JSON example: a model derived after reverse-engineering of documents on : JSON.org
  • Car sales: a made-up example showing a relationship between 2 documents
Samples for MariaDB data model

MariaDB data model samples

Samples for MongoDB data model schema design

MongoDB data model samples

Here are some useful resources to be reviewed along with using Hackolade for MongoDB schema design:

Models: 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
  • Socialite: derived from the Open Source Status Feed
  • USDA nutrition: single collection model of the USDA nutrition DB
Sample of Neptune data model samples

Neptune data model samples

Samples for Oracle data model

Oracle and Autonomous

Samples for Apache Parquet schema

Parquet schema samples

Here are some useful resources to be reviewed along with using Hackolade for Parquet schema design:

Models:

  • sample model: Other sample Parquet files can be found here and be reverse-engineered
Sample PostgreSQL data models

PostgreSQL data model samples

Sample protobuf data model

Protobuf data model samples

Samples for ScyllaDB data model

ScyllaDB data model samples

Samples for Snowflake data models

Snowflake data model samples

Samples for SQL Server Azure SQL data model

SQL Server & Azure SQL data model samples

Samples for Swagger OpenAPI model

Swagger & OpenAPI API design samples

Here are some useful resources to be reviewed along with using Hackolade for the visual design of Swagger APIs:

Here are some useful resources to be reviewed along with using Hackolade for the visual design of OpenAPI:

Samples for Azure Synapse data model

Azure Synapse data model samples

Samples for TinkerPop Gremlin data model schema

TinkerPop gremlin data model samples