Skip to content
プロジェクト

lerocha/chinook-database

GitHubで見る

lerocha/chinook-database has 2,645 GitHub stars and 762 forks. GitHot measured 0 stars in 24 hours, +2 in 7 days, and +14 in 15 days. Last checked 2026-11-22 03:17 UTC. Last push 2025-10-05.

この数値の測り方

計測したスター増加

24時間
0
7日間
+2
15日間
+14
1か月
履歴を収集中

期間ごとの純増数です。期間は重複しており、日別の値ではありません。未計測の値は空欄です。スター数は注目度の指標であり、品質の保証ではありません。

概要

SQL Server、Oracle、MySQL、PostgreSQL、SQLite、DB2 向けのサンプルデータベース

データ

Chinook Database

Chinook is a sample database available for SQL Server, Oracle, MySQL, etc. It can be created by running a single SQL script. Chinook database is an alternative to the Northwind database, being ideal for demos and testing ORM tools targeting single and multiple database servers.

Supported Database Servers

  • DB2
  • MySQL
  • Oracle
  • PostgreSQL
  • SQL Server
  • SQLite

Download

Download the SQL scripts from the latest release assets. One or more SQL script files are provided for each database vendor supported. You can run these SQL scripts with your preferred database tool.

Update: Check out the Netflix Sample Database, a sample database with movies and TV shows based on the data from the Netflix Engagement Report and the Netflix Global Top 10 weekly list.

Data Model

The Chinook data model represents a digital media store, including tables for artists, albums, media tracks, invoices and customers.

image

Sample Data

Media related data was created using real data from an iTunes Library. It is possible for you to use your own iTunes Library to generate the SQL scripts, see instructions below. Customer and employee information was manually created using fictitious names, addresses that can be located on Google maps, and other well formatted data (phone, fax, email, etc.). Sales information is auto generated using random data for a four year period.

Why the name Chinook?

The name of this sample database was based on the Northwind database. Chinooks are winds in the interior West of North America, where the Canadian Prairies and Great Plains meet various mountain ranges. Chinooks are most prevalent over southern Alberta in Canada. Chinook is a good name choice for a database that intents to be an alternative to Northwind.

Development

System Requirements:

  • .NET 8
  • dotnet-t4 (command-line tool for processing T4 templates): dotnet tool install --global dotnet-t4

Notes:

  • You only need the dotnet and dotnet-t4 tools to build and generate the scripts in any OS (macOS, Linux, or Windows).
  • If you need an IDE, you can use Visual Studio Code and install the recommended plugins. Alternatively, you can also use JetBrains Rider or Visual Studio Community Edition (Windows only).
  • The SQL scripts are auto-generated using Text Template Transformation.
  • The ChinookDataSet.xsd file contains the schema definition, ChinookData.json contains the data, and the *.tt files are the text templates that are used to generate all SQL scripts.

Build, auto-generate the SQL scripts, and testing:

# Build and generate the SQL scripts.
dotnet build

# Start the local databases to test the generated scripts.
docker compose up -d

# Run all the tests.
dotnet test

関連プロジェクトを探す

読み込み中…