Skip to content

maglietti/ignite3-chinook-demo

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

32 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Ignite 3 Chinook Dataset Demo

A demonstration of Apache Ignite 3 Java API using the Chinook database model.

Overview

This project demonstrates how to use Apache Ignite 3's Java API with POJO-based table mapping. It implements the Chinook database, a sample database schema for a digital media store (similar to iTunes), to showcase various Ignite 3 features including:

  • Annotation-based table mapping
  • Distribution zones and storage profiles
  • Data co-location for optimized joins
  • CRUD operations with POJOs
  • SQL query execution
  • Transaction management
  • Bulk data loading from SQL files

Prerequisites

  • Java 17 or higher
  • Apache Maven 3.6 or higher
  • Docker and Docker Compose (for running Ignite nodes)

Quick Start

  1. Start the Ignite cluster
docker-compose up -d
  1. Initialize the cluster
docker run --rm -it --network=host -e LANG=C.UTF-8 -e LC_ALL=C.UTF-8 apacheignite/ignite:3.0.0 cli
connect http://localhost:10300
cluster init --name=ignite3 --metastorage-group=node1,node2,node3
exit
  1. Choose a setup method:

Option A: POJO-based setup (step-by-step)

# Create the database schema
mvn compile exec:java@create-tables

# Load sample data
mvn compile exec:java@load-data

Option B: Bulk loading (faster setup)

# Load both schema and data from SQL file
mvn compile exec:java@bulk-load
  1. Run the main application
mvn compile exec:java@run-main

Documentation

For detailed documentation, see the docs directory:

License

Apache License 2.0

About

How-To use the Ignite 3 annotations API

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages