What is Sakila?

Skip to end of metadata
Go to start of metadata

What is Sakila?

Sakila is the official name of the MySQL dolphin (the logo).

The name comes from a competition to name the dolphin. The winning name was submitted by Ambrose Twebaze, an Open Source software developer from Swaziland, Africa. According to Ambrose, the name Sakila has its roots in SiSwati, the local language of Swaziland. Sakila is also the name of a town in Arusha, Tanzania, near Ambrose's country of origin, Uganda.

Get the Sakila Sample Database

Download the database from the Sakila Download page on the MySQL Documentation Site.

The Sakila Sample database includes documentation for installation and descriptions of database objects. Also included in a MySQL Workbench Schema definition and appropiate image.

Contributions

From the talk at the MySQL Users Conference 2006

Notes by Sheeri Kritzer

Other

Updates by Ronald Bradford

About the Sakila Sample Database

Why is this needed?

The documentation current sample "world” database has just 3 tables, cities, countries and langs.

  • Not the Intellectual Property of MySQL, so it can't be bundled with the software
  • No table type diversity, not a lot of data type diversity
  • No MySQL 5 features
  • Not a lot of data
  • Not really used in tutorials and articles because it's not robust enough

Scenario

Basically, needed a sample database that was new, that allowed for many queries. Used an idea from a Dell Sample DB It's 2 stores, in 2 different countries.

Designing the Database

Designed with MySQL Query Browser

  • Normalized
  • Community provided feedback and content
  • Trick was balance between simplicity and completeness
  • Learning db, so people need to understand it
  • After schema was approved, data was loaded
  • Stored procedures, triggers, UDF's and VIEWS were used

Schema

The Sample database has 2 files in installation

  • one for schema & routines (16 tables, 8 views)
  • one for data

This allows you can just look at schema if you want. You can also support modified data sources, for example larger volumes or different languages.

Data is never deleted — it's marked as deleted, but not actually deleted, for data integrity reasons. Contains most (all?) data types, including SET and ENUM.

VIEWS

VIEWS used to simplify queries. ie, there's a table for actors and one for films, so actor_info contains a list of type of movie and name for each actor. So it would show a list of actors with a list of films that they've done — 1 row per actor, and a comma-separated list of films they've done (sorted by type). There are a lot of good views in there, which show that that's what you should do for popular queries (like "show me all the movies that are rented, by customer”).

Stored Procedures

For common procedures — ie, is a film in stock?

Stored Functions

get_customer_balance — it does what you think it does.

Triggers

There's one to sync 2 tables, for example.

Licensing

PostgreSQL want to do Documentation copyright MySQL BSD licensing

Goals Going Forward

Make as few changes as possible Implement 5.1 changes if necessary

Labels:
None
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.

Sign up or Log in to add a comment or watch this page.


The individuals who post here are part of the extended Oracle community and they might not be employed or in any way formally affiliated with Oracle. The opinions expressed here are their own, are not necessarily reviewed in advance by anyone but the individual authors, and neither Oracle nor any other party necessarily agrees with them.