Project Description
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.
What is New?
- Nov 14, 2010: Chinook Database 1.3 has been released! In this release we added two more databases to the supported database list: SQLite and EffiProz. EffiProz is a cross-platform embedded database written entirely in C#.
- Nov 5, 2010: Chinook Database 1.2 has been released! This new version includes bug fixes such as making primary key indexes unique, setting the name of primary key constraints, drop database if it exists. It also provides alternative versions where IDENTITY/AUTOINCREMENT is off, so that it can be used with NHibernate HiLo persistent object identity (POID) strategy.
Supported Database Servers
Data Model
The Chinook data model represents a digital media store, including tables for artists, albums, media tracks, invoices and customers. You can see the Chinook data model
here.
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 here.
- 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.