Introduction

The Chinook database is a sample database available for many DBMS platforms. It represents a digital media store, with data such as albums, artists, tracks and invoices.

https://chinookdatabase.codeplex.com/

An entity-relationship diagram for the Chinook sample database is here:

https://chinookdatabase.codeplex.com/wikipage?title=Chinook_Schema

For demonstration purposes, we provide a SQLite version of Chinook and a simple star schema that supports analysis of sales by date, location and track.

Database Location

The Chinook sample database may be found in the following location:

Microsoft Windows:

c:\ajilius\samples\chinook.sqlite

Linux and OSX

/opt/ajilus/samples/chinook.sqlite

Next Steps

Logon to Ajilius, and open the metadata for the sample data warehouse.

Open metadata