lerocha/chinook-database
Chinook Database
This project is a relational SQL sample database and synthetic testing dataset. It provides a standardized data model of a fictional digital media store, encompassing business entities such as artists, albums, tracks, customers, and invoices.
The dataset is designed as a cross-dialect SQL collection, using compatible scripts to ensure consistent data seeding and environment parity across different database server engines. It combines imported metadata with fictitious personal details to create realistic records for software prototyping and demonstrations.
The project covers capabilities for relational schema modeling and the generation of sample datasets. These resources are used to validate database query results, verify relational mapping logic, and test object-relational mapping tooling.
Features
- Sample Databases - Provides a comprehensive sample database and dataset for software prototyping and demonstrations.
- Relational Test Datasets - Combines real-world metadata with fictitious details to create realistic relational datasets for testing.
- Relational Testing Datasets - Provides realistic mock records and relational mappings to validate database query results.
- Entity Relationship Models - Defines a standardized set of entities and relationships representing a digital media store.
- Relational Data Modeling - Implements a relational data model representing artists, albums, tracks, customers, and invoices.
- SQL Dialect Adapters - Provides SQL scripts designed to be compatible across multiple different database server engines.
- Cross-Dialect Datasets - Ships a collection of database scripts compatible with multiple SQL engines for consistent data seeding.
- SQL Sample Databases - Provides a fictional media store relational dataset for testing SQL queries and schemas.
- Synthetic Dataset Generation - Generates realistic database content based on a media store schema for software prototyping.
- Data Seeding Utilities - Includes utilities to populate database instances with consistent records for testing and demonstrations.
- Reference Data Population - Ships with a complete set of standardized reference records within the deployment scripts.
- Dialect Transformers - Populates identical datasets across different SQL server types to maintain environment parity.
- Public Data APIs - Sample SQL database for teaching and testing.
