Chinook sample database
The Chinook sample database for a digital media store can be used to explore and learn Yugabyte DB.
About the Chinook database
The Chinook data model represents a digital media store, including tables for artists, albums, media tracks, invoices and customers.
- Media-related data was created using real data from an Apple iTunes library.
- Customer and employee information was created using fictitious names and addresses that can be located on Google maps, and other well formatted data (phone, fax, email, etc.)
- Sales information was auto generated using random data for a four year period.
The Chinook sample database includes:
- 11 tables
- A variety of indexes, primary and foreign key constraints
- Over 15,000 rows of data
For details, here’s the entity relationship diagram of the Chinook data model.
Install the Chinook database
Follow the steps here to download and install the Chinook sample database.
Before you begin
To install and use the Chinook sample database, you need to have installed and configured Yugabyte DB. To get up and running quickly, see Quick Start.
1. Download the SQL scripts
You can download the Chinook database that is compatible with Yugabyte DB from the
sample directory of the Yugabyte DB GitHub repository. Download the following three files.
chinook_ddl.sql— Creates the tables and constraints
chinook_genres_artists_albums.sql— Loads artist and album information
chinook_songs.sql— Loads individual song information
2. Open the YSQL shell
To open the YSQL shell, run the
ysqlsh (11.2) Type "help" for help. postgres=#
3. Create the Chinook database
To create the
chinook database, run the following command.
CREATE DATABASE chinook;
Confirm that you have the
chinook database by using the
\l command to list the databases on your cluster.
Connect to the
postgres=# \c chinook You are now connected to database "chinook" as user "postgres". chinook=#
4. Build the tables and objects
To build the tables and database objects, run the following
chinook=# \i /Users/yugabyte/chinook_ddl.sql
You can verify that all 14 tables have been created by running the
5. Load the sample data
To load the
chinook database with sample data, you need to run the SQL scripts.
First, run the SQL script to load the genres, artists, and albums.
chinook=# \i /Users/yugabyte/chinook_genres_artists_albums.sql
Next, run the SQL script to load the songs.
chinook=# \i /Users/yugabyte/chinook_songs.sql
Now verify that you have data by running a simple
SELECT statement to pull some data from the
chinook=# SELECT "Name", "Composer" FROM "Track" LIMIT 10;
Name | Composer ---------------------------------+------------------------------------------------------------ Boa Noite | The Memory Remains | Hetfield, Ulrich Plush | R. DeLeo/Weiland The Trooper | Steve Harris Surprise! You're Dead! | Faith No More School | Kurt Cobain Sometimes I Feel Like Screaming | Ian Gillan, Roger Glover, Jon Lord, Steve Morse, Ian Paice Sad But True | Apocalyptica Tailgunner | Tempus Fugit | Miles Davis (10 rows)
Explore the Chinook sample database
That’s it! Using the command line or your favorite PostgreSQL development or administration tool, you are now ready to start exploring the chinook database and Yugabyte DB features.